On a schedule
Email me Google reviews I haven't replied to
Every Monday, an email lists Google reviews on a Business Profile that still have no owner reply, lowest rating first, with how many days each has waited.
- Runs
- On a schedule
- Apps
- Google Business Profile
- AI
- Not needed
- Access
- read (business.manage)
Send this to your assistant
Create a ClickRuntime automation: every Monday at 9, email me the Google reviews for my business that I haven't replied to yet, lowest rating first, with the reviewer, the stars, the text and how many days ago they were left.
First time? Adding ClickRuntime to your assistant takes about two minutes.
Why use it
Why teams use this automation
Replying to reviews is one of the few things on a Google profile that customers notice directly, but it is also easy to put off. A review comes in on a busy Saturday and is still unanswered a month later.
This automation emails you every Monday with the reviews that still have no reply, lowest rating first, and how many days each has waited. It is a short weekly to-do list rather than a stream of alerts.
It only reads reviews, so you write every reply yourself, in your own voice.
What you get out of it
Nothing slips through
Any review without a reply shows up until you answer it.
Worst first
Low ratings are at the top of the list.
A weekly habit
One email on Monday instead of constant pings.
Age shown
You can see how long each customer has been waiting.
You stay in control
It never posts replies on your behalf.
How it works
What happens, step by step
Every Monday morning, ClickRuntime reads the reviews on your Google Business Profile.
It keeps reviews that have no reply from you.
It sorts them by star rating, lowest first, and adds how long each has waited.
You get one email with the list and a link to reply in Google.
Before it runs live
- Connect Google Business Profile
What you get
Build your own
Need it to work differently?
Your own rules
Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.
Any number of apps
One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.
AI where it helps
Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.
On a schedule or on each event
Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.
Changes you can ask for
- Run it at a different time, more or less often, or only on weekdays
- Add an AI step, for example to summarize, sort or draft a reply
- Add another app, for example also send it to Slack
- Combine it with other Google Business Profile steps into one automation
Under the hood
The code that runs this automation
from datetime import datetime, timezone
from clickruntime import on_trigger, credentials, http, notify, report_fetched
LOCATION = "accounts/1234567890/locations/9876543210" # Rosa's Bakery
STARS = {"ONE": 1, "TWO": 2, "THREE": 3, "FOUR": 4, "FIVE": 5}
@on_trigger
def run(event):
reviews, token = [], None
while True:
resp = http.get(f"https://mybusiness.googleapis.com/v4/{LOCATION}/reviews",
params={"pageSize": 50, "pageToken": token},
headers={"Authorization": f"Bearer {credentials.connection('google', 'work')}"})
resp.raise_for_status()
data = resp.json()
reviews += data.get("reviews", [])
token = data.get("nextPageToken")
if not token:
break
open_ = [r for r in reviews if not r.get("reviewReply")]
report_fetched(len(open_))
if not open_:
return {"unanswered": 0}
now = datetime.now(timezone.utc)
blocks = []
for r in sorted(open_, key=lambda r: (STARS[r["starRating"]], r["createTime"])):
s = STARS[r["starRating"]]
age = (now - datetime.fromisoformat(r["createTime"].replace("Z", "+00:00"))).days
text = f"\n\"{r['comment']}\"" if r.get("comment") else " · (no text)"
blocks.append(f"{'★' * s}{'☆' * (5 - s)} {r['reviewer']['displayName']} · {age} days ago{text}")
notify.email_me(f"{len(open_)} Google reviews without a reply",
"\n\n".join(blocks) + "\n\nReply at https://business.google.com/reviews")
return {"unanswered": len(open_)}FAQ
Common questions
Why lowest rating first?
Does it include reviews with stars but no text?
What access does it need?
What permissions does it need?
Does it need AI?
How many runs does it use?
Can I change how it works?
Related
You might also like
Get alerted when Google changes my business listing
Every morning, the Business Profile is checked for edits Google has applied from users or its own data, and an email shows which fields changed and their new values.
See how it worksGet a monthly summary of your Google reviews
On the 1st you see last month's average rating, how many reviews came in and the complaints that came up most.
See how it worksPost a weekly update to Google Business Profile with AI
Every Tuesday, AI writes a short What's New post from a list of topics and publishes it to the Google Business Profile with a Learn more button, then emails a copy.
See how it worksKeep exploring
Set up “Email me Google reviews I haven't replied to” from your assistant
Copy the prompt above, or connect your assistant first. Free plan, no credit card.