How to Use Pabbly Connect for Google Business Profile Reviews Integration

Learn how to integrate Google Business Profile with Google Sheets and Slack using Pabbly Connect for automated review notifications. Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin using Pabbly Connect, first, access the platform by visiting the official website. If you are a new user, click on ‘Sign Up for Free’ to create an account. Existing users can simply click on ‘Sign In’ to log into their accounts.

Once logged in, you will see various Pabbly applications. For this integration, select Pabbly Connect to create workflows that connect your Google Business Profile with Google Sheets and Slack. Click on ‘Access Now’ to proceed to your dashboard.

2. Creating a Workflow in Pabbly Connect

In your Pabbly Connect dashboard, click on the ‘Create Workflow’ button. You will be prompted to name your workflow. For this tutorial, name it ‘Notify Team on Slack for New Google Business Profile Review and Add Review in Google Sheets’.

• Click on ‘Create’ to open the workflow window.
• Select Google Business Profile as the trigger application.
• Choose ‘New Review’ as the trigger event.

After selecting the trigger, click on ‘Connect’ to link your Google Business Profile account with Pabbly Connect. If you haven’t connected it before, you’ll need to add a new connection by signing in with your Google account and granting the necessary permissions.

3. Setting Up Google Sheets for Data Storage

Next, we will set up Google Sheets to store the review data. In the action application section of your Pabbly Connect workflow, search for and select Google Sheets. Choose ‘Add New Row’ as the action event and click on ‘Connect’.

Authorize Pabbly Connect to access your Google Sheets account. Once connected, select the spreadsheet titled ‘Customer Review Tracker’ and the specific sheet within it. You will now map the fields such as customer name, rating, and review text from the previous step.

• Map the customer name from the Google Business Profile response.
• Map the rating and review text similarly.

Once mapping is complete, click on ‘Save and Send Test Request’ to ensure the data is correctly added to Google Sheets. You should see a confirmation of the successful addition.

4. Notifying Your Team on Slack

After successfully adding the review data to Google Sheets, the next step is to notify your team on Slack. In the action application section, select Slack and choose ‘Send Channel Message’ as the action event.

Connect your Slack account to Pabbly Connect by selecting the token type (User or Bot) and granting the required permissions. Once connected, choose the channel where you want to send the notification.

Craft a message that includes the new review alert along with mapped details. Ensure to include customer name, rating, and review text in the message.

Finally, click on ‘Save and Send Test Request’ to send the notification to Slack. Check your Slack channel to confirm that the message was successfully sent.

5. Final Setup and Testing of the Workflow

With both Google Sheets and Slack set up, your Pabbly Connect workflow is almost complete. Remember that Google Business Profile is a polling-based application, meaning it checks for new data at specified intervals. You can adjust this interval in the settings if needed.

To finalize, review your workflow to ensure all connections and mappings are correct. Test the entire setup by adding a new review to your Google Business Profile and observe if it reflects in Google Sheets and notifies your Slack channel as expected.

Once confirmed, you can relax knowing that your automation is set up correctly and will run in real-time, keeping your team updated with customer feedback.

Conclusion

This tutorial has detailed how to use Pabbly Connect to integrate Google Business Profile with Google Sheets and Slack for efficient review management. With this setup, you can automate notifications and keep track of customer feedback seamlessly.