Oka Hironobu This workflow corresponds to n8n.io template #13980 — we link there as the canonical source.
This workflow follows the Chainllm → Gmail recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "c0b8d443-c42f-45c6-b55e-79de7a2f1bc5",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
192,
272
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a1ea0611-e04f-46fc-9183-6c68d7566afb",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
688,
272
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a7f51387-6d8d-484e-8f85-ef15c8f3509f",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1440,
272
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c8bbaa96-b2a2-46ca-9e49-a5e798358e8b",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
2192,
272
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d8f42915-8a85-42c3-bedb-708323090a58",
"name": "Daily Reconciliation",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
752,
480
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e3455d40-5aaa-4054-a713-0567e0749dbd",
"name": "User Settings",
"type": "n8n-nodes-base.set",
"position": [
992,
480
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "dd56c614-41fb-478c-a610-84a2e9c6fe80",
"name": "Fetch Stripe Transactions",
"type": "n8n-nodes-base.httpRequest",
"notes": "Set up HTTP Header Auth with Name: Authorization, Value: Bearer sk_live_YOUR_KEY",
"position": [
1232,
432
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "72291198-c351-4afe-88c3-ee0bf56c7158",
"name": "Read Accounting Ledger",
"type": "n8n-nodes-base.googleSheets",
"position": [
1232,
656
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "b4d9172d-08b0-460c-979d-b0868a508dbd",
"name": "Reconciliation Logic",
"type": "n8n-nodes-base.code",
"position": [
1472,
480
],
"parameters": {},
"typeVersion": 2
},
{
"id": "09e2e13a-4f3b-4df5-b309-5b9a56133559",
"name": "Has Discrepancies?",
"type": "n8n-nodes-base.if",
"position": [
1712,
480
],
"parameters": {},
"typeVersion": 2
},
{
"id": "43c5992e-e5b7-48f8-b2ff-04592faaa90e",
"name": "Prepare AI Analysis",
"type": "n8n-nodes-base.set",
"position": [
1952,
480
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "2b8d9bef-94ec-46eb-9d9d-69654109a0da",
"name": "AI Discrepancy Analysis",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
2240,
480
],
"parameters": {},
"typeVersion": 1.4
},
{
"id": "232ea342-2c12-4c81-8ad4-723048148e17",
"name": "Gemini AI Model",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
2240,
656
],
"parameters": {},
"typeVersion": 1
},
{
"id": "49566a82-0f5e-4cf6-a26b-1b7caf5ee9c4",
"name": "Format Analysis Results",
"type": "n8n-nodes-base.code",
"position": [
2544,
480
],
"parameters": {},
"typeVersion": 2
},
{
"id": "f4372e1f-7075-4885-aa62-4fea6b6849f2",
"name": "Log to Reconciliation Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
2784,
480
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "d834b2b0-c92e-4112-96f4-af43f821fdcd",
"name": "Send Slack Alert",
"type": "n8n-nodes-base.slack",
"position": [
2784,
688
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "c7f31469-1dcc-40d3-bc88-0a0e52b55a56",
"name": "Is Monday?",
"type": "n8n-nodes-base.if",
"position": [
3040,
480
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a72af1b8-e10f-48bb-ad13-941eff154e92",
"name": "Send Weekly Email Report",
"type": "n8n-nodes-base.gmail",
"position": [
3232,
464
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "c64c9e7d-f2ed-427c-8edb-725de2fb3f2b",
"name": "Workflow Complete",
"type": "n8n-nodes-base.set",
"position": [
1712,
688
],
"parameters": {},
"typeVersion": 3.4
}
],
"connections": {
"Is Monday?": {
"main": [
[
{
"node": "Send Weekly Email Report",
"type": "main",
"index": 0
}
]
]
},
"User Settings": {
"main": [
[
{
"node": "Fetch Stripe Transactions",
"type": "main",
"index": 0
},
{
"node": "Read Accounting Ledger",
"type": "main",
"index": 0
}
]
]
},
"Gemini AI Model": {
"ai_languageModel": [
[
{
"node": "AI Discrepancy Analysis",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Has Discrepancies?": {
"main": [
[
{
"node": "Prepare AI Analysis",
"type": "main",
"index": 0
}
],
[
{
"node": "Workflow Complete",
"type": "main",
"index": 0
}
]
]
},
"Prepare AI Analysis": {
"main": [
[
{
"node": "AI Discrepancy Analysis",
"type": "main",
"index": 0
}
]
]
},
"Daily Reconciliation": {
"main": [
[
{
"node": "User Settings",
"type": "main",
"index": 0
}
]
]
},
"Reconciliation Logic": {
"main": [
[
{
"node": "Has Discrepancies?",
"type": "main",
"index": 0
}
]
]
},
"Read Accounting Ledger": {
"main": [
[
{
"node": "Reconciliation Logic",
"type": "main",
"index": 0
}
]
]
},
"AI Discrepancy Analysis": {
"main": [
[
{
"node": "Format Analysis Results",
"type": "main",
"index": 0
}
]
]
},
"Format Analysis Results": {
"main": [
[
{
"node": "Log to Reconciliation Sheet",
"type": "main",
"index": 0
},
{
"node": "Send Slack Alert",
"type": "main",
"index": 0
},
{
"node": "Is Monday?",
"type": "main",
"index": 0
}
]
]
},
"Fetch Stripe Transactions": {
"main": [
[
{
"node": "Reconciliation Logic",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
SMB finance teams, SaaS companies, and accounting professionals who need to automate transaction reconciliation between Stripe payments and their accounting ledgers. Perfect for businesses processing dozens to hundreds of daily transactions.
Source: https://n8n.io/workflows/13980/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Categories Content Creation AI Automation Publishing Social Media
Automatically identifies overdue sales leads and generates personalized follow-up emails using AI. Runs every weekday Reads leads from Google Sheets Filters leads with no contact for 5+ days Downloads
DevOps engineers, site reliability teams, and business owners who need to know the moment their website goes down — and want AI-powered diagnostics instead of just a ping alert.
This workflow is the AI analysis and alerting engine for a complete social media monitoring system. It's designed to work with data scraped from X (formerly Twitter) using a tool like the Apify Tweet
Automate your lead intake, scoring, and outreach pipeline. This workflow collects leads from forms, enriches and scores them using Relevance AI, routes them by quality, and triggers the right follow-u