Extract data from images using AI vision and save to spreadsheets
Workflow Description
Automation that leverages an AI agent with computer vision capabilities to analyze images, extract structured data, and automatically populate Google Sheets with results. Ideal for processing visual content at scale without manual data entry.
How it works
- 1.Trigger the workflow manually with an image URL or upload
- 2.Send the image to Gemini's vision model for analysis and data extraction
- 3.Parse the extracted text into structured, organized data format
- 4.Write the extracted data directly into a Google Sheets spreadsheet
Use cases
- Extract product details, prices, and descriptions from product screenshots
- Convert receipts, invoices, and documents into organized spreadsheet entries
- Harvest contact information and details from social media post images
Requirements
- Active Google account with Google Sheets access
- Gemini API key from Google Cloud Console
- Clear images containing extractable text or structured information
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 (29)
When clicking ‘Test workflow’
Manual Trigger
ScrapingBee- Get page HTML
HTTP Request
Structured Output Parser
Output Parser Structured
Google Gemini Chat Model
Gemini Model
Split Out
Split Out
Google Sheets - Get list of URLs
Google Sheets
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Set fields
Set
Sticky Note3
Sticky Note
ScrapingBee - Get page screenshot
HTTP Request
Sticky Note4
Sticky Note
HTML-based Scraping Tool
Tool Workflow
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note
Sticky Note8
Sticky Note
Sticky Note9
Sticky Note
Google Sheets - Create Rows
Google Sheets
Vision-based Scraping Agent
Agent
Sticky Note10
Sticky Note
HTML-Scraping Tool
Execute Workflow Trigger
Sticky Note11
Sticky Note
Set fields - from AI agent query
Set
Sticky Note12
Sticky Note
Sticky Note13
Sticky Note
HTML to Markdown
Markdown
Sticky Note14
Sticky Note