Skip to content
UsecaseBoard
← All use cases
Google BlogHousehold Budget

Categorize a bank statement in Google Sheets with Gemini

At a glance

Google shows how to ask Gemini in Sheets to label transaction descriptions for a household budget. This workflow is listed under Household Budget, Money-Bills.

Agents / tools
Gemini, Google Sheets

SourceBuilding a tool for these workflows? See weekly rates.

What they did

1) Put transaction descriptions from a bank statement in column A of a Google Sheet and open Gemini in Sheets. 2) Ask Gemini to analyze the descriptions and categorize each transaction in column B. Google's example uses Food, Transportation, Rent, Entertainment and Miscellaneous as the available categories. 3) Read the labels beside the original descriptions and check any ambiguous transactions before using the categories to understand your spending. The request can be adapted to the categories relevant to your own budget.

Worth knowing

Google presents this as an example prompt; it does not report a measured result for a particular bank statement.

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 →