Invoice data extraction with LlamaParse and OpenAI
This n8n workflow automates the process of parsing and extracting data from PDF invoices. With this workflow, accounts and finance people can realise huge ti...
🔌 Nodes & Integrations Used (7)
📖 Implementation & Setup Guide
This n8n workflow automates the process of parsing and extracting data from PDF invoices. With this workflow, accounts and finance people can realise huge time and cost savings in their busy schedules.
**Read the Blog**: [https://blog.n8n.io/how-to-extract-data-from-pdf-to-excel-spreadsheet-advance-parsing-with-n8n-io-and-llamaparse/](https://blog.n8n.io/how-to-extract-data-from-pdf-to-excel-spreadsheet-advance-parsing-with-n8n-io-and-llamaparse/)
How it works
* This workflow will watch an email inbox for incoming invoices from suppliers * It will download the attached PDFs and processing them through a third party service called LlamaParse. * LlamaParse is specifically designed to handle and convert complex PDF data structures such as tables to markdown. * Markdown is easily to process for LLM models and so the data extraction by our AI agent is more accurate and reliable. * The workflow exports the extracted data from the AI agent to Google Sheets once the job complete.
Requirements
* The criteria of the email trigger must be configured to capture emails with attachments. * The gmail label "invoice synced" must be created before using this workflow. * A LlamaIndex.ai account to use the LlamaParse service. * An OpenAI account to use GPT for AI work. * Google Sheets to save the output of the data extraction process although this can be replaced for whatever your needs.
Customizing this workflow
This workflow uses Gmail and Google Sheets but these can easily be swapped out for equivalent services such as Outlook and Excel.
Not using Excel? Simple redirect the output of the AI agent to your accounting software of choice.
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Invoice data extraction with LlamaParse and OpenAI.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related Email & Outreach Workflows
View All in Email & Outreach →Abandoned cart recovery for Shopify via Gmail Google Sheets T
Who is this for? This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to reco...
Add new leads in Lemlist from Airtable
This workflow allows you to add new leads in Lemlist from Airtable. !workflow-screenshot Airtable node: This node lists all the emails that are stored in you...
Add Subscriber and Send Email Campaign
Production-ready n8n automation template for Add Subscriber and Send Email Campaign built by AhiXLight. Seamlessly connects Sendy with 3 configured nodes.
Add new contacts from HubSpot to the email list in Mailchimp
This workflow adds new HubSpot contacts to the Mailchimp email list. Prerequisites - HubSpot account and HubSpot credentials - Mailchimp account and Mailchim...