Send invoice follow-ups, escalations, and weekly digests with Google Sheets and Gmail

by Faraz Shoaib ✓ · 21 views · created 2026-08-28 · Invoice Processing

What this workflow does

This workflow has 14 nodes and runs on a schedule (every day at 09:00) (plus 1 other trigger). Along the way it connects Google Sheets and Gmail.

How it runs

Trigger: On a schedule (every day at 09:00) (plus 1 other trigger).

1. Read Unpaid Invoices (Google Sheets): uses Google Sheets
2. Read Open Invoices (Google Sheets): uses Google Sheets
3. Prepare Invoice Follow Ups (Code): runs custom JavaScript code
4. Create Receivables Summary (Code): runs custom JavaScript code
5. Invoices Need Action? (If): checks a condition and branches into true / false
6. Has Open Invoices? (If): checks a condition and branches into true / false
7. Send Customer Reminder (Gmail): uses Gmail
8. Email Weekly Payment Digest (Gmail): uses Gmail
9. Log Reminder In Sheets (Google Sheets): append
10. Needs Finance Escalation? (If): checks a condition and branches into true / false

…plus 2 more steps. See the full node list below.

Services it uses

Google SheetsGmail

Before you upgrade to n8n 3.0

Nodes used (5)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if
• Gmailn8n-nodes-base.gmail

From the author

Quick overview Automate invoice follow-ups for freelancers, agencies, and small finance teams. This workflow scans unpaid invoices, sends due-soon and overdue reminders, logs every follow-up in Google Sheets, escalates high-risk overdue invoices, and emails a…

View the original on n8n.io → Check your own copy