Automate E-commerce Scraping with Vision AI & Google Sheets
detail.loadingPreview
Scrape product data using Vision AI, ScrapingBee, and Gemini. Automatically extract titles, prices, and promotions, saving hours of manual work.
🚀Ready to Deploy This Workflow?
About This Workflow
How it works
This workflow automates the extraction of product information from e-commerce websites using a vision-based AI agent. It begins by fetching a list of URLs from Google Sheets. For each URL, it captures a full-page screenshot using ScrapingBee. The core of the workflow is an AI agent powered by Google Gemini, which analyzes the screenshot to extract product titles, prices, brands, and promotional details. If direct extraction from the image is insufficient, the agent can fallback to using an HTML scraping tool. The structured output from the AI is then parsed and pushed into a 'Results' sheet in Google Sheets for easy analysis.
Key Features
- Vision-based AI for image analysis and data extraction.
- Seamless integration with ScrapingBee for screenshots.
- Leverages Google Gemini for advanced AI capabilities.
- Fallback mechanism for HTML-based scraping when needed.
- Structured output parsing for clean data formatting.
- Direct integration with Google Sheets for results storage.
How To Use
- Prepare your Google Sheet: Create a Google Sheet with a 'List of URLs' sheet containing the websites you want to scrape. An example sheet is provided. Ensure you also have a 'Results' sheet for the output.
- Configure Credentials: Set up API credentials for ScrapingBee and Google Sheets within n8n.
- Set ScrapingBee API Key: Replace
<your_scrapingbee_apikey>in theScrapingBee - Get page screenshotandScrapingBee- Get page HTMLnodes with your actual API key. - Configure Gemini API: Ensure your Google Gemini (PaLM) API account is set up and authenticated.
- Customize Output Parser: Adjust the
jsonSchemaExamplein theStructured Output Parsernode to match the exact data fields you want to extract, aligning with your 'Results' sheet columns. - Test Workflow: Manually trigger the workflow by clicking 'Test workflow' to process the URLs from your Google Sheet.
Apps Used
Workflow JSON
{
"id": "12ee7e83-849e-46cb-a8c5-223cad4c49d1",
"name": "Automate E-commerce Scraping with Vision AI & Google Sheets",
"nodes": 0,
"category": "AI & LLM",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 12ee7e83-849e...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Related Integrations
- Google Sheets + Schedule Trigger(394 workflows)
- Google Sheets + Split Out(277 workflows)
- Google Sheets + Slack(268 workflows)
- Gmail + Google Sheets(245 workflows)
- Google Drive + Google Sheets(203 workflows)
- Form Trigger + Google Sheets(163 workflows)
- Google Drive + Google Drive Trigger(135 workflows)
- Google Drive + Split Out(134 workflows)
- Google Sheets + Telegram(118 workflows)
- Execute Workflow Trigger + Google Sheets(101 workflows)
Related Workflows
Discover more workflows you might like
Automate YouTube Video Summaries with AI & n8n
Instantly summarize YouTube videos using n8n and Langchain. Save hours by transforming lengthy content into concise insights. Get actionable summaries.
Automate Crop Anomaly Detection with AI: Image URL to Anomaly Alert
Detect anomalous crops from image URLs instantly. This n8n workflow uses Voyage AI embeddings and Qdrant to compare images against a dataset, alerting you to new crop types.
Automate YouTube Video Summarization with AI & Google Sheets
Save hours weekly! Auto-summarize YouTube video transcripts using DeepSeek AI and sync key insights to Google Sheets. Perfect for researchers and content managers.
Automate Blog Post Generation from Google Sheets to WordPress with AI
Effortlessly create and publish blog content by automating AI-powered content generation from your Google Sheet directly to WordPress. Save hours weekly!
Build a Personal AI Chatbot from Your Resume with Google Gemini & Pinecone
Automate resume ingestion into a searchable AI knowledge base using Google Drive, Gemini, and Pinecone. Deploy a chatbot to answer questions about your profile.
AI Agent: Enhance Chatbots with Long-Term Memory & Tool Integration
Empower your AI chatbot with n8n! Integrate long-term memory via Google Docs and leverage OpenAI tools for advanced conversational AI. Automate memory saving, retrieval, and notifications.