Use Claude to categorize bank transactions in Google Sheets
Bank transactions sync to a sheet and Claude categorizes and analyzes them, with no budgeting app involved.
Setup steps
- Connect bank in SheetLink
- Install CLI
- Ask Claude to categorize/analyze
Steps summarized from the original Blog source ↗. Use “Copy” to grab them with the tools and source link, or copy an AI prompt.
How it went
Per the founder: a lookup table built from past tags handles about 95% of merchants, and Claude handles only new or unclear ones. On a recent batch it sorted most transactions automatically and left two for the author to decide. It also answered plain questions across 1,067 transactions.
Worth knowing
The author founded the sync tool used here (SheetLink), and the command-line and Claude access need its paid Max plan.
Only what the original source ↗ says, re-read Oct 17, 2026. How we write these
Try it with AI
Paste this into ChatGPT, Claude or your own agent for step-by-step help. Prompt written by AppToBot from this recipe's data, not by the original author. It keeps drafts for your review and asks before anything is sent or paid.
Help me set up this automation using Claude + Google Sheets (SheetLink): "Use Claude to categorize bank transactions in Google Sheets". Goal: replace Budgeting apps (Mint/YNAB-style). How it should work: - Trigger: Bank transactions sync - Then: Land in a Google Sheet - Then: Claude categorizes and analyzes - Result: Your own budget, no app Setup steps (summarized from the original source): 1. Connect bank in SheetLink 2. Install CLI 3. Ask Claude to categorize/analyze Guide me one step at a time. Ask me for anything you need (accounts, sheet or channel names) before you start. Safety rules: - Build and test with sample data first, and show me a sample result before anything goes live. - Keep anything that goes to other people (emails, posts, replies, record updates) as drafts for my review until I say otherwise. - Never send, post, buy, pay, delete or change records without my approval. - Tell me about any cost (paid plans, API usage) before I'd incur it, and help me set a spending limit. - Keep API keys and passwords out of shared docs and chats. - Privacy: Bank transactions flow to SheetLink and Claude. Based on: https://sheetlink.app/blog/built-sheetlink-categorize-with-claude
Tool names link to each official site (opens in a new tab).
App you replace: YNAB lists at $14.99/mo (or $109/yr) (vendor pricing page, list price as of Oct 2026, checked 2026-10-16). Your saving depends on what the bot costs you; see “Cost after”.
Running cost: Not reported Source says "Claude plan" without saying a paid one is required. No-code How we sort costs
Stack: Claude · Google Sheets
Replace an app: AI bots that replace budgeting apps (YNAB, Monarch, Mint-style)
App vs bot, side by side
| Old app / habit | Bot | |
|---|---|---|
| Tool | Budgeting apps (Mint/YNAB-style) | Claude + Google Sheets synced by SheetLink |
| Monthly cost | Not reported | Claude plan + SheetLink (free plan for basic sync; Max for Claude CLI use) |
| Setup | None (already in use) | Three commands (per author) · Beginner |
| Your time | Baseline | Not reported |
| Maintenance | Handled by vendor/you as before | Keep sync connected. |
| Privacy | Data stays with the app vendor | Bank transactions flow to SheetLink and Claude. |
Full comparison
| Replaces | Budgeting apps (Mint/YNAB-style) |
|---|---|
| Bot / agent stack | Claude + Google Sheets synced by SheetLink |
| Monthly cost before | Not reported |
| Monthly cost after | Claude plan + SheetLink (free plan for basic sync; Max for Claude CLI use) |
| Setup time | Three commands (per author) |
| Time saved | Not reported |
| Skill level | Beginner |
| Reliability | 3/5: founder blog post from the sync-tool vendor. |
| Maintenance | Keep sync connected. |
| Privacy & data | Bank transactions flow to SheetLink and Claude. |
| Best for | Spreadsheet-minded budgeters |
| Not for | People wanting a guided budgeting app |
Pros and cons
Pros
- Ask questions in plain English
- Custom categories
Cons
- Vendor-written source
- Bank data to third parties
Source and evidence
Founder blog post (vendor of the sync tool).
Read the original Blog source ↗
“Not reported” means the source doesn't say. We never fill gaps with guesses. Numbers marked “per author” or “vendor claim” are the source's own and weren't independently tested. Source last checked Oct 15, 2026.
Our rating is an editorial opinion based on the public source above, not lab testing. Spot an error? Request a correction.
Plain-text summary (for search and AI assistants)
Use Claude to categorize bank transactions in Google Sheets. Replaces Budgeting apps (Mint/YNAB-style) with Claude + Google Sheets synced by SheetLink. Cost before: Not reported. Cost after: Claude plan + SheetLink (free plan for basic sync; Max for Claude CLI use). Setup: Three commands (per author), Beginner. Time saved: Not reported. Reliability 3/5: 3/5: founder blog post from the sync-tool vendor. Best for: Spreadsheet-minded budgeters. Not for: People wanting a guided budgeting app. How it went (per source): Per the founder: a lookup table built from past tags handles about 95% of merchants, and Claude handles only new or unclear ones. On a recent batch it sorted most transactions automatically and left two for the author to decide. It also answered plain questions across 1,067 transactions. Worth knowing: The author founded the sync tool used here (SheetLink), and the command-line and Claude access need its paid Max plan. Source: https://sheetlink.app/blog/built-sheetlink-categorize-with-claude
Related recipes
- Telegram expense tracker bot with Gemini receipt reading (3/5)
- Free n8n receipt OCR: Telegram photo to Google Sheets (3/5)
- n8n invoice OCR from Drive, Gmail and Telegram to Sheets (3/5)
- Itemized receipt scanner to Google Sheets you can ask questions (3/5)
More: all Finance recipes · AI bots that replace budgeting apps (YNAB, Monarch, Mint-style)
Questions, corrections or ideas?
Spotted an error, want a recipe covered, or have a partnership idea? Send us a message and we'll get back to you.
Starting your own newsletter? Try beehiiv ↗
What is beehiiv?
beehiiv is a newsletter platform: you write and send emails, host a newsletter website, and grow and monetize a list from one place. We've used it for our own newsletter.
beehiiv says (vendor claims, not tested by us):
- Free plan with up to 2,500 subscribers and unlimited sends
- Built-in website, recommendation network and analytics
- 0% cut of paid subscription revenue (Stripe fees apply)
Good for: starting or growing an email newsletter. Not ideal for: email automations or removing beehiiv branding on a $0 budget (those need Lite or Pro).
Free plan: $0, no card needed. Paid plans from $49/mo billed annually (Lite, up to 1,000 subscribers). People who sign up through our link get a 14-day trial plus 20% off their first 3 months, per beehiiv's partner page. Facts as of Oct 2026, from beehiiv's own website. More about beehiiv →