Track competitor prices and reviews with API.SH, Google Sheets, and Slack

Quick overview

This workflow monitors competitor listings on Amazon, Walmart, and eBay using API.SH, logging daily price/stock/rating changes to Google Sheets and sending Slack alerts, plus a weekly digest built from historical checks.

How it works

1. Runs every day at 7:00 to check your watchlist, and every Monday at 8:00 to post a weekly digest.
2. Reads active products from the Google Sheets Watchlist tab, detects the marketplace from the platform column or listing URL, and prepares one check per product.
3. Fetches current listing data from Amazon, Walmart, or eBay via API.SH, and optionally pulls the latest Amazon/Walmart reviews for rows marked to watch reviews.
4. Compares the latest price, stock status, rating, and low-star reviews against the previous values stored in the watchlist and the Google Sheets Reviews log.
5. Appends each successful check to the Google Sheets History tab, updates the Watchlist row with the latest baseline values, and logs newly discovered low-star reviews to the Reviews tab.
6. Writes failed lookups to the Google Sheets Errors tab and posts a Slack warning, while continuing to process the remaining products.
7. Posts a single Slack message summarizing all detected changes for the day, and on Mondays summarizes the last 7 days of History into a week-over-week Slack digest.

Setup

1. Add API.SH credentials (API key) and ensure the API.SH community node is installed.
2. Connect Google Sheets OAuth and create a spreadsheet with Watchlist, History, Reviews, and Errors tabs, using the Watchlist headers expected by the workflow.
3. Connect Slack credentials and set the target channel name in the Settings values.
4. Update the Settings values for the Google Sheet URL, Amazon delivery ZIP, and alert thresholds (price drop/rise %, rating drop, and low-star maximum).
5. Run the workflow once manually to populate baseline values in the Watchlist before relying on alerts.