03 / 13Filter
Keep only the unpaid, overdue ones
Add a Filter node with two conditions joined by AND: status is , and the due date is in the past.
Everything after this point assumes an invoice is genuinely overdue, so get this right before moving on.
4 things to set here- 1Open the Filter node — double-click it on the canvas
- 2Condition 1 — paste as an expression
- 3Condition 2 — paste as an expression
- 4Check before moving on — Only unpaid invoices past their due date pass through.
Condition 1expression
{{ $json.Status }} equals unpaidCondition 2expression
{{ $json.DueDate }} is before {{ $now.toISO() }}Watch out
Mark invoices paid in the sheet the same day you get the money. This workflow is only as polite as your sheet is accurate.
Checkpoint
Only unpaid invoices past their due date pass through.