Chase invoices that are 30 days or more overdue
Every Monday, reminds each customer of invoices 30+ days overdue and sends you the total owed.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1Google SheetsRead rowsFinds unpaid invoices 30 or more days past due and adds up what is owed.
If
overdue.countis more than 0For each
customerIf
customer.keyis not empty- 2GmailSendReminds each customer, then sends you the summary.
- 2
- 3GmailSend
How it works
What happens on each run, in plain English.
Chasing late payers is a Monday chore that is easy to skip. Every Monday this reads your invoices sheet, leaves out anything marked Paid, and finds the invoices that are 30 or more days past their due date.
Each customer gets one friendly email listing all of their overdue invoices, and you get a table of what every customer owes with the grand total. Invoices with no customer email are not chased, but still appear in your table so none go unnoticed.
You may also be interested in
Approve expense claims from a Google Form by amountSmall expense claims are approved automatically; claims over $500 go to your finance manager.
Approve big invoices, then bill them in QuickBooksReads each emailed invoice, asks your finance director to approve big ones, then records the bill in QuickBooks and your log.
Win back customers who cancelEmails a customer whose Stripe subscription ended, asking why or asking them to update their card, and logs it in a sheet.Rent reminders and late noticesEmails tenants a reminder 3 days before rent is due and a late notice 5 days after, copying the property manager.Start from a workflow that already works.
Add "Chase invoices that are 30 days or more overdue" to your workspace, connect its apps, and make it yours.
Free plan, no credit card