Process AP invoices from Gmail and Drive with Gemini, Sheets and QuickBooks

by Intuz ✓ · 16 views · created 2026-08-14 · Invoice Processing, AI Summarization

What this workflow does

This AI workflow has 19 nodes and runs on Google Drive events (file created) (plus 1 other trigger). Along the way it connects Gmail, Google Drive, Google Gemini and Google Sheets and 1 more. It also calls sandbox-quickbooks.api.intuit.com over HTTP.

How it runs

Trigger: On Google Drive events (file created) (plus 1 other trigger).

1. Extract Drive File Metadata (Code): runs custom JavaScript code
2. Parse Gmail Attachment (Code): runs custom JavaScript code
3. Download Invoice from Drive (Google Drive): download
4. Route by File Format (Switch): routes items into 2 branches
5. Verify PDF Text Presence (Extract from File): extracts data from a file (pdf)
6. Parse Invoice Image Fields (Google Gemini): analyze (image)
7. Check PDF Text (If): checks a condition and branches into true / false
8. Refine Image Fields Data (Code): runs custom JavaScript code
9. Analyze PDF Text and Regex (Code): runs custom JavaScript code
10. Check AI Confidence Level (If): checks a condition and branches into true / false

…plus 7 more steps. See the full node list below.

Services it uses

GmailGoogle DriveGoogle GeminiGoogle SheetsSlack

HTTP calls to: sandbox-quickbooks.api.intuit.com

Before you upgrade to n8n 3.0

Nodes used (11)

• Gmail Triggern8n-nodes-base.gmailTrigger
• Google Drive Triggern8n-nodes-base.googleDriveTrigger
• Coden8n-nodes-base.code
• Google Driven8n-nodes-base.googleDrive
• Switchn8n-nodes-base.switch
• Ifn8n-nodes-base.if
• Extract from Filen8n-nodes-base.extractFromFile
• Google Gemini@n8n/n8n-nodes-langchain.googleGemini
• Google Sheetsn8n-nodes-base.googleSheets
• Slackn8n-nodes-base.slack
• HTTP Requestn8n-nodes-base.httpRequest

From the author

Quick overview This workflow monitors Gmail and a Google Drive folder for new invoice attachments, extracts invoice data using Google Gemini (text or vision), validates confidence scores, logs results to Google Sheets, creates vendor bills in QuickBooks…

View the original on n8n.io → Check your own copy