Monitor competitor prices and stock with Gemini, Google Sheets and Slack alerts

## Monitor competitor prices and stock with Gemini, Google Sheets and Slack alerts ### Who it's for Shop owners and pricing analysts who check competitor product pages by hand and want a Slack ping only when a price or stock status really changes. ### How it works 1. Daily Price Check reads your Watchlist and History tabs; duplicate, inactive and recently checked URLs are skipped. 2. Each page is read politely, one at a time: first by the free Product Page Extractor demo API (no key, 10 pages a day), then by the workflow's own fetch (JSON-LD, meta tags, microdata). 3. Pages without structured data go to Gemini (strict JSON, 5 retries), with a page-text fallback if Gemini fails. 4. Compare with Last Price logs every check to History and alerts Slack only on real price moves (minChangePct) or stock flips. 5. Failed checks and Sheets or Slack errors go to the Errors tab; a run summary is posted to Slack. ### Setup (about 10 minutes) 1. Create a Google Sheet with tabs Watchlist (product, competitor, url, my_price, currency, target_price, active), History and Errors (headers in the template description). 2. Open Config and set sheetId and slackChannelId; thresholds are optional. 3. Add credentials: Google Sheets OAuth2, Slack OAuth2 (chat:write) and a free Google Gemini API key. 4. Run once to record a baseline, then activate. ### Customization Change the schedule, delaySeconds, or swap Slack for Gmail or Telegram. More than 10 products a day? Subscribe to the Product Page Extractor on RapidAPI (https://rapidapi.com/MohamedBahaa/api/product-page-extractor). Respect each site's terms and robots.txt. Need undercut alerts, suggested repricing, Apify for blocked sites and a weekly summary? Pro version: https://mohabaha0.gumroad.com/l/price-monitor-pro