How to Automatically Transfer Reviews Posted on Google Business Profile to Google Sheets

By adding reviews posted on Google Business Profile to Google Sheets, you can share customer opinions with your team and use them as hints for business development that meets customer needs. However, don't you find it tedious to manually transfer all reviews posted on Google Business Profile to Google Sheets? Therefore, this time, let's automate the process of transferring reviews by linking Google Business Profile with Google Sheets! This should make managing review data easier. If you want to proceed with your work efficiently, please take a look! Recommended for: - Those who want to accumulate review data from Google Business Profile - Teams that want to share data using Google Sheets - Marketing personnel who want to analyze reviews from Google Business Profile - Those who want to simplify the task of transferring reviews from Google Business Profile Benefits and Examples of Linking Google Business Profile and Google Sheets Benefit 1: Smoothly share reviews By introducing this linkage, new reviews posted on Google Business Profile can be automatically transferred to Google Sheets. This should make it easier to smoothly check reviews in Google Sheets. For example, it is inefficient to perform the transfer task every time a review is posted, so don't you wait until a certain number of reviews have accumulated before transferring them? However, this makes it difficult to respond quickly as time passes after the review is posted. This linkage may eliminate such disadvantages and enable smooth customer response. Benefit 2: Save time by reducing manual input Manually transferring all reviews is a somewhat tedious task, isn't it? Also, since you don't know when reviews will be posted, you need to frequently check Google Business Profile. By introducing this linkage, you will no longer need to manually check for reviews or perform transfer tasks, saving time. This should make it easier to avoid situations where you start with the intention of "Let's analyze reviews in Google Sheets!" but end up postponing the task. Benefit 3: Simplify review management The review data transferred to Google Sheets includes not only the review comments but also star ratings, reviewer names, and review IDs. Therefore, by filtering in Google Sheets, you can display only reviews from specific reviewers or with specific star ratings. For example, you might easily identify reviews from regular customers who visit frequently or pick up only reviews with extremely low star ratings for improvement. Easier analysis of review data may lead to easier business improvement. Now, let's introduce the flow of linking apps using Yoom. First, register with Yoom. Yoom offers a 2-week trial, allowing you to test its usability through actual operation. [What is Yoom] This time, we will automate the process of "adding reviews posted on Google Business Profile to Google Sheets" using the template below.

How to Create a Flow for Integrating Google Sheets and Google Business Profile

The integration flow this time is broadly divided into the following processes.

・Integrate Google Business Profile and Google Sheets with My Apps
・Set up Google Business Profile launch
・Set up to transfer to Google Sheets
・Turn on the trigger button and verify the integration operation between Google Business Profile and Google Sheets

Step 1: Integrate Google Sheets and Google Business Profile with My Apps

After completing the registration with Yoom, please select "My Apps" from the menu on the left.

Next, click the new connection button at the top right.

Integration with Google Business Profile

1. Search

Search for Google Business Profile and click the Google Business Profile icon.

2. Log in to Google Business Profile

The above screen will be displayed. Click "Sign with Google".

3. Select an Account
Press the Google account of the Gmail address to be linked with Yoom.‍

4. Log in to Yoom

You will be taken to the image page, read the terms and click next.‍

5. Yoom is requesting additional access to your Google account
Press continue.
When you move to the authentication screen, select <span class="mark-yellow">Allow all permissions</span>.

6. Integration Complete

The screen will switch, and if the above display appears, the integration is complete.

Integration of Google Sheets and Yoom

1. Search
Next is the integration of Google Sheets, but since it is the same Google service as Google Business Profile, the procedure for My Apps integration is the same.

Search for Google Sheets and integrate it using the same procedure as Google Business Profile.

2. Create a Sheet

Create a sheet to accumulate review data from Google Business Profile.

<span class="mark-yellow">The review data that can be obtained this time is as follows.</span>

・Review ID
・Profile Photo URL
・Reviewer Name
・Star Rating
・Comment
・Creation Date
・Update Date
・Resource Name

The recommended items to create are mainly Review ID, Reviewer Name, Star Rating, Comment, and Creation Date.
If there are other data you want to add, set them as desired.

Step 2: Copy the Template

Next, please copy the template to be used this time.

1. Click "View Details" on the top banner
2. Click "Try this template" at the bottom of the transitioned screen
3. If you haven't registered with Yoom yet, please register * If you have already registered, the login screen will be displayed, so please log in. When the Flowbot template is copied to "My Projects", the above display will appear. You will be taken to a page like the image, so let's proceed with detailed settings. Step 3: Launch Settings for Google Business Profile 1. Open My Projects Open "My Projects" from the menu on the left side of the screen. 2. Open the copied template Click "[Copy] Add to Google Spreadsheet when a review is posted on Google Business Profile". 3. Select App Trigger Click "When a review is posted" on the Google Business Profile icon. Since the title and other settings are complete, press Next. 4. Set Trigger Launch Interval You will be taken to the screen in the image. First, set the launch interval. You can select it from the dropdown. Triggers can be set to launch at intervals of 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. Please note that the shortest launch interval varies depending on the plan. 5. Enter ID Copy and paste each ID of the Google Business Profile according to the supplement at the bottom of the box. 6. Run Test After setting the ID, click the test button. If it says test successful, save it. Step 4: Settings to Add to Google Spreadsheet 1. Operate the Database Select "Add Record" on the Google Spreadsheet icon. Scroll down. 2. Set Required Items Enter the required items. Click the box for the Spreadsheet ID. When you click inside the box, a list of created sheets will be displayed as shown in the image, so select the Google Spreadsheet that accumulates review data from Google Business Profile. Set the tab name in the same way. Regarding the table range, it depends on the prepared Google Spreadsheet, so enter it according to the contents of the Google Spreadsheet. Once entered, press Next. 3. Set Values for Records to Add Set the values for the records to add. The box names displayed on this page are linked to the Google Spreadsheet you just connected. Therefore, it may differ from the image display, but the setting method is the same. First, click the box. Select "When a review is posted" on the Google Business Profile icon The data from the Google Business Profile will be displayed in a list. Select the data that matches the box item name. In the image, the box item name is "Star Rating", so I also selected "Star Rating" from the Google Business Profile data. The data can be inserted as shown in the image. Set the other boxes in the same way. 4. Run Test Once the data insertion is complete, press the test button. If it says test successful, the setup is complete. Press save. 5. Turn on the Trigger When the creation of the Flowbot is complete, the above display will appear. The trigger is initially set to OFF, so turn it ON. This completes the app integration. Flowbot template used this time: Add to Google Spreadsheet when a review is posted on Google Business Profile

Other Automation Examples Using Google Business Profile

There are many other examples of automation using Google Business Profile on Yoom, so here are a few.

1.Notify Google Chat when a review is posted on Google Business Profile

It is also possible to integrate with Google Chat. Since two tools can be integrated with one Google account, it is expected to simplify management.

2. Notify on Discord when a review is posted on Google Business Profile

Yoom can also integrate with Discord. You can create multiple threads, making it easier to communicate detailed instructions and responses to reviews.

‍

3. Add reviews to Notion when they are posted on Google Business Profile

It also supports integration with Notion. You can create sub-pages to compile improvement suggestions and add images for creative data management.

Summary

Wouldn't the integration of Google Business Profile and Google Sheets be very beneficial to quickly understand and align with customer needs?
By collecting and managing the obtained reviews, it might be possible to utilize them for future business development.
If you want to efficiently manage customer needs and improve your operations, please take a look!