Weekly Glassdoor employer brand pulse in Slack
Every Monday at 9am, your People team gets a Slack summary of your Glassdoor rating, new reviews, and what employees are saying.
Integrations
Real-Time Glassdoor Data
Google Sheets
Slack
Type
Categories
- HR & People
Build me a weekly employer brand pulse for my People team. I want to know the moment our Glassdoor reputation moves, without having to log into Glassdoor myself.
Trigger: cron, every Monday at 9am local time.
On the very first run, use the Real-Time Glassdoor Data Company Search operation to look up our company by name and resolve the Glassdoor employer ID. Save that ID so future runs reuse the same employer profile and the numbers stay consistent week over week.
Each Monday, do the following:
1. Call Real-Time Glassdoor Data Company Overview with our stored employer ID and capture overall rating, recommend-to-a-friend percentage, and CEO approval percentage.
2. Call Real-Time Glassdoor Data Company Reviews, paginated, and collect every review posted in the last seven days. For each review keep the headline, pros text, cons text, overall star rating, employment status, and the direct link to the review on Glassdoor.
3. Read the previous snapshot from our Google Sheet using Google Sheets Get Values so we have last week's overall rating, recommend percentage, and CEO approval percentage to compare against.
4. Append a new row to that same Google Sheet using Google Sheets Append Values with this week's date, overall rating, recommend percentage, CEO approval percentage, and count of new reviews in the last seven days. This sheet is our running trend line, so always append, never overwrite.
5. Send a Slack message via Send a Message to our designated People channel summarizing the week. The message should include: the current overall rating with the delta versus last week's snapshot, current recommend-to-a-friend percentage and CEO approval percentage with their deltas, the count of new reviews in the last seven days, and the most repeated pros and cons across those new reviews quoted in the employees' own words. If the overall rating dropped by more than 0.1 stars versus last week, include a clear callout at the top of the message. If any single review is especially negative or especially positive and worth attention, link directly to that review on Glassdoor.
Tone: factual and calm, not alarmist. The People team should be able to skim the message in fifteen seconds and know whether the week is quiet or whether it needs attention. Use short lines and clear labels, not long paragraphs.
At setup time I will provide our company name, the Google Sheet to log to, and the Slack channel to post in.
What it does
- Posts a short Slack update every Monday morning with your current Glassdoor overall rating, recommend-to-a-friend percentage, and CEO approval percentage.
- Summarizes new Glassdoor reviews from the last seven days, pulling out the most repeated pros and cons in employees' own words.
- Compares this week's rating to last week's snapshot from a Google Sheet log and flags any drop greater than 0.1 stars.
- Keeps a running trend line of your employer brand by appending each weekly snapshot to the same Google Sheet.
What you’ll need
- A Slack workspace and a channel where you want the weekly update posted.
- A Google account with a Google Sheet you can use as the weekly snapshot log.
- Your company name as it appears on Glassdoor.
How to customize it
- Change the day and time of the weekly post, for example Friday at 4pm instead of Monday at 9am.
- Point it at a different Slack channel, or post in a private People leadership channel only.
- Adjust the alert threshold so it calls out drops of 0.2 stars instead of 0.1, or also flags big upswings.
- Swap the Google Sheet for a different log, or add extra columns like new interview reports or open job count.
Use cases
- Research & Monitoring
- Daily Digests
- Notifications & Alerts
