Reconcile Google Drive invoice PDFs with OpenAI, Sheets, Slack and Gmail

Go to Workflow
0 views
Built by Redowan Ahmed Farhan Redowan Ahmed Farhan
Created on June 10, 2026

Description

How it works

Watches a Google Drive folder and triggers automatically when a new invoice PDF is uploaded
Extracts raw text from the PDF and passes each invoice through an OpenAI powered agent that returns structured fields like vendor, amount, due date, and line items
Fans the enriched data to three parallel outputs: a Google Sheets log, a Slack alert for overdue invoices, and a weekly summary email to Finance via Gmail

Set up steps

Connect Google Drive, Google Sheets, Gmail, Slack, and OpenAI credentials (~15 minutes total)
Works best with text based PDFs; scanned invoices need OCR upstream of the extraction step
Keep full setup details and prompt tuning tips in the sticky notes inside the workflow

Nodes Used (7)

AI Agent
@n8n/n8n-nodes-langchain.agent
Code
n8n-nodes-base.code
Gmail
n8n-nodes-base.gmail
Google Drive
n8n-nodes-base.googleDrive
Google Sheets
n8n-nodes-base.googleSheets
OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
Slack
n8n-nodes-base.slack