n8nflow.net logo

Extract spending history from gmail to google sheet

by hanaUpdated: Last update a year agoSource: n8n.io
Loading workflow viewer...

Getting Started

How it works

  1. Fetch transaction notification emails (including attachments)
  2. Clean up data
  3. Let AI (Basic LLM Chain node) generate bookkeeping item
  4. Send to Google sheet

Details

  1. The example fetch email from Gmail lables, suggested using filters to automatically orgianize email into the labels
  2. Data will send to "raw data" sheet
  3. Example google sheet:
    https://docs.google.com/spreadsheets/d/1_IhdHj8bxtsfH2MRqKuU2LzJuzm4DaeKSw46eFcyYts/edit?gid=1617968863#gid=1617968863