📊 Monitor competitor price gaps with Scrapewise, Google Sheets, and Slack
⚡ 0 views · 📊 Market Research & Insights
💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.
Description
Quick Overview
This workflow runs daily at 08:00 to read matched product pricing data from Scrapewise, identifies items where a competitor undercuts your price, logs the price gaps to Google Sheets, and posts a single summary message to a Slack channel.
How it works
- Runs every day at 08:00 on a schedule.
- Loads your Scrapewise group ID, column names, shop name, and the number of rows to read.
- Fetches the latest matched pricing rows from Scrapewise via its MCP endpoint using your API key.
- Groups rows by match key, compares your shop’s price to competitors, and keeps only products where a competitor is cheaper.
- Appends one row per undercut product (including gap and gap %) to a Google Sheets tab.
- Sends one Slack message to a selected channel listing the top 10 biggest undercuts and the total count found.
Setup
- Create a Scrapewise group with price monitoring and product matching enabled, then generate a Scrapewise API key and add it as an HTTP Bearer Auth credential.
- Update the group ID, your shop name, and the match/shop/price/title column names in the workflow settings to match your Scrapewise table headers.
- Connect your Google Sheets OAuth credentials and set the target spreadsheet ID and sheet name (for example, a tab named “Price gaps”).
- Connect your Slack credentials and choose the target channel (for example, #pricing).
🔗 Nodes Used
Google Sheets, Slack, Schedule Trigger, MCP Client
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File