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.
Done withn8n
- 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.
Source: Reddit · Undated
Five of these in your inbox every morning
The best things people got an AI agent to do, each with the prompt to try it.
More like this
Draft email replies and LinkedIn posts with n8n workflows
The author built n8n workflows that draft Gmail replies for approval, generate LinkedIn posts from a topic, and extract tasks from emails into Google Tasks or Notion.
Handle routine email tasks and follow-up reminders with a personal assistant
Author built an n8n personal assistant that handles about 70% of routine email tasks and sends reminders for tasks waiting on others, after fixing early quirks.
Generate deep research reports into Notion
An n8n workflow turns a topic into up to three Tavily searches, compiles a Markdown report with an agent, and pushes it to a Notion page.
- GitHub Copilot
Run a solo company with eight agent departments
A founder set up CEO, CFO, COO, lawyer, accountant, marketing, CTO, and improver agents that share memory and consult each other.
Run a VC analyst agent over Telegram
A VC set up an OpenClaw agent as an analyst on a cheap VPS, reachable by Telegram, which he says could save dozens of hours per quarter.
- Custom agent
Chase unpaid invoices and paperwork by email for small firms
An agent watches for unpaid invoices and paperwork, emails people until they say yes, no, or pay, and escalates decisions to the owner.