Smart invoice collection system with GPT-4.1, Gmail & Google Sheets
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 12 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets, Gmail and OpenAI.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Google Sheets: uses Google Sheets
- Edit Fields (Edit Fields (Set)): sets 3 fields: daysSinceSent, email, firstName
- Filter: keeps only the items that match a condition
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Gmail: get many
- Aggregate: combines items into one
- Edit Fields (Edit Fields (Set)): sets 2 fields: textWithDate, followUpTemplateArray
- OpenAI: uses OpenAI
- Filter: keeps only the items that match a condition
- Gmail: work with draft
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 (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Filter
n8n-nodes-base.filter - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Gmail
n8n-nodes-base.gmail - Aggregate
n8n-nodes-base.aggregate - OpenAI
@n8n/n8n-nodes-langchain.openAi - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Smart Invoice Collection System with OpenAI, Gmail & Google Sheets Categories: Financial Automation, AI Business Tools, Cash Flow Management This workflow creates an intelligent invoice collection system that automatically follows up on overdue invoices using…