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

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 completed registration, 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 transition 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.
The title and other settings are complete, so press Next.‍

4. Set Trigger Launch Interval

‍

‍

You will transition to the screen in the image.
First, set the launch interval. You can select from the dropdown.

‍

‍

You can select the trigger launch interval from 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. Execute Test

After setting the ID, click the test button.

‍

‍
If "Test Successful" is displayed, 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 Fields

‍

‍

Enter the required fields. 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.

‍

‍

The table range depends on the prepared Google Spreadsheet, so enter it according to the contents of the Google Spreadsheet.
Once entered, press Next.

3. Values of Records to Add

‍

‍

Set the values of the records to be added.
The box names displayed on this page are linked to the Google Spreadsheet you just connected.

‍

Therefore, there may be differences 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 case of 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. Execute Test

‍

‍

Once the data insertion is complete, press the test button.
If "Test Successful" is displayed, the setup is complete. Press Save.‍

5. Turn ON the Trigger

‍

‍

When the Flowbot creation 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

Other Automation Examples Using Google Business Profile and Google Sheets

In addition to the flow introduced this time, you can achieve various business automations by using the APIs of Google Business Profile and Google Sheets.
All of them can be used with simple settings, so if you find something interesting, please give it a try!

Other Automation Examples with Google Business Profile and Google Sheets

It is also possible to create a local post on Google Business Profile when the status is updated in Google Sheets.
This allows you to manage local posts from Google Sheets, which is expected to facilitate the sharing and verification of post content among team members.

Automation Example Using Google Sheets

Every day, obtain the latest ad report from Meta Ads (Facebook), automatically add it to Google Sheets, and notify on Slack

By obtaining the latest ad report at a set time every day and automating the addition to Google Sheets and notifications on Slack, you can expect improved work efficiency.

Create and Send Documents When a Row is Updated in Google Sheets

Since documents can be automatically created and sent every time a row is updated, you should be able to respond to clients more quickly.

Delete Registration Information When a Row is Updated in Google Sheets

Automatically deleting registration information due to updates in Google Sheets can potentially reduce the time spent on manual tasks.

Examples of Automation Using Google Business Profile

Receive Notifications When a Review is Posted on Google Business Profile

With automated notifications, you won't need to check review information each time, allowing you to proceed with your tasks seamlessly.

Add when a review is posted on Google Business Profile

Since data is added seamlessly, you may always have access to the latest information, allowing you to proceed with analysis tasks more quickly.

Benefits of Integrating Google Business Profile with Google Sheets

Benefit 1: Seamless Sharing of Reviews

By implementing this integration, new reviews posted on Google Business Profile can be automatically transferred to Google Sheets.
This allows for smoother and easier verification of posted reviews in Google Sheets.
For example, manually transferring reviews every time they are posted is inefficient, so you might wait until a certain number have accumulated before transferring them. However, this delay can make it difficult to respond quickly to reviews.
This integration has the potential to eliminate such drawbacks, enabling smoother customer interactions.

Benefit 2: Time Savings by Reducing Manual Entry

Manually transferring all reviews can be a somewhat tedious task. Additionally, since you never know when reviews will be posted, you need to frequently check your Google Business Profile.
By implementing this integration, you will no longer need to manually check for new reviews or perform transfer tasks, saving you time.
This makes it easier to avoid situations where you start with the intention of analyzing reviews in Google Sheets, but end up postponing the task.

Benefit 3: Easier Management of Reviews

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 can easily identify reviews from regular customers who visit frequently or pick out reviews with extremely low star ratings for improvement.
Making it easier to analyze review data can lead to more effective business improvements.

Conclusion

Integrating Google Business Profile with Google Sheets is highly beneficial for quickly understanding and addressing customer needs.
By collecting and managing the reviews obtained, you may be able to leverage them for future business development.
If you want to efficiently manage customer needs and use them to improve your business, be sure to take a look!