Quick overview
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 your weakest area, logs results to Google Sheets, and posts a scorecard to Slack. How it works Runs on a schedule at 9:00 (or manually) and loads your company and competitor Glassdoor review URLs plus runtime settings. Triggers a separate Bright Data Glassdoor dataset crawl for each company URL and polls Bright Data until all snapshots are ready or the maximum poll count is reached. Downloads each company’s reviews from Bright Data, filters out crawl errors, and normalizes fields like employee type (current vs former) and rating dimensions. Aligns all companies to the same comparable date window, calculates per-dimension averages only across reviews that answered each sub-rating, and identifies the dimension where your company trails the best competitor by the largest gap. Sends the “cons” text from your company’s reviews for that weakest dimension to OpenAI to produce a short plain-language theme summary. Builds a Slack scorecard message and a per-company, per-dimension table of metrics, appends the rows to Google Sheets, and posts the scorecard to the configured Slack channel. If the workflow can’t produce a valid comparison or the run fails, it posts a failure/diagnostic message to Slack. Setup Create a Bright Data Header Auth credential named Authorization with the value Bearer YOUR_BRIGHT_DATA_KEY and select it for the Bright Data HTTP requests. Add an OpenAI credential/connection for the Chat model used to summarize review “cons”. Add Google Sheets OAuth credentials and replace the spreadsheet URL/ID (and ensure the target sheet name exists, e.g. “Employer brand”) for the append step. Add Slack credentials, set the target channel in the Settings values, and set the error-alert channel (default is #alerts) for failure notifications. Update the Settings values with your Glassdoor “Reviews” URLs (ensure the employer ID after -E is correct), plus optional polling and lookback parameters. An n8n automation workflow template by Daniel Shashko.
Daniel Shashko
web
free
Others in the same category, ranked by how often they are opened.
