Vision-based AI agent scraper - with Google Sheets, Gemini
Workflow Description
An advanced automation template combining an AI agent with computer vision to extract data from images using Gemini, process results through structured parsing, and automatically store extracted information in Google Sheets for ongoing analysis and record-keeping.
How it works
- 1.Trigger the workflow manually or via HTTP request to initiate the extraction process
- 2.Send images to Gemini for visual analysis and data extraction based on specified requirements
- 3.Process returned results using structured output parsing for consistency and accuracy
- 4.Split and format processed data according to defined schemas and requirements
- 5.Automatically save extracted data to designated Google Sheets table with proper formatting
- 6.Enable additional actions or integrations based on extracted information
Use cases
- Extract product data and financial information from invoices, receipts, and billing documents
- Collect information from screenshots, forms, and official documents with automatic organization
- Monitor social media content and images for relevant data extraction and categorization
- Classify images by visual characteristics and index their content for searchable databases
Requirements
- Google Gemini API key configured for vision-based analysis capabilities
- Google Workspace account with write permissions to target Google Sheets
- Configured AI agent with custom tools designed for complex task handling
- HTTP endpoint or manual trigger to initialize workflow execution
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