• 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

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
Launching Your Estate Agency in a New Area? Grow Your Brand and Manage Leads Effortlessly with Agent Response

Starting your estate agency in a new area can be challenging, but with the right tools in place, you can streamline processes, enhance customer service, and build your brand quickly. With Agent Response, you have access to a set of features designed to help you expand your reach, nurture leads, and provide exceptional service without… Continue reading Launching Your Estate Agency in a New Area? Grow Your Brand and Manage Leads Effortlessly with Agent Response

The Agent Response Team
The Agent Response Team January 28th, 2025
Pre-Qualifying Tenants: Your Key to a Stress-Free January

The new year can be one of the busiest times for letting agents, with an influx of enquiries and a race to secure tenants. But for hundreds of forward-thinking agents, this January has been different. Thanks to automated tools and pre-qualification systems set up before the Christmas period, they’ve hit the ground running, focusing on… Continue reading Pre-Qualifying Tenants: Your Key to a Stress-Free January

The Agent Response Team
The Agent Response Team January 20th, 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