Skip to content

Rewrite from last

rewrite_from_last is an append_policy used with write_mode=append.

Behavior

  1. Takes the last date present on the sheet
  2. API range: last_sheet_date … today
  3. Deletes sheet rows from that date onward and rewrites the range

Not a positional "last row of the previous run" marker — the reference point is the date in the date column.

When to use it

When you need a hard rewrite of the tail from the last date, without the overlapping soft-refresh (−1 day) behavior.

Maintained by the LightLead Documentation Team · Last verified: 2026-07-26