Extract text from PDF and image using AI (Gemini) to CSV file
Workflow Description
Automation workflow that extracts text from PDF and image files using Gemini AI, processes the content intelligently, and exports the structured data directly to a CSV file stored on Google Drive.
How it works
- 1.Trigger workflow automatically when a new file is uploaded to a Google Drive folder
- 2.Determine file type (image or PDF) using a conditional switch node
- 3.Extract text content using Gemini with intelligent processing
- 4.Transform and organize extracted data into CSV format
- 5.Save the final file automatically to your Google Drive
Use cases
- Digitize and index paper documents and images at scale
- Automate data extraction from invoices, contracts, and receipts
- Convert legacy records and archives into searchable databases
Requirements
- Active Google account with Google Drive management permissions
- Valid Gemini API key configured and enabled
- Access rights to process PDF and image files
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (16)
Google Gemini Chat Model
Gemini Model
Get PDF or Images
Google Drive Trigger
Route based on PDF or Image
Switch
Download PDF
Google Drive
Download Image
Google Drive
Extract data from PDF
Extract From File
Send data to A.I.
HTTP Request
Convert to CSV
Convert To File
Upload to Google Drive
Google Drive
Convert to CSV2
Convert To File
Upload to Google Drive1
Google Drive
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Vertex A.I. extract text
LLM Chain