Finds reminders due
Each day, it picks Unpaid invoices whose next reminder date is due. The default stages are 3, 7 and 14 days after the due date.
Chasing unpaid invoices by hand is awkward and easy to forget. This Make.com template sends invoice payment reminders from your own Gmail, based on a simple Google Sheets invoice list. Once a day it finds overdue invoices and sends up to three short, polite invoice follow-ups: friendly, then firm, then final. Then it stops.
Mark an invoice Paid, Paused or Disputed to stop future reminders. Part-paid invoices can be set to Partial, which also stops automatic reminders.
One daily Make.com scenario that reads your Google Sheets invoice list and sends reminders from your connected Gmail. It runs in your own accounts; nothing runs through Flowpaja.
Each day, it picks Unpaid invoices whose next reminder date is due. The default stages are 3, 7 and 14 days after the due date.
Three short email texts are included and editable. The final reminder contains no threats, penalties or invented consequences.
Change one Status cell to stop future reminders. The sequence also stops after the final reminder, so it never chases forever.
Each invoice keeps a sending history, and a Log tab gets one row per email. A same-day guard helps prevent duplicate reminders.
A ready-to-import package for a DIY setup, with fictional examples and a test plan.
Make.com blueprint (.json)A ready-to-import scenario with no connections or account IDs inside. Connect your own Google account.Example Google Sheets file9 fictional invoices showing every case, plus a blank copy for your own invoice list.Three editable reminder emailsFriendly, firm and final messages, also included as plain text so you can review and edit them.9-page PDF setup guideStep-by-step import, connection, test plan and recovery steps.The sheet is the source of truth. You choose the schedule, review Test mode, and keep invoice statuses current.
Enter the client, email, amount, due date, optional payment link and Status in Google Sheets.
At a time you choose, the scenario finds Unpaid invoices whose next reminder is due.
It records the reminder in the row before sending from Gmail. By default, stages are 3, 7 and 14 days after the due date.
Each row shows reminders sent, last stage, last sent at, recipient, next reminder date and next action. The Log tab records each email.
Safety defaults help you check the workflow before any client receives a message.
It is a practical DIY template, not a hosted collections service.
Want to see how this kind of scenario is built first? Read our step-by-step guide: How to send automatic invoice payment reminders from Google Sheets with Make.com.
Make.com blueprint, example and blank Google Sheets files, three editable reminder emails and a 9-page setup guide. Delivered as a download on Gumroad.
30-day money-back guarantee: if the template isn't right for you, reply to your Gumroad receipt email within 30 days of purchase for a full refund.
Make, Google, Gmail and Google Sheets are trademarks of their owners. Flowpaja is independent and not affiliated with them.