Chase Overdue Google Sheets Invoices Automatically via Email
This checks Google Sheets for invoices past their due date and sends a polite, escalating Email reminder to the client — so you get paid faster without the awkward manual chasing.
- 1
Step 1 — Schedule the check
Add a
Schedule Trigger(daily). - 2
Step 2 — Find overdue invoices
Add a
Google Sheetsnode returning unpaid invoices whose due date has passed, with the client contact and amount. - 3
Step 3 — Pick the right reminder
Add a
Switchon how many days overdue so tone escalates gently: a nudge at 3 days, firmer at 14, final notice at 30. - 4
Step 4 — Send via Email
Add an
Email Send(SMTP) node. Set the recipient, a clear subject, and build the body from the invoice number, amount due, and a payment link. Add your SMTP credentials (or use Gmail).
Frequently asked questions
Will it message paid invoices by mistake?
No — Step 2 filters to unpaid status straight from Google Sheets, so once an invoice is marked paid it drops out of the chase.
Can I CC my accounts team?
Yes — add them as a CC in the Email step, or branch a copy to a Slack channel so finance can see who's been chased.
Log Every Stripe Payment Into Google Sheets Automatically
Each successful Stripe charge is appended as a clean row in Google Sheets, giving you a live, reconciled revenue ledger without touching a spreadsheet.
n8nStripeGoogle Sheets
Auto-File Gmail Invoice Attachments Into Google Drive
This watches Gmail for invoices and receipts, extracts the key details, and files the attachment into Google Drive with a tidy name — so month-end reconciliation is already done.
n8nGoogle DriveGmailRescue Failed Stripe Payments With an Automatic Email Nudge
When a Stripe charge fails, this reaches the customer over Email with a friendly heads-up and an update-card link, and flags finance — recovering revenue that silent dunning would lose.
n8nStripe