Automation library · Money admin

Reconcile Stripe, bank, and e-commerce data with OpenAI

Started by a clock, and works across Gmail, Google Sheets and Stripe. It hands the judgement calls to OpenAI. 23 steps: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI

Download free
23 stepsLarge: read it before trusting it with anything live
0Branches: places the flow splits
0Loops or waits
3Services it connects to

The flow

Starts it 1Model 13Logic 3Service 6

The steps in the order they run, from what starts it.

  1. 1Schedule TriggerSchedule triggerStarts it
  2. 2OpenAI Model - OrchestratorLm Chat Open AiModel
  3. 3OpenAI Model - Mismatch DetectionLm Chat Open AiModel
  4. 4OpenAI Model - Root CauseLm Chat Open AiModel
  5. 5OpenAI Model - Ledger CorrectionLm Chat Open AiModel
  6. 6Orchestrator Output ParserOutput Parser StructuredModel
  7. 7Mismatch Detection Output ParserOutput Parser StructuredModel
  8. 8Root Cause Output ParserOutput Parser StructuredModel
  9. 9Ledger Correction Output ParserOutput Parser StructuredModel
  10. 10Calculator ToolTool CalculatorModel
  11. 11Workflow ConfigurationSetLogic
  12. 12Orchestrator AgentAgentModel
  13. 13Mismatch Detection Agent ToolAgent ToolModel
  14. 14Root Cause Analysis Agent ToolAgent ToolModel
  15. 15Ledger Correction Agent ToolAgent ToolModel
  16. 16Get Stripe TransactionsStripeService
  17. 17Get Bank Feed DataHttp RequestService
  18. 18Get Invoice DataHttp RequestService
  19. 19Get Ecommerce Platform DataHttp RequestService
  20. 20Apply Ledger CorrectionsCodeLogic
  21. 21Combine All Financial DataAggregateLogic
  22. 22Log Fixes to Google SheetsGoogle SheetsService
  23. 23Send Notification EmailGmailService

How it's built

Starts on
A clock
Steps
23
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Sheets, Stripe
Model
OpenAI

Questions

What does it need to run?

An n8n account, plus your own Gmail, Google Sheets and Stripe accounts, and a key for OpenAI. You connect your own accounts after importing it; none are included.

What starts it?

It starts on a clock.

Does it use AI?

Yes. It calls OpenAI. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 23 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 23 steps before you point it at anything that matters.