Collecting Reviews - With Reminders

Have an idea that seems somewhat easy in my head… but need some help. Want to help clients send out requests for google reviews. As a name is added to a list there is a text sent out with some text and a link to the review. (all easy so far)

But if the user doesn’t do the review would like to have a reminder sent a day or two later to request again - and maybe one more time for a total of three.

Is there a way to track if somebody leaves a Google review or not - so in turn can send a reminder (or not) ?

Just wondering if anybody has any ideas to help set it up?

Hello @Shawn_Ryder ,

Is this list of names stored in any sheets or in a table like Airtable? The current Google My Business piece doesn’t include a request for review action. I will look into it and update you if it’s possible through a custom API. We can fetch reviews and compare them with the existing name list to filter out people who have already reviewed.

Thanks for the reply! Yes the names would likely be stored in a Google spreadsheet. Automatically updated and then each day ‘new’ names get a text or email with a review link. I would like to send a reminder or two for folks that don’t review - but obviously don’t want to over do it.

Hi Shawn,

I just worked something out for my self, there is only one catch. Not everyone uses their own name on the account they use to review, so there might be some manual/AI mapping needed when a review is received.

Create your list, set a column with status, and each item the value ‘0’, when a request for review is send update this status to ‘1’.

As soon as you receive a review from a user you need to start mapping the reviewers name with the names on your list, if they match change the status to ‘10’. If there is no match between the reviewers name and the names on the list, send a trigger to your client that they received a review but no match is made to their list, this will be the manual action to be done, once they found it update the status to ‘10’. Or when it’s not on the list add it manually with status ‘10’

After a week (or the period you like) you can run a worklfow picking up all the rows with status ‘1’ and send them the first reminder, updating the status to ‘2’. And the week after pick up ‘2’ for the third reminder, and so on.

This is how I would approach it, I hope it makes some sence. In case of any questions please reach out.

KR Bram

Awesome thanks for the reply KR Bram!! May I ask one question - how did you pull the names from Google Business to match up the names as a first step? Is that using the current Google API connection?

Please see below, here is the name of the reviewer:

What you could also do (or what I did) is to let any kind of AI create a response, with that you can make even even easier to responed to the reveiw you received.

I will be honest… didn’t know that you can pull reviews like that with a starting point - was looking at it as a step down the line but if you can pull reviews that easy it helps.

That is something that I was thinking too… but a client I have is using another service that is doing it - and sometimes a little… odd in the response so would want to keep it simple. Like a reviewer didn’t know the name of the folks so described them and the reply was pretty funny with “glad the man with the red hat was helpful” or something like that… was pretty funny but not really realistic. Then just on Friday it said “thanks for the five star review” when the review was actually four stars… so not a perfect science (yet).

Ahh I understand but you could help AI here, here is my prompt:

Please create a reply to the review of {name of reviewer}, the review i {amount of stars}, and if there is a comment, please reply to this comment too: {comment} and start with ‘Hi’ and end with Kind regards {name of the client}

no worries we are here to learn! Glad i could help you with this :slight_smile:

Amazing, thanks soooo much!

1 Like