Write Mode

There are three top-level modes. SoftRefresh / RewriteFromLast / Dumb are the append_policy values within append, not separate write_modes.

write_mode

Mode	Purpose
replace	Full sheet rewrite
append	Append / update the tail; behavior = append_policy
append_dedup	Append with dedup by key

append_policy (append only)

Policy	Meaning
soft_refresh	last date − 1 → today, refresh the tail (default wizard)
rewrite_from_last	from last date → today, delete and rewrite
dumb	blind append of the full API range

Details and diagrams: Write Modes.

Schedule

All three write_modes are compatible with schedule. Frequency limits depend on the plan (Free: no schedule; Solo: daily/weekly; Agency+: +hourly).