Monitor competitor prices with OpenAI, Google Sheets, Slack, and Notion
Ready for 3.0What this workflow does
This AI workflow has 19 nodes and runs on a schedule (cron 0 8 * * *). Along the way it connects Google Sheets, Slack, OpenAI and Notion.
How it runs
Trigger: On a schedule (cron 0 8 * * *).
- Build Initial Config Values (Code): runs custom JavaScript code
- Fetch Competitor URLs from Sheets (Google Sheets): get all rows (sheet)
- Loop Over Competitor URL List (Loop Over Items (Split in Batches)): loops over the items in batches
- Create Daily Competitor Summary (Code): runs custom JavaScript code
- Fetch Competitor Web Page (HTTP Request): calls an HTTP API (GET)
- Post Summary to Slack (Slack): uses Slack
- Convert HTML to Plain Text (Code): runs custom JavaScript code
- Process Fetch Error (Code): runs custom JavaScript code
- OpenAI: uses OpenAI
- Post Fetch Error Alert to Slack (Slack): uses Slack
…plus 8 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Slack
n8n-nodes-base.slack - HTTP Request
n8n-nodes-base.httpRequest - OpenAI
@n8n/n8n-nodes-langchain.openAi - If
n8n-nodes-base.if - Notion
n8n-nodes-base.notion
From the author
Quick overview This workflow runs daily to read competitor product URLs from Google Sheets, fetch each page, use OpenAI to extract price and stock status, and send Slack alerts and Notion logs for significant price drops while updating the latest prices back…