Extract spending history from gmail to google sheet

Nodes

673985d5-a68a-465a-8e1d-075bfbab0975a0d93eb1-bb23-4c69-815f-fe01a740b02ca97f27bd-6185-4b9b-bade-f7020a7a1885083a55c9-df56-4154-959f-52737890cad0c271cce3-82fc-4582-b314-f282e190a2e3bd79094e-5967-4692-8dc9-207cbfbe889a+5

Created by

hahana

Last edited 39 days ago

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

New to n8n?

Need help building new n8n workflows? Process automation for you or your company will save you time and money, and it's completely free!