Click "Try this template".

Click "OK" and give the Flowbot a name to recognize.

The template will be copied to your "My Project".

Step 3: Set Up Google Business Profile Trigger Action

Click on the trigger action with the Google Business Profile icon. 

The next screen is pre-configured. You can change the title if you want. 

Then, set your trigger interval (how often you want Yoom to check Google Business Profile for new updates).
It can be set to 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. We recommend setting the trigger to the shortest activation interval available for your plan. 

⚠️ Note: The trigger interval varies depending on your Yoom plan. Be sure to check your current plan’s limit.

‍

Fill out the Account ID and Location ID. 

Copy and paste each Google Business Profile ID as outlined in the instructions at the bottom of the box or select from the displayed options.

‍‍

Once set, click “Test”. 

If the test succeeds, the retrieved value will get updated. Check if it's correct, and click “Save”.

Step 4: Add Record to Google Sheets

Click on the action with the Google Sheets icon. 

Select Spreadsheet ID:

Choose the Spreadsheet ID from the displayed options.

‍

Select Tab Name:‍

Choose the Tab Name where the data will be stored.‍

‍
Define Table Range (Optional):
You can optionally specify the Table Range where data will be saved.

📚 Reference: For more details on table range settings, check this guide.

Map the Data:‍

Click on each item field and assign the corresponding data from the retrieved value to each field.

‍

The data from Google Business Profile will appear in a list. Select the data that matches the name of the corresponding box item. For example, if the box item name is “Star Rating” choose “Star Rating” from the Google Business Profile data.

‍

The data can be inserted as shown in the image below. ⬇️

Test the Setup:‍

After setting the data, click Test to check if everything is configured correctly.

Once you confirm the test is successful, click "Save".

Step 5: Activate the Flowbot

Toggle the "Trigger On" button to activate your flow!
Check if the Flowbot you set up is working properly.

That’s it! 🎉 The Flowbot is now complete!

💡 Other Automation Examples Using Google Business Profile and Google Sheets

By using Google Business Profile and Google Sheets, you can unlock a wide range of automation possibilities that simplify your workflows. <span class="mark-yellow">Here are some examples you can explore for your next automation</span>!

Automation Examples with Google Business Profile and Google Sheets

Managing Local Posts on Google Business Profile via Google Sheets

Automation Examples Using Google Sheets

Automate Invoice Creation 

Automate User Deletion 

Automate Daily Report Retrieval and Notifications 

Automation Examples Using Google Business Profile

Automate Review Notifications to Chat Tools When a Review is Posted

Automatically Add Reviews to Database Apps

👏 Benefits of Integrating Google Business Profile with Google Sheets

Benefit 1: Easy Review Sharing

With this integration, new reviews posted on Google Business Profile are automatically added to Google Sheets. <span class="mark-yellow">This makes it easier to track and verify reviews in one place</span>. 

Manually transferring reviews each time they are posted can be inefficient, and waiting until a certain number of reviews accumulate can delay your responses. This integration eliminates that delay, allowing you to interact with customers more quickly and efficiently. 

Benefit 2: Saving Time & Less Manual Work

Manually transferring reviews can be time-consuming, and since reviews can be posted at any time, you need to frequently check your Google Business Profile. 

By automating this process, <span class="mark-yellow">you no longer need to constantly check for new reviews or manually update Google Sheets</span>. This saves you time and helps prevent tasks from piling up, ensuring that reviews are analyzed promptly and consistently.

Benefit 3: Simplified Review Management

When reviews are transferred to Google Sheets, you get not only the review comments but also star ratings, reviewer names, and review IDs. This data can be easily filtered in Google Sheets to help you search and review specific reviews. 

For example,<span class="mark-yellow"> you can quickly identify reviews from regular customers or find reviews with low ratings that need attention</span>. With easier access to review data, you can make more informed decisions and drive improvements in your business.

📖 Summary

Integrating Google Business Profile with Google Sheets provides a powerful way to quickly understand and address customer feedback. By automatically collecting and organizing reviews, you can efficiently manage customer insights and use them to drive future business growth. 

 <span class="mark-yellow">Best of all, no technical expertise is needed, and anyone can easily set it up</span>! Ready to simplify your workflows? Sign up for Yoom and try it today!

👉 Create your free Yoom account now