Vision-based AI agent scraper - with Google Sheets, Gemini
Workflow Description
An intelligent automation template using Gemini-powered AI agents to analyze images, extract structured data, and automatically save results to Google Sheets for organized tracking and analysis without manual intervention.
How it works
- 1.Trigger the workflow manually or via HTTP request with image URLs or attachments
- 2.Send content to the AI agent backed by Gemini vision capabilities
- 3.Extract and process visual information to identify relevant data points
- 4.Parse and structure extracted data using the output parser
- 5.Automatically insert organized results into Google Sheets rows or tables
- 6.Execute conditional actions or send notifications based on extraction results
Use cases
- Extract product details, prices, and specifications from product images or invoices automatically
- Monitor social media posts with images and log structured data to spreadsheets in real time
- Scan documents or screenshots to capture text, tables, and numerical data accurately
- Classify and organize visual content from multiple sources into categorized sheets
Requirements
- Active Google Sheets account with a shared or private spreadsheet document
- Gemini API key obtained from Google Cloud Console with vision capabilities enabled
- Image sources in standard formats (JPG, PNG, WebP) or accessible via URL
- Basic understanding of JSON output structure and verified app permissions for Sheets access
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