Expenses pile up uncategorised in your sheet. Learn how to categorize expenses with claude ai — Make watches for new expense rows, Claude picks one category from your list, and Google Sheets writes it into a Category column.
This is the companion tutorial for the StackScale video above. No code, no live expenses, and no real spending — the whole flow runs on forty-two fictional demo expenses so you can test it safely.
What You Will Build
A Make scenario that watches for a new expense row, sends the merchant and description to Claude, and files one category per expense into Google Sheets. Forty-two expenses in, forty-two sorted in seconds, and $486.70 accounted for — twelve Food & Drink, nine Transport, eleven Software, ten Office. The amounts are already in the sheet; the new job is deciding what each expense is.
Prerequisites / Tools
- A Make account (free plan is enough to start)
- A Claude account
- A free Google Sheet with one expenses tab — plus a Category column and a category list (Food & Drink, Transport, Software, Office) at the top of the sheet
- Dummy expenses to test with — the fictional Demo Coffee, Demo Taxi, and Demo Software expenses used in the video
Disclosure: Some links below are affiliate links, meaning StackScale may earn a commission at no extra cost to you.
- Make: https://www.make.com/en/register?pc=stackscale&affiliateSource=devto
- Claude: https://claude.com
- Google Sheets: https://sheets.google.com
The Workflow
Make watches the expenses sheet for a new row, and the scenario starts the moment one appears. Claude reads the merchant and description, picks exactly one category from your list, and returns it as JSON. Make maps the category into the same row as its expense, so the sheet stays sortable and ready for monthly totals. This is not extracting totals from a receipt — the amounts are already there. The new job is categorising.
Step 1: Build the Expenses Sheet with a Category Column
Each row holds a date, a merchant, a description, and an amount — and one empty Category cell waiting to be filled. Write your four-category list at the top of the sheet: Food & Drink, Transport, Software, Office. Without the Category column, Claude has nowhere to put its answer.
Step 2: Trigger on a New Expense Row
In Make, set the scenario to watch the expenses sheet for a new row. A new expense is the trigger — nothing else starts the flow.
Step 3: The Claude Categorisation Prompt
Send the row to Claude with this prompt (copy as-is):
You are categorising expenses. Read the merchant and description for each expense. Pick exactly one category from this list: Food & Drink, Transport, Software, Office. Return JSON only: {"merchant": "Demo Coffee", "category": "Food & Drink"}. If the merchant or description is vague, pick your best guess and add "uncertain": true. Never invent a category outside the list. Example: {"merchant": "Demo Coffee", "category": "Food & Drink", "uncertain": false}.
Ask for JSON only and one category per expense, so the result is always a single clean value.
Step 4: Map the Category into Sheets
Map the fields into the expenses sheet:
{
"Date": "expense date",
"Merchant": "expense merchant",
"Description": "expense description",
"Amount": "expense amount",
"Category": "category filled by Claude via Make"
}
Demo Coffee becomes Food & Drink, Demo Taxi becomes Transport, Demo Software becomes Software. The category lands in the same row as the expense, so the sheet stays sortable and ready for monthly totals.
Step 5: Test with the Dummy Expenses
Drop in forty-two fictional expenses, including Demo Coffee at $4.50, Demo Taxi at $18.20, and Demo Software at $29.00. Claude sorts all forty-two in seconds — twelve Food & Drink, nine Transport, eleven Software, ten Office.
The Finished Result
Forty-two expenses sorted, $486.70 accounted for, and a category breakdown you can read at a glance — no evening lost.
One Honest Limit
Claude categorises from the merchant and description text, so a vague description can be miscategorised — a shop that sells everything could land in the wrong bucket. Keep a quick review step for odd rows, and never claim this replaces an accountant or a finance system.
Watch the Full Tutorial
The video at the top walks through the same five steps with the synthetic mockups. All mockups in the video are synthetic, created for this tutorial, with dummy data only — no real expense or account is shown, and no real account appears anywhere.
New automation tutorials every day on StackScale — subscribe on YouTube at https://www.youtube.com/@StackScaleHQ.
Top comments (1)
Really clear walkthrough — the JSON-only prompt is the part that makes this actually reliable in a sheet.
One addition I'd suggest: ask Claude for a confidence score alongside the category, and route anything below, say, 0.7 into a "Needs review" bucket instead of a category. That directly handles your honest limit — vague descriptions get a human look instead of a confident wrong label.
A second small one: add a manual-override column and have the scenario skip rows where it's filled, so a correction you make by hand never gets overwritten on a re-run. Merchant names are worth normalizing too — "Uber" vs "Uber Eats" will otherwise land in different places over time.