Automated invoice payment reminders with Google Sheets and Gmail
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Function (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 5 nodes and runs on a schedule (every day). Along the way it connects Google Sheets and Gmail.
How it runs
Trigger: On a schedule (every day).
- 2. Read Invoice Data (Google Sheets) (Google Sheets): uses Google Sheets
- 3. Filter & Prepare Reminders (Function): runs custom JavaScript (legacy Function node)
- 4. If Invoices to Remind? (If): checks a condition and branches into true / false
- 5. Send Invoice Reminder (Gmail) (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Function (legacy) in 3. Filter & Prepare Reminders: replace with Code node, mode 'Run Once for All Items'.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) 3. Filter & Prepare Reminders | Code node, mode 'Run Once for All Items' |
Nodes used (5)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Function
n8n-nodes-base.function - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail
From the author
How It Works ⚙️ This workflow systematically ensures you never miss sending an invoice reminder: 1. Daily Schedule Trigger: ⏰ The workflow starts automatically at a set time each day (e.g., every morning). This ensures continuous monitoring of your invoice…