Work & OperationsDone with n8n
Turn email invoices into a live financial dashboard
An n8n workflow scans emailed invoices, extracts supplier, amount, date and description, and feeds a real-time Google Sheets dashboard.
- What They Did
- The workflow watches Gmail for incoming invoice emails, then uses AI to classify each one as an expense or income and extract fields including supplier, amount, date, description, and category. It writes the structured data into Google Sheets, where the sheet itself powers a live dashboard showing totals, net profit, and category breakdowns; the Reddit post does not describe a manual review step.
- How It Went
- The stated result is a real-time finance dashboard tracking total income, total expenses, net profit, and spending by category. The post shares no hard metrics, error rates, or before-and-after time savings.
- Worth Knowing
- The source is high level only: it explains the flow and dashboard outputs, but gives no template, run cost, or setup time in the post text shown.
Try it yourself with n8n
Build a workflow that watches [Gmail label or inbox] for emails with invoice attachments, extracts supplier, amount, date, and description from each, and appends a row to the Google Sheet [sheet name]. Add a second tab with totals by supplier and month for a live dashboard. Finished means a test invoice shows up correctly in the sheet; flag any invoice it cannot read instead of guessing.
Do this with a skill.
These SkillShop playbooks do this exact job.