Integrating Google My Business Reviews with Google Sheets Using Pabbly Connect

Learn how to automate Google My Business reviews into Google Sheets using Pabbly Connect for efficient data management. Learn to create powerful connections between your critical applications without requiring specialized programming knowledge or extensive technical background.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Google My Business Integration

To start automating your Google My Business reviews into Google Sheets, you need to set up Pabbly Connect. First, sign up for a free account on the Pabbly Connect website. Once registered, log in to access your dashboard.

From the dashboard, click on the ‘Create Workflow’ button. You will be prompted to name your workflow. Choose a relevant name to easily identify your automation later. Once named, click on the ‘Create’ button to proceed to the workflow page.

2. Configuring the Trigger with Google My Business

In this step, you will set Google My Business as the trigger in Pabbly Connect. Select Google My Business from the available applications and choose the trigger event as ‘New Review’. Click on the ‘Connect’ button to establish a connection.

• Select ‘Add New Connection’ and sign in with your Google account.
• Grant the necessary permissions to allow Pabbly Connect access to your Google My Business account.
• After connecting, choose your business location and click on ‘Save and Send Test Request’ to retrieve the latest review.

After successfully fetching the latest review, you will see details such as the star rating, reviewer’s name, and comment. This information will be used in the next steps to organize reviews into Google Sheets.

3. Creating Conditional Paths for Review Ratings

Next, you will set up conditional paths using the router feature in Pabbly Connect. This allows you to handle reviews differently based on their star ratings. First, click on the ‘Add Action Step’ button and select ‘Router’ to create two routes: one for reviews with more than three stars and another for reviews with less than three stars.

For the first route, click on ‘Set Filter and Action Steps’. Choose the star rating from the previous step and set the condition to check if the rating is greater than three. This ensures that only reviews with a rating of more than three stars will proceed through this route.

4. Using Lookup Table to Convert Ratings

To effectively manage the ratings in Pabbly Connect, you will need to convert the star ratings from words to integers. Add another action step and select ‘Lookup Table’. Here, you can create key-value pairs for star ratings such as ‘five’ = 5, ‘four’ = 4, etc.

• Map the star rating from the previous step into the lookup key field.
• Set the corresponding integer value for each rating.
• Test the lookup table to ensure it returns the correct integer values.

Once the lookup table is configured, you can use the integer rating in your filter conditions to route the reviews accordingly.

5. Saving Reviews to Google Sheets

Finally, you will save the reviews into Google Sheets using Pabbly Connect. For the route with more than three stars, select Google Sheets as the action application and choose ‘Add New Row’ as the action event. Connect your Google Sheets account and select the spreadsheet you created for this purpose.

Map the relevant fields from the previous steps to the Google Sheets headers, such as star rating, review comment, and date. Test the connection by clicking on ‘Save and Send Test Request’. You should see the data reflected in your Google Sheets immediately.

Repeat the process for the second route for reviews with less than three stars, ensuring you select the appropriate sheet in Google Sheets. This completes the automation process, allowing you to collect and organize reviews efficiently.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automate the collection of Google My Business reviews into Google Sheets. This integration saves time and enhances data management, allowing you to focus on your business growth.