Automatic categorisation of bank statements and a monthly review
Drop your bank's CSV export into a folder: the agent categorises spending in Google Sheets and emails you a review.
L3 autonomousVerified sourceBased on official documentation we checked; not tested by us yet. · updated 16/10/2026
- Difficulty
- Intermediate
- Setup time
- 1.5 h
- Estimated cost
- €0–5/month
- Category
- Personal productivity
⏱ Trigger
New CSV in the "Bank" Drive folder (event)
✋ Human approval
No access to your bank account: you provide the export.
→ Output
Sheets budget + review email
Autonomy level 3 — Autonomous: Runs end to end on its own; only low-risk actions (read, notify, archive).
01Connected tools
02What the agent does on its own
step 01
Detects the file.
step 02
Cleans the rows and categorises each transaction.
step 03
Appends everything to your budget sheet.
step 04
Sends a review (top spending, gaps vs budget).
03Agent instructions
$ instructions.txt · replace the {VARIABLES}
> Categorise each transaction into {CATEGORIES}. Return CSV date;label;amount;category. If unsure, use the category "To check".04Limits and legal points
Avoid sending IBANs and full names to the LLM: mask them first.
05Source
https://docs.n8n.io/integrations/builtin/trigger-nodes/n8n-nodes-base.googledrivetrigger/