If you've ever tried parsing incoming vendor invoices, receipts, or lead emails inside n8n, you know the pain:

  1. Regex breaks the second a vendor changes their email layout.
  2. 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

Step 1: Set Up the Gmail Trigger

  1. Add a Gmail Trigger node in n8n set to Message Received.
  2. 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 }}"
}