Extract spending history from gmail to google sheet

Go to Workflow
2,375 views
Built by hana hana
Created on June 05, 2026

Description

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 fetch email from Gmail lables, suggested using filters to automatically orgianize email into the labels
Data will send to "raw data" sheet
Example google sheet:
https://docs.google.com/spreadsheets/d/1_IhdHj8bxtsfH2MRqKuU2LzJuzm4DaeKSw46eFcyYts/edit?gid=1617968863#gid=1617968863

Nodes Used (6)

Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm
Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini
Google Sheets
n8n-nodes-base.googleSheets
Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq
HTML
n8n-nodes-base.html
Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured