Monitor product prices with Decodo, Google Sheets, Gemini and Gmail

Description

Categories: Business Automation, E-commerce, Intelligence, AI
This workflow automates high-frequency price tracking across e-commerce platforms. It combines the data-handling power of the Decodo node with the intelligence of Google Gemini to eliminate manual price checks. It is for businesses seeking real-time market intelligence.
Benefits
Total Automation: Handles data sourcing, and email notifications without human help.
Intelligent Extraction: Uses AI to analyze the full page content.
Precision Alerting: Triggers notifications when a product's price meets or falls below the "Desired Price."
Scalable Architecture: Processes large batches of products.

How It Works
Scheduled Data Retrieval: The Schedule Trigger pulls a list of URLs and target prices from Google Sheets.
Raw Data Processing: Data flows through a Decodo node.
Full-Body Extraction: The workflow captures the entire body of the webpage.
AI-Driven Analysis: An AI Agent, powered by Google Gemini, analyzes the text to identify the product name and price.
Regex Data Cleaning: A JavaScript node uses Regular Expressions to sanitize the AI's response.
Smart Comparison & Alerting: An If Node compares the live price against the "Desired Price." If the condition is met, an automated alert is sent via Gmail.

Requirements
n8n Instance
Google Account
Google Gemini API Key
Decodo Credentials

How to Use
Setup your Spreadsheet: Create a Google Sheet with columns for the product link and "Desired price."
Authenticate Nodes: Connect your Google Sheets, Gmail, and Gemini credentials within n8n.
Configure Parameters: Ensure the If node correctly references the "Desired price" column from your Google Sheet output.
Deploy: Activate the workflow. The system will now run automatically, monitoring the list and notifying of deals.

Business Use Cases
Retail Arbitrage Agencies: Spot price drops on supplier sites to maximize profit margins.
Competitor Intelligence: Monitor rival pricing strategies.
Procurement Departments: Automate the "buy" signal for raw materials when they hit a specific price point.
E-commerce Managers: Track MAP (Minimum Advertised Price) compliance.
Revenue Potential
Increased Margins: Buy inventory at the lowest prices.
Market Leadership: React faster than competitors to market-wide price shifts.
Service Offering: Provide "Price Watch" services for e-commerce clients.

Difficulty Level:
Intermediate
Estimated Setup Time: 40 min
Monthly Operating Cost: Low (based on Gemini API tokens)