Monitor e-commerce price changes with Decodo Scraper, OpenAI & Google Sheets
This workflow contains community nodes that are only compatible with the self-hosted version of n8n.
Stay ahead of market changes with this Automated Price Intelligence System!
This workflow monitors e-commerce product prices 3x daily using advanced web scraping and AI analysis, tracking price changes, comparing against strategic thresholds, and sending intelligent alerts for competitive pricing opportunities. Perfect for e-commerce teams, retailers, and pricing strategists maintaining market competitiveness.
What This Template Does?
- Triggers 3x daily (9 AM, 3 PM, 9 PM) for continuous price monitoring
- Configures global settings for products, thresholds, and alert recipients
- Parses product targets and maps price thresholds by category
- Uses Decodo scraper for real-time pricing data extraction
- Analyzes product pages with AI for structured price insights
- Logs price data to Google Sheets for tracking and analysis
- Evaluates prices with AI-powered recommendations
- Classifies alerts as CRITICAL or STANDARD
- Sends targeted email alerts with action recommendations
Step-by-Step Setup Instructions
- Connect Decodo API for web scraping
- Set up OpenAI for AI analysis
- Configure Google Sheets logging
- Add Gmail credentials for alerts
- Define product URLs and tracking IDs
- Set pricing thresholds by category
- Configure alert recipients
- Test with sample product URLs
- Activate automation (3x daily monitoring)
Features
- Triple-daily scheduling
- Multi-product monitoring
- AI-based price extraction
- Real-time web scraping (Decodo)
- Smart alert classification
- Email automation with insights
- Google Sheets integration
- Batch processing support
- Auto-fix parsing for accuracy
Key Benefits
- Continuous price monitoring across platforms
- AI-powered pricing recommendations
- Historical tracking for trend analysis
- Multi-tier alert system (critical vs standard)
- Automated competitive intelligence
- Configurable thresholds by category
Requirements
- Decodo API credentials
- OpenAI API credentials
- Google Sheets OAuth2 access
- Gmail OAuth2 for alerts
- Environment variables setup
- Product URLs with tracking IDs
Target Audience
- E-commerce & retail pricing teams
- Competitive intelligence analysts
- Revenue optimization teams
- Marketing & sales teams
- Retail operations managers
- Digital agencies