Hi n8n community 
I wanted to share a production-ready n8n workflow that automatically extracts structured invoice data from email attachments and stores it in Google Sheets, using Parserdata for document parsing.
This is useful if you receive invoices via email (PDF / PNG / JPG) and want them normalized into rows you can use for accounting, reporting, or downstream automation.
What the workflow does
End-to-end flow:
Gmail Trigger
Watches an inbox for new emails
Automatically downloads invoice attachments
Parserdata (HTTP Request)
Sends the invoice file to Parserdata’s extraction API
Uses a structured prompt to extract invoice + line-item data
JavaScript Code node
Expands the response so each invoice line item becomes one n8n item
Repeats invoice-level fields for each row
Google Sheets – Append Row
Appends each line item as a new row in a Google Sheet
Result:
One row per invoice line item, ready for analysis or export.
Extracted data
- Invoice-level fields
- invoice_number
- invoice_date
- due_date
- supplier_name
- customer_name
- net_amount
- tax_amount
- total_amount
Line-item fields
- sku
- item_description
- quantity
- unit_price
- line_total
Example use cases
- Accounting & bookkeeping automation
- Invoice reconciliation
- Spend tracking per supplier or SKU
- Feeding ERP / BI tools from Google Sheets
- Replacing manual invoice data entry
Setup requirements
You’ll need:
- An n8n instance (cloud or self-hosted)
- A Parserdata API key
- A Google account with:
- Gmail access
- A Google Sheet with predefined columns
The workflow JSON is fully importable and cleaned of credentials — you just connect your own Gmail, Parserdata, and Google Sheets credentials in n8n.
Authentication & Access (Important)
Please note: This workflow uses a commercial Enterprise API.
To run this, you will need a valid ParserData API Key.
- You must have an active Business or Corporate subscription directly from our platform.
Steps to get your key:
-
Create an account at https://parserdata.com
-
Subscribe to a Business or Corporate plan.
-
Generate your API key in the dashboard.
-
In the n8n HTTP Request node, use the header:
X-API-Key: YOUR_API_KEY
Full workflow + documentation
I’ve published the complete workflow JSON plus a step-by-step README (including Google Sheet column setup and credential configuration) here:
GitHub repository:
(The repo includes screenshots, sample invoice, and a ready-to-import workflow file.)
Customization ideas
- Filter Gmail by label (e.g. only process emails in Invoices)
- Add Slack / email alerts for high-value invoices
- Extend the Parserdata prompt with custom fields
- Write invoice-level summaries to a second sheet
- Trigger downstream workflows (ERP, approvals, storage)