Monitor competitor price gaps with Scrapewise, Google Sheets, and Slack

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).