Extract and log data to Airtable with Google Gemini, ILovePDF, and Google Drive
Needs changesWhat this workflow does
This AI workflow has 16 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Gemini Chat Model, Airtable and Google Drive. It also calls api.ilovepdf.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Get token (HTTP Request): calls api.ilovepdf.com (POST)
- Download file (Google Drive): download
- get server get task (HTTP Request): calls api.ilovepdf.com
- Merge: merges the data from its input branches
- upload pdf (HTTP Request): calls an HTTP API (POST)
- convert to jpg (HTTP Request): calls an HTTP API (POST)
- download file (HTTP Request): calls an HTTP API
- Switch: routes items into 2 branches
- Compression: uses Compression
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model; output parser: Structured Output Parser
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: api.ilovepdf.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Agent (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Agent (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (11)
- AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Merge
n8n-nodes-base.merge - Compression
n8n-nodes-base.compression - Switch
n8n-nodes-base.switch - HTTP Request
n8n-nodes-base.httpRequest - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Airtable
n8n-nodes-base.airtable - Manual Trigger
n8n-nodes-base.manualTrigger - Google Drive
n8n-nodes-base.googleDrive - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger
From the author
Who is this workflow template for? ---------------------------------- This workflow template is perfect for freelancers, small business owners, accounting teams, or anyone responsible for managing and recording invoices regularly. If you deal with multiple…