Benchmark employer brand on Glassdoor with Bright Data, OpenAI, Sheets and Slack
Ready for 3.0What this workflow does
This AI workflow has 24 nodes and runs on a schedule (every day at 09:00) (plus 2 other triggers). Along the way it connects OpenAI Chat Model and Slack. It also calls api.brightdata.com over HTTP.
How it runs
Trigger: On a schedule (every day at 09:00) (plus 2 other triggers).
- Settings (Edit Fields (Set)): sets 5 fields: your_company_url, competitor_urls, days_back…
- Say It Broke (Slack): post (message)
- Read The Last Run (Data table): get
- Plan The Crawl (Code): runs custom JavaScript code
- Loop Over The Companies (Loop Over Items (Split in Batches)): loops over the items in batches
- Line Up The Windows (Code): runs custom JavaScript code
- Ask Glassdoor For Reviews (HTTP Request): calls api.brightdata.com (POST)
- Enough To Compare? (If): checks a condition and branches into true / false
- Wait: waits 30 seconds
- Read What Your Own Staff Say (Basic LLM Chain): sends a prompt to an LLM, with model: Model
…plus 10 more steps. See the full node list below.
Services it uses
HTTP calls to: api.brightdata.com
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 (14)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Data table
n8n-nodes-base.dataTable - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Wait
n8n-nodes-base.wait - If
n8n-nodes-base.if - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Split Out
n8n-nodes-base.splitOut - Slack
n8n-nodes-base.slack - Error Trigger
n8n-nodes-base.errorTrigger
From the author
Quick overview This workflow runs monthly (or on demand) to crawl Glassdoor reviews via Bright Data for your company and competitors, aligns the review date windows, benchmarks ratings across Glassdoor dimensions, uses OpenAI to summarize recurring “cons” for…