Learn how to automate WhatsApp alerts for five-star Google Business Profile reviews and log details in Google Sheets using Pabbly Connect. Follow this step-by-step guide!

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Google Business Profile Integration

To automate WhatsApp alerts for five-star Google Business Profile reviews, you need to start with Pabbly Connect. First, open your browser and navigate to the Pabbly Connect website. If you don’t have an account, click on ‘Sign Up for Free’ to create one. You will receive 100 free tasks every month, which is perfect for testing your automation.

Once you have logged in, click on the ‘Access Now’ button under Pabbly Connect. This will direct you to the dashboard where you can create a new workflow. After clicking on ‘Create Workflow,’ name your workflow something descriptive, like ‘WhatsApp Alerts for Five-Star Reviews,’ and click on ‘Create’ to proceed.

2. Setting Up Google Business Profile as the Trigger in Pabbly Connect

In your new workflow, the first step is to set up the trigger using Pabbly Connect. Click on the trigger application box and search for ‘Google Business Profile.’ Select it, and then choose the trigger event as ‘New Review.’ This event will activate the workflow whenever a new review is received.

  • Search for ‘Google Business Profile’ in the trigger application.
  • Select the trigger event ‘New Review.’
  • Connect your Google Business Profile account to Pabbly Connect by clicking ‘Connect’ and following the prompts.

After connecting your account, select your business location. This completes the trigger setup, allowing Pabbly Connect to listen for new reviews on your Google Business Profile.

3. Adding Reviews to Google Sheets Using Pabbly Connect

Once the trigger is set up, the next step is to log the reviews into Google Sheets. Click on the action application box and search for ‘Google Sheets.’ Select it, and for the action event, choose ‘Add New Row.’ This action will automatically add the details of the new review to your specified Google Sheet.

  • Connect your Google Sheets account to Pabbly Connect by clicking ‘Connect’ and authorizing access.
  • Select the spreadsheet you want to use for storing the reviews.
  • Map the fields from the Google Business Profile response to the columns in your Google Sheet.

This setup allows Pabbly Connect to automatically log review details, such as reviewer name, rating, and comments, into your Google Sheet for tracking and analysis.

4. Filtering for Five-Star Reviews in Pabbly Connect

To ensure you only receive WhatsApp alerts for five-star reviews, you will need to set up a filter in Pabbly Connect. Add a new action step and select ‘Filter by Pabbly’ as your action application. Set the filter condition to check if the star rating equals five.

Choose ‘Star Rating’ as the label for your filter. Set the filter type to ‘Equal To’ and enter the value as ‘5’. Save your filter settings to complete this step.

This filter ensures that only five-star reviews trigger the next action, which is sending a WhatsApp alert through Pabbly Connect.

5. Sending WhatsApp Alerts Using AI Sensei via Pabbly Connect

Finally, you will set up the action to send WhatsApp alerts for five-star reviews. Add another action step, search for ‘AI Sensei,’ and select it. Choose ‘Send Template Message’ as your action event. Connect your AI Sensei account to Pabbly Connect by providing the necessary API key.

After connecting, fill in the required fields, including your campaign name and the WhatsApp number to which you want to send alerts. Map the template parameters to include the reviewer’s name, rating, and review comment. This dynamic mapping allows Pabbly Connect to send personalized messages for each review.

Once everything is set up, save your workflow. Now, every time a five-star review is posted on your Google Business Profile, you will receive an alert on WhatsApp, and the review details will be logged in your Google Sheet automatically.

Conclusion

In this tutorial, we explored how to automate WhatsApp alerts for five-star Google Business Profile reviews and log details in Google Sheets using Pabbly Connect. The entire process involves setting up triggers, actions, and filters to ensure efficient tracking and notification of customer feedback.

Ensure you check out Pabbly Connect to create business automation workflows and reduce manual tasks. Pabbly Connect currently offer integration with 2,000+ applications.