• blog
  • Using Zapier to manage your Google reviews

September 6, 2021

Using Zapier to manage your Google reviews

byThe Agent Response Team The Agent Response Team



Zapier hosts thousands of apps that you can connect, creating automatic workflows which otherwise may take hours out of your day as an Estate Agent.




Some of my most useful workflows are created by connecting apps to Google Reviews. This is simple but extremely effective.








Google Reviews are of great importance to our Estate Agency. Every month, we would count the number of Google reviews each staff member and office receives, to award them accordingly. However, with 7 different offices, therefore 7 separate Google Business pages, we knew there must be an easier way to record each review.







Our first workflow connects Google Reviews to an Excel spreadsheet. I have outlined below how we set this up.










After clicking ‘Make a Zap’, select Google My Business, and choose ‘New Review’ in the Trigger Event. Sign into your Google Business account when Zapier prompts you to do this, which will allow Zapier to view the account on your behalf. Select the location of the review and continue to test the trigger.


You can now connect this trigger to a second app, which is where we select Excel. You can choose Google Docs or any other file format you prefer.






Before heading to the next step, set up a document format where you would like your reviews to be added, and save it to One Drive or Sharepoint. A screenshot of how ours is set up is added below.






New paragraph






Back in Zapier, select ‘add row’ in the action event, and log in to your excel account. You can then choose where your file is stored- One Drive or Sharepoint and select the file you have previously created.


Connect the date, name, rating, and comment to the correct sections in your test trigger.


Finally, test the action and check your spreadsheet to make sure it has appeared, and columns are correct.




We have also set up a workflow between Google Reviews and Teams. This allows all staff members to see a review as soon as it comes in, without having access to the Google Business page.




With all staff members in one Teams group which all Google Reviews are zapped into, encouragement and motivation to achieve more 5* reviews are at a record high.





More Of Our Recent Articles

Instant Replies: Meeting Consumer Expectations in 2025

In 2025, everybody expects instant replies. Whether they’re looking to book a viewing, arrange a market appraisal, or make an offer, consumers want immediate confirmation and next steps. But as an estate agent, you can’t always be available to answer every call the moment it comes in. That’s where Agent Response’s Phone Answering Service comes… Continue reading Instant Replies: Meeting Consumer Expectations in 2025

The Agent Response Team
The Agent Response Team February 25th, 2025
Stop Leaving Money on the Table: Turn Your Existing Services into £150K Revenue

Estate agents looking to diversify their services and boost their income now have a powerful new tool at their disposal. We are excited to share the latest success stories from our Agent Payment Platform, which continues to help agents streamline transactions, enhance service offerings, and generate significant new revenue. Our online store, fully integrated with… Continue reading Stop Leaving Money on the Table: Turn Your Existing Services into £150K Revenue

The Agent Response Team
The Agent Response Team February 19th, 2025
How Agent Response Fills Customer Service Gaps in Your Agency

Managing a high volume of enquiries can take a toll on your team’s productivity. Agent Response automates tasks by sending instant replies to every lead, ensuring no enquiry is left unanswered. Instant Responses: Every lead gets an immediate reply confirming their request, setting expectations, and keeping the conversation moving. More Time for Agents: By eliminating… Continue reading How Agent Response Fills Customer Service Gaps in Your Agency

The Agent Response Team
The Agent Response Team February 13th, 2025
Maximising Your Agent Response Account: A Simple Guide for Estate Agents

At Agent Response, we’re always looking for ways to help estate agents get the most out of our platform. Many agents may not be taking full advantage of the features available to them! That’s why we’ve put together this guide to help you unlock your account’s full potential. Why You Should Regularly Optimise Your Agent… Continue reading Maximising Your Agent Response Account: A Simple Guide for Estate Agents

The Agent Response Team
The Agent Response Team February 6th, 2025

Tips and Insights

Subscribe to The Agent Response blog

Sign up to get the latest resources and guides to help estate agents streamline their processes, improve client relationships, and achieve greater success