Chase unpaid invoices with Google Sheets, Gmail, and Claude
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 30 nodes and runs on a schedule (cron 0 9 * * 1-5) (plus 2 other triggers). Along the way it connects Google Sheets, Gmail and Anthropic Chat Model.
How it runs
Trigger: On a schedule (cron 0 9 * * 1-5) (plus 2 other triggers).
- Config (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- Read Invoices (Google Sheets): uses Google Sheets
- Validate Link Action (Code): runs custom JavaScript code
- Plan Follow-ups for Today (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- One Client at a Time (Loop Over Items (Split in Batches)): loops over the items in batches
- Update Sheet from Link (Google Sheets): update
- Show Confirm or Error Page (Respond to Webhook): sends the response back to the webhook caller
- Build Daily Digest (Code): runs custom JavaScript code
…plus 15 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (14)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Gmail
n8n-nodes-base.gmail - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Switch
n8n-nodes-base.switch - Split Out
n8n-nodes-base.splitOut - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
Quick overview This workflow runs on a schedule or manually to read unpaid invoices from Google Sheets, checks recent client email history in Gmail, uses Anthropic Claude to decide whether to send or pause reminders, then drafts or sends reminder emails and…