How to Automate Google Drive Invoice Capture?
Description
Turn new files in Google Drive into clean invoice records in Airtable. The flow finds new invoices, pulls out line items, and saves everything without manual typing. It is great for finance teams that receive invoices in a shared folder.
Here is how it works. A Google Drive trigger watches a chosen folder and starts when a file is added. n8n downloads the file and sends it to LlamaParse with a webhook callback. The webhook returns parsed text. A prompt guides OpenAI to extract vendor data, totals, taxes, and a list of line items. A small code step builds a structured array, cleans numbers, and links each item to its invoice. Then the flow creates an invoice in Airtable and adds each line item to a linked table.
You need a Google Drive folder for invoices, an Airtable base with Invoices and Line Items tables, and API keys for LlamaParse and OpenAI. Once set up, most invoices go from upload to database in a few minutes, cutting data entry time and mistakes. Use it for accounts payable, spend tracking, and vendor reporting.
Tools Required
What this workflow does?
- Google Drive trigger watches a specific folder and starts on new files
- File download from Drive and multipart upload to LlamaParse
- Webhook receives parsed results from LlamaParse asynchronously
- Prompt based OpenAI step extracts supplier details, totals and line items
- Code step cleans values, builds arrays and prepares records for Airtable
- Airtable node creates the invoice record in the Invoices table
- Line items are added to the Line Items table and linked to the invoice
What are the benefits?
- Reduce manual entry from 30 minutes to 3 minutes per invoice
- Automate over 90 percent of repetitive data entry for invoices
- Improve data accuracy by up to 80 percent by removing retyping
- Handle up to 5 times more invoices without adding headcount
- Connect Google Drive, LlamaParse, OpenAI and Airtable in one flow
- Speed up month end close with structured and searchable records
How to set this up?
- Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
- You'll need accounts with Google Drive, LlamaParse, OpenAI and Airtable. See the Tools Required section above for links to create accounts with these services.
- In n8n, open the Google Drive Trigger node. Connect your Google Drive account or click Create new credential and follow the on screen steps. Choose the folder that holds your invoices and keep polling every minute.
- Open the Google Drive node and confirm the operation is Download and the File ID is mapped from the trigger item. This ensures the correct file is pulled.
- Create a LlamaParse API key in your LlamaIndex Cloud account. Open the Upload File HTTP Request node and set the Authorization header to Bearer YOUR_API_KEY. Keep content type as multipart form data.
- Open the Webhook node and copy the Production URL. In the Upload File node body parameters, set webhook_url to this Production URL so LlamaParse can send results back to n8n.
- Open the Set Fields node to review the prompt text. Adjust the prompt to match your field names if needed, keeping the request for line items, quantities, unit prices and amounts.
- In the OpenAI node, click Create new credential, choose API Key, and paste your OpenAI key from the official API page. Save and confirm a successful connection.
- In Airtable, create a Personal Access Token with data read and write on the target base. In the Create Invoice and Create Line Item nodes, create a new Airtable credential with this token, then select your base and the Invoices and Line Items tables. Map fields for vendor, dates, totals, quantities, unit prices and the invoice link.
- Run a test by uploading a sample invoice PDF to the watched Google Drive folder. Check Executions in n8n to confirm the trigger fired, the webhook returned data, and records were created in Airtable.
- If records do not appear, verify the webhook URL is public, confirm your LlamaParse API key is set in the Authorization header, check file size and type, and review the OpenAI response. Adjust the prompt or field mappings if line items do not parse correctly.
Need help or want to customize this?
Ask in the Free Futurise Community.
Similar Templates
Credits: Created by Mark Shcherbakov from 5minAI. Setup guide: YouTube video - these templates were sourced from publicly available materials across the web, including n8n’s official website, YouTube and public GitHub repositories. We have consolidated and categorized them for easy search and filtering, and supplemented them with links to integrations, step-by-step setup instructions, and personalized support in the Futurise community. Content in this library is provided for education, evaluation and internal use. Users are responsible for checking and complying with the license terms with the author of the templates before commercial use or redistribution. If you are the author and would like this template removed from the template library, email us at info@futurise.com and we will remove it promptly.
