Skip to main content

Extract spending history from gmail to google sheet

Workflow preview

Extract spending history from gmail to google sheet preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

Overview

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