Extract Spending History from Gmail to Google Sheets

n8n Data Management AI Finance

Contributed by Sabrina Ramonov 🍄. From the community directory at agents.sabrina.dev, republished with permission and full credit.

How it works

Fetch transaction notification emails (including attachments).

Clean up data.

Let AI (Basic LLM Chain node) generate bookkeeping item.

Send to Google Sheet.

Details

The example fetches email from Gmail labels, suggested using filters to automatically organize email into the labels.

Data will be sent to the "raw data" sheet.

Example Google Sheet:Link to Google Sheet

Tools used: Google Sheets, Gmail, OpenAI

Download the workflow template (JSON)

Original tutorial

Want this running in your business? KOBA42 builds and operates automations like this one.