Skip to content
UsecaseBoard
← All use cases
tutorialMoney & Bills

Log spending in chat and request a monthly breakdown

At a glance

An n8n template uses Claude Haiku to parse expense messages, append them to Google Sheets, and return monthly summaries. This workflow is listed under Money & Bills, Expense Tracking, Life Admin.

SourceBuilding a tool for these workflows? See weekly rates.

What they did

1) Have an n8n instance, Anthropic API access, and a Google account with Sheets access. Create a sheet whose first row is Date, Amount, Category, Description, Currency, Month, Raw Message, Total, in that order. 2) Import the expense-tracker template. Attach the Anthropic credential to the Claude Haiku node, authorize every Google Sheets node, and replace every spreadsheet ID with your sheet's ID. 3) Open the workflow chat and enter an expense such as 'spent 500 on lunch'. Check the returned confirmation and the appended row. 4) Enter SUMMARY for the current month, or 'summary february 2025' for that period, and read the spending total and category breakdown.

Worth knowing

Keep Always Output Data enabled on Read All Expenses so the first entry works on an empty sheet. Total is the running monthly total when a row was added; deleting rows does not recalculate older totals.

Save ideas in this browser. Upvotes count across the board.

Prompt excerpt

No prompt excerpt was provided by the source.

Sponsored

CodeBuddy

Tencent Cloud AI coding assistant for IDE and CLI.

Try CodeBuddy ↗
Explore all →