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.