📊 Monitor competitor pricing page changes with OpenAI, Google Sheets and Slack
⚡ 19 views · 📊 Market Research & Insights
💡 Pro Tip — For competitive intelligence, ScraperNode can automate the data collection — Yelp reviews, Glassdoor company data, and Crunchbase profiles all return structured JSON you can feed straight into this workflow.
Description
Quick overview
This workflow checks competitor pricing pages each morning, compares the latest visible text to the previous snapshot stored in Google Sheets, and uses OpenAI to summarize meaningful changes before posting an alert to a Slack channel.
How it works
- Runs every day at 08:00 on a schedule.
- Reads your configured list of competitor page URLs and processes each URL individually.
- Fetches each page’s HTML, extracts the visible body text, and trims it to a snapshot for comparison.
- Looks up the previous snapshot for the same URL in Google Sheets.
- If a previous snapshot exists and the content differs, OpenAI generates a 1–3 bullet summary of meaningful changes based on your watch criteria.
- Posts the change summary to Slack and then appends or updates the URL’s latest snapshot and “Last Checked” timestamp in Google Sheets.
- If no previous snapshot exists or no change is detected, it skips the Slack alert and only saves the current snapshot to Google Sheets.
Setup
- Add credentials for Google Sheets, Slack, and OpenAI (Chat) and select the target Slack channel.
- Create or choose a Google Sheet with columns named URL, Content, and Last Checked, and set the Spreadsheet ID and sheet name in both Google Sheets steps.
- Update the URL list and “watchFor” text in the settings step to match the competitor pages and changes you care about.
- Adjust the schedule time (and frequency if needed) to control how often the pages are checked.
🔗 Nodes Used
Google Sheets, HTTP Request, Slack, Schedule Trigger, AI Agent, OpenAI Chat Model
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File