Extract visual data with AI vision and save to Google Sheets
Workflow Description
An advanced AI agent that analyzes images and extracts structured data using Gemini's vision capabilities, automatically storing results in Google Sheets with output parsing and conditional processing workflows.
How it works
- 1.Trigger the AI agent upon receiving an image or extraction request
- 2.Process images through Gemini's vision model to identify and extract data
- 3.Parse and structure extracted information into a unified format
- 4.Split outputs for conditional routing and multi-step processing
- 5.Store organized data directly into Google Sheets for centralized access
Use cases
- Automatically extract product names, prices, and details from product screenshots into a database
- Convert scanned documents or receipts into structured spreadsheet records
- Collect visual data from social media images and organize it systematically
Requirements
- Active Google account with Google Sheets access permissions
- Valid Gemini API key or direct authentication setup
- Image files in standard formats (JPG, PNG, WebP)
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