Back to Templates
  • +10

Extract spending history from gmail to google sheet

Created by:
Last update:

Last update 5 months ago

Categories:
Share:

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