Automate daily payment reminders and approvals with Google Sheets and Gmail

by AYLA BATOOL ✓ · 1 views · created 2026-10-10 · Invoice Processing, AI Summarization

What this workflow does

This workflow has 26 nodes and runs on a schedule (cron 0 9 * * 1-5) (plus 2 other triggers). Along the way it connects Google Sheets and Gmail.

How it runs

Trigger: On a schedule (cron 0 9 * * 1-5) (plus 2 other triggers).

1. Read Invoice Register (Google Sheets): uses Google Sheets
2. Read Reminder Audit Log (Google Sheets): uses Google Sheets
3. Read Approval Queue (Google Sheets): uses Google Sheets
4. Format Failure Record (Code): runs custom JavaScript code
5. Recheck Latest Payment Data (Google Sheets): uses Google Sheets
6. Combine Reporting Inputs (Merge): merges the data from its input branches
7. Log Workflow Failure (Google Sheets): append
8. Reconcile and Score Risk (Code): runs custom JavaScript code
9. Compile Daily Finance Summary (Code): runs custom JavaScript code
10. Alert Finance on Failure (Gmail): uses Gmail

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

Services it uses

Google SheetsGmail

Before you upgrade to n8n 3.0

Nodes used (7)

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

From the author

Quick overview This workflow checks a Google Sheets invoice register every weekday at 9:00 AM, emails Gmail payment reminders for overdue unpaid invoices, and appends each reminder to a Google Sheets log for auditing. How it works 1. Runs every weekday at…

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