Extract spending history from gmail to google sheet

Go to Workflow
2,375 views
Built by hana hana
Created on September 15, 2024

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

This workflow was created by hana and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.

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