Automatic payment reminders
01 · The project
Automatic payment reminders
AUTOMATION · GOOGLE SHEETS · GMAIL02 · What I built
A demonstration automation for a small business: every morning it reads the invoice sheet, picks out what is overdue or falls due within three days, and sends the reminder already written. Anyone who has paid hears nothing.
03 · The result
Chasing payments stops depending on who remembers to write: reminders go out on their own, in the same tone for everyone, and late payments shorten without anyone having to chase.
Pick a row from the sheet: see what it decides and who actually gets written to.
1 / 3
Every morning at 8:00seven days a week
Reads the rows of the sheetone invoice per row
Invoice sheetthe one you already use
Marked as paid?
paidstill openHow long until it is due?
overduein three daysNo email at allwhoever paid hears nothing
Prepares the firm reminderwith a copy and the bank details
Copy of the invoiceattached as a PDF
Prepares the gentle reminderfriendly, two lines
Email sent to the clientand logged on the sheet
01 · Source
Invoice sheet, every morning at 8:00
02 · Decision
Reads the due date and the payment status
Overdue: firm reminder, with the invoice attached.
Every day03 · ActionSent
Email to the client
Subject: invoice 118 still open
It has been unpaid for 12 days. Copy and bank details attached.
Need something similar?
Let's talk