■Overview
This is a flow that adds reviews to a Google Spreadsheet when they are posted on a Google Business Profile.
■Recommended for
1. Those who want to analyze customer feedback
・For those who want to understand customer trends and improve services by accumulating and analyzing review data on Google Spreadsheets
2. Departments managing reviews on Google Spreadsheets
・For those who want to improve work efficiency by automatically adding reviews to Google Spreadsheets, eliminating the need for manual input
■Benefits of using this template
Customer feedback on Google Business Profile is a valuable data collection, but managing it manually when reviews increase can be labor-intensive and may lead to delayed responses.
By implementing this flow, reviews are automatically added to the Google Spreadsheet database when posted.
This allows the person in charge to immediately share and respond to the review content with the team without missing any reviews, enabling them to focus on providing higher quality services and improving work efficiency.
■Notes
・Please link both Google Business Profile and Google Spreadsheets with Yoom.
・You can select the trigger activation interval from 5, 10, 15, 30, or 60 minutes.
・Please note that the shortest activation interval varies depending on the plan.


When a review is posted or updated
When a row is added
When a row is updated
Get List of Reviews
Get Review
Reply to Review
Create Local Post
Retrieve Daily Metrics Data
List Locations
Input Value into Cell
Retrieve Value
Delete Values
Create a New Spreadsheet
Copy Sheet (Tab)
Add a New Sheet (Tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Information
Get Sheet Names
When a review is posted or updated
Get List of Reviews
Get Review
Reply to Review
Create Local Post
Retrieve Daily Metrics Data
List Locations
When a row is added
When a row is updated
Input Value into Cell
Retrieve Value
Delete Values
Create a New Spreadsheet
Copy Sheet (Tab)
Add a New Sheet (Tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Information
Get Sheet Names
Repeat Formula
Input Values into Range
Embed Image in Cell
Sort by Specific Column
Hide Sheet
Add Note to Specified Cell
Add Column
Delete Columns