Extract text from PDFs and images with Gemini and save to CSV
Workflow Description
Automation that monitors a Google Drive folder, extracts text from PDF and image files using Gemini's AI capabilities, and organizes the extracted data into a structured CSV file for easy access and analysis.
How it works
- 1.Monitor a designated Google Drive folder for new files
- 2.Receive and classify uploaded files by type (PDF or image)
- 3.Process files through Gemini to extract text content
- 4.Organize extracted data into a structured format
- 5.Save results to a CSV file in Google Drive
Use cases
- Automate invoice and receipt processing to extract financial data
- Convert scanned documents and handwritten forms into searchable digital records
- Batch process product images to extract specifications and details
Requirements
- Connected Google account with n8n and Google Drive access permissions
- Gemini API key from Google Cloud Console
- Clear folder structure for files intended for processing
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