If you've ever tried parsing incoming vendor invoices, receipts, or lead emails inside n8n, you know the pain:
- Regex breaks the second a vendor changes their email layout.
- Full LLM nodes + Structured Output Parsers require managing separate OpenAI/Anthropic keys, writing system prompts, and handling occasional markdown backticks (
`json) that crash downstream Google Sheets nodes.
In this quick guide, you'll wire up a 3-node n8n workflow (Gmail Trigger → HTTP Request → Google Sheets) that extracts vendor names, invoice dates, currencies, totals, and line items into strict, validated JSON—no OpenAI key required.
What You Need
- An n8n instance (Cloud or self-hosted).
- A free API key for the Structured JSON Data Extractor API on RapidAPI (includes 50 free calls/month, or test it right in your browser on the live playground).
Step 1: Set Up the Gmail Trigger
- Add a Gmail Trigger node in n8n set to Message Received.
- Add a filter query (for example:
subject:(invoice OR receipt)) so it only fires on billing emails.
Step 2: Add the HTTP Request Node (Invoice Parser)
Instead of chaining multiple AI and code nodes, drop in a single HTTP Request node:
- Method:
POST - URL:
[https://structured-json-data-extractor.p.rapidapi.com/v1/extract/invoice](https://structured-json-data-extractor.p.rapidapi.com/v1/extract/invoice) - Send Headers: Enable and add these two pairs:
-
X-RapidAPI-Key:YOUR_RAPIDAPI_KEY -
X-RapidAPI-Host:structured-json-data-extractor.p.rapidapi.com
-
- Send Body: Enable, choose JSON, and paste:
`json
{
"text": "{{ $json.text }}"
}
