Automatically monitor competitor pricing with Bright Data MCP & Google Sheets
UnknownWhat this workflow does
This AI workflow has 11 nodes and runs on a schedule (every week at 09:00). Along the way it connects OpenAI Chat Model, Gmail, Google Sheets and Mcp (community).
How it runs
Trigger: On a schedule (every week at 09:00).
- 🛒 Product Page URL (Edit Fields (Set)): sets 1 field: url
- 🤖 Scrape Competitor Prices (MCP Agent) (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 1 tool (MCP Client); output parser: Auto-fixing Output Parser
- 🧹 Format Products for Google Sheets (Code): runs custom JavaScript code
- 📧 Notify: Prices Logged in Sheet (Gmail): uses Gmail
- 📄 Save to Google Sheets (Competitor Pricing Log) (Google Sheets): append
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-mcp is verified or supports 3.0 (used in MCP Client).
Nodes used (10)
- OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Mcp Client Tool
n8n-nodes-mcp.mcpClientTool - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - Gmail
n8n-nodes-base.gmail - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Auto-fixing Output Parser
@n8n/n8n-nodes-langchain.outputParserAutofixing - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured
From the author
This workflow automatically monitors competitor pricing across multiple products and services to track market positioning and pricing strategies. It saves you time by eliminating the need to manually check competitor prices and provides real-time insights…