Weekly Glassdoor Employer Brand Pulse in Slack

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.

Additional information

What does this prompt do?

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 do I need to use this?

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 can I 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.

Frequently asked questions

Do we need a Glassdoor employer account to use this?

No. This reads public Glassdoor data about your company, the same information any candidate sees. You do not need a paid Glassdoor Employer Branding subscription.

How does it know which Glassdoor page is ours?

On the first run it looks up your company by name on Glassdoor and stores the match. After that it reuses the same employer profile every week so the numbers are consistent.

What if there are no new reviews in a given week?

You still get the Monday post with your current rating and recommend and CEO scores. The new-reviews section simply says no new reviews this week, so you always have a snapshot on file.

Will this spam our channel if the rating barely moves?

No. The tone is factual, not alarmist. A loud callout only appears when your overall rating drops by more than the threshold you set, so quiet weeks read as a quiet update.

Can we keep the historical trend in our own BI tool?

Yes. The Google Sheet is the log of record, so you can connect it to Looker Studio, Tableau, or any tool that reads Sheets and chart your employer brand trend over time.