Reconcile Stripe, bank, and e-commerce data with GPT-4.1 and 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 23 nodes and runs on a schedule (every day at 02:00). Along the way it connects Stripe, OpenAI Chat Model, Google Sheets and Gmail.
How it runs
Trigger: On a schedule (every day at 02:00).
- Workflow Configuration (Edit Fields (Set)): sets 7 fields: stripeApiUrl, bankFeedApiUrl, invoiceApiUrl…
- Get Stripe Transactions (Stripe): get many (charge)
- Get Bank Feed Data (HTTP Request): calls an HTTP API
- Get Invoice Data (HTTP Request): calls an HTTP API
- Get Ecommerce Platform Data (HTTP Request): calls an HTTP API
- Combine All Financial Data (Aggregate): combines items into one
- Orchestrator Agent (AI Agent): runs an AI agent, with model: OpenAI Model - Orchestrator; 4 tools (Calculator, Ledger Correction Agent Tool, Mismatch Detection Agent Tool, Root Cause Analysis Agent Tool); output parser: Orchestrator Output Parser
- Apply Ledger Corrections (Code): runs custom JavaScript code
- Log Fixes to Google Sheets (Google Sheets): append or update
- Send Notification Email (Gmail): uses Gmail
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 (13)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Stripe
n8n-nodes-base.stripe - HTTP Request
n8n-nodes-base.httpRequest - Aggregate
n8n-nodes-base.aggregate - AI Agent
@n8n/n8n-nodes-langchain.agent - AI Agent Tool
@n8n/n8n-nodes-langchain.agentTool - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Calculator
@n8n/n8n-nodes-langchain.toolCalculator - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail
From the author
How It Works This workflow automates financial reconciliation by orchestrating multiple AI agents to detect mismatches, analyze root causes, and apply corrections across bank statements, invoices, and e-commerce platforms. Designed for finance teams,…