Templates / Extract invoice data into Google Sheets with LDX hub AnalyzeDoc Gemini

Extract invoice data into Google Sheets with LDX hub AnalyzeDoc Gemini

Unknown

by Hideki Mori(森秀樹) ✓ · 84 views · created 2026-07-10 · Invoice Processing, AI Summarization

Unknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.

Community nodes

These come from third-party npm packages. In n8n 3.0 unverified community packages are off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).

Nodes used (5)

Google Sheets

What it does

Quick overview This workflow collects an invoice PDF or image through an n8n form, uses LDX hub AnalyzeDoc (Gemini) to extract key invoice fields as JSON, and appends the results as a new row in Google Sheets. How it works 1. Receives an invoice file upload (PDF/JPG/PNG) through an n8n form submission. 2. Sends the uploaded document to LDX hub AnalyzeDoc (google/gemini-3.5-flash) with a prompt that extracts invoice metadata, parties, dates, and amounts into a JSON schema. 3. Parses the extracted JSON into structured fields for downstream use. 4. Appends the extracted invoice fields as a new row in the selected Google Sheets spreadsheet and worksheet. Setup 1. Install the community node package n8n-nodes-ldxhub and create an LDXhub API credential (API key) for the AnalyzeDoc node. 2. Add a Google Sheets OAuth2 credential and select the target spreadsheet and sheet in the Google Sheets append step. 3. Create a header row in your Google Sheet that matches the extracted fields (invoicenumber, issuedate, duedate, vendorname, vendoraddress, vendortaxid, billto, subtotal, tax, total, currency, paymentterms) so auto-mapping writes to the correct columns.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.