Extract Text from PDFs and Images to CSV Using Gemini AI
Workflow Description
This automation monitors a Google Drive folder for new PDFs and images, uses Gemini to intelligently extract text and data, then organizes everything into a CSV file ready for analysis and further processing.
How it works
- 1.Monitor a designated Google Drive folder for new PDF and image uploads
- 2.Send files to Gemini AI to extract text content and key information
- 3.Structure the extracted data into organized rows for CSV format
- 4.Save the completed CSV file back to Google Drive for easy access
Use cases
- Extract text from scanned invoices, contracts, and receipts into organized spreadsheets
- Process bulk images containing text and convert them to structured data tables
- Automate data entry workflows from digitized paper documents and forms
Requirements
- Active Google account with Google Drive access permissions
- Gemini API key configured in Google Cloud Console
- Designated Google Drive folder for storing source documents
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