08 / 13Google Sheets
Record that the reminder went out
After each Gmail node, add a Google Sheets → Update Row node writing the stage number into LastReminder, matched on the Invoice column.
Without this, the Code node's guard has nothing to check and the same client gets chased daily.
5 things to set here- 1Open the Google Sheets node — double-click it on the canvas
- 2Operation — copy the value below
- 3Matching Column — copy the value below
- 4LastReminder — paste as an expression
- 5Check before moving on — The invoice row shows LastReminder set to the stage just sent.
Operation
Update Row
Matching Column
Invoice
LastReminderexpression
{{ $json.stage }}Watch out
This is the step people skip. Skipping it turns a helpful automation into harassment.
Checkpoint
The invoice row shows LastReminder set to the stage just sent.