Extract invoice data from Google Drive to Sheets using PDF.co AI parser

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 → Credentials → New → Google Drive (OAuth2) 2. Sign in to the Google account that owns your invoice PDFs and allow access. 3. In the Get Parent Folder ID node, set your search to the folder name (e.g., n8n Invoices). 4. In Get Invoice ID’s, ensure Filter → folderId uses the ID from the previous node (already wired in this template).

> Tip: The workflow builds a Drive link like > https://drive.google.com/file/d/<FILEID> > Make sure those files are at least viewable via link (e.g., Anyone with the link – Viewer) so PDF.co can fetch them.

---

2) Connect PDF.co (AI Invoice Parser) 1. Create a PDF.co account and copy your API Key. 2. In n8n → Credentials → New → PDF.co API, paste your key and Save. 3. In the AI Invoice Parser node, keep URL mapped to the Drive link coming from Convert to URL. The node is already set to use your PDF.co credentials.

> What it does: Sends each Drive file URL to PDF.co’s AI Invoice Parser and returns structured JSON (vendor, totals, dates, line items, etc.). The next Set Fields node maps those fields to simple columns for Sheets.