n8n Glassdoor Employer Brand Benchmark + Slack Scorecard

Turn Glassdoor into an employer brand scorecard—automatically (Slack + Google Sheets)

This n8n workflow crawls your Glassdoor reviews (and competitors’) via Bright Data, benchmarks ratings across key Glassdoor dimensions, summarizes recurring downsides with OpenAI, then posts a clear Slack scorecard—and logs the full results to Google Sheets.

What this workflow does

• Runs monthly or on demand (scheduled for 9:00, or manually) to benchmark employer brand performance.
• Crawls Glassdoor data for your company and each competitor using a separate Bright Data dataset crawl per Glassdoor review URL, polling Bright Data until snapshots are ready (or max poll count is reached).
• Normalizes and filters reviews by downloading crawl results, filtering out crawl errors, and aligning fields like employee type (current vs former) and rating dimensions.
• Aligns comparable date windows so all companies are compared over the same review date range.
• Benchmarks per-dimension averages, calculating averages only across reviews that answered each sub-rating, then identifying the dimension where your company trails the best competitor by the largest gap.
• Summarizes “cons” with OpenAI: sends the “cons” text from your company’s reviews for the weakest dimension to OpenAI to produce a short, plain-language theme summary.
• Publishes results by building a Slack scorecard message plus a per-company, per-dimension table, appending rows to Google Sheets, and posting to the configured Slack channel.
• Failure visibility: if comparison can’t be produced or the run fails, it posts a failure/diagnostic message to Slack.

Use cases

• Monthly employer branding check-ins for SaaS HR, People Ops, or marketing teams using n8n automation.
• Competitive hiring insights: identify which Glassdoor dimension is underperforming vs key competitors.
• Use the OpenAI “cons” theme summary to guide targeted internal improvements.

Technical details

• n8n nodes / components: if, set, code, wait, slack, split out.
• Integrations: Bright Data (Glassdoor crawls), OpenAI (theme summaries), Slack (scorecard + diagnostics), Google Sheets (results logging).