Extract batch invoice data from form uploads with easybits and Google Sheets
Quick overview This workflow collects one or more invoice files via an n8n Form, extracts structured invoice fields with the easybits Extractor, appends the results to Google Sheets, and returns an on-screen completion summary that flags any invoices missing critical fields.
How it works Receives invoice uploads (JPG, PNG, or PDF) through an n8n Form trigger. Splits the submitted files into one item per file and prepares each file for processing while keeping the original filename. Processes invoices one at a time and sends each file to the easybits Extractor to pull invoice fields into a structured data object. Reattaches the original filename to the extracted result and checks whether critical fields (invoice number, invoice date, vendor name, total amount) are present. Appends one row per invoice to Google Sheets with the extracted fields and the pass/fail status. Builds a batch summary of all processed files and shows it as the form completion message.
Setup Install the easybits community node (@easybits/n8n-nodes-extractor) and add an easybits Extractor API credential. Create/configure an extraction pipeline in easybits (with fields like invoice_number, invoice_date, vendor_name, total_amount, etc.) and copy its API key into n8n. Connect Google Sheets OAuth credentials, then select your target spreadsheet and sheet tab in the Google Sheets append step and ensure the columns match the mapped field names.
Related Templates
Verify Linkedin Company Page by Domain with Airtop
Automating LinkedIn Company URL Verification Use Case This automation verifies that a given LinkedIn URL actually belo...
Create a Speech-to-Text API with OpenAI GPT4o-mini Transcribe
Description This template provides a simple and powerful backend for adding speech-to-text capabilities to any applicat...
Build a Restaurant Voice Assistant with VAPI and PostgreSQL for Bookings & Orders
This n8n template demonstrates how to create a comprehensive voice-powered restaurant assistant that handles table reser...
🔒 Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments