Extract invoice data from Google Drive to Sheets using PDF.co AI parser
UnknownWhat this workflow does
This workflow has 7 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Drive, Google Sheets and Pdfco (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Parent Folder ID (Google Drive): work with file folder
- Get Invoice ID's (Google Drive): work with file folder
- Convert to URL (Edit Fields (Set)): sets 1 field: link
- AI Invoice Parser (PDFco Api): uses PDFco Api
- Set Fields (Edit Fields (Set)): sets 5 fields: Vendor, Invoice Date, Total…
- Store Data in Google Sheets (Google Sheets): append or update
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-pdfco is verified or supports 3.0 (used in AI Invoice Parser).
Nodes used (5)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Drive
n8n-nodes-base.googleDrive - Edit Fields (Set)
n8n-nodes-base.set - PDFco Api
n8n-nodes-pdfco.PDFco Api - Google Sheets
n8n-nodes-base.googleSheets
From the author
This workflow looks inside a Google Drive folder, parses each PDF invoice with PDF.co’s AI Invoice Parser, and appends vendor, amount, dates, and a link to the file into a Google Sheet. --- ⚙️ Setup Instructions 1) Connect Google Drive (OAuth2) 1. In n8n →…