Track Customer Feedback in Airtable from Google My Business Reviews Automatically with Pabbly Connect

Learn how to automatically track Google My Business reviews in Airtable using Pabbly Connect. Follow this detailed step-by-step tutorial for seamless integration. Explore systematic approaches to creating efficient automation solutions that convert technical concepts into practical, implementable instructions.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Google My Business Reviews

To start tracking customer feedback from Google My Business reviews automatically, you first need to set up your account on Pabbly Connect. Go to the Pabbly Connect website and sign up for a free trial account. This platform will serve as the central hub for integrating Google My Business with Airtable.

After signing up, log in to your Pabbly Connect dashboard. Here, you will create a new workflow that will connect your Google My Business account to Airtable. Follow these steps to create your workflow:

• Visit the Pabbly Connect dashboard and click on the ‘Create Workflow’ button.
• Name your workflow (e.g., ‘Get Google My Business Reviews on Airtable’).
• Click ‘Create’ to start building your integration.

With your workflow created, you are now ready to set the trigger for new reviews from Google My Business.

2. Setting the Trigger for New Reviews in Google My Business

The next step involves configuring the trigger in your Pabbly Connect workflow. This trigger will activate whenever a new review is submitted on your Google My Business page. Click on the trigger window and select Google My Business as your app.

Now, choose the event as ‘New Review’. Connect your Google My Business account by clicking on the ‘Connect’ button. You will need to authorize Pabbly Connect to access your Google My Business account. After connecting, select the specific business location for which you want to track reviews.

• Click on ‘Add New Connection’ and authorize access to your Google My Business account.
• Select the business location from which you want to capture reviews.
• Test the connection by clicking ‘Save and Send Test Request’ to fetch the latest review.

This setup ensures that every time a customer submits a review, it will be captured in your Pabbly Connect workflow.

3. Formatting the Review Date for Airtable

After setting the trigger, the next step is to format the review date before sending it to Airtable. Pabbly Connect allows you to use the Date Time Formatter feature to adjust the date format as needed. Click on the action step and select ‘Date Time Formatter’ from the list of applications. using Pabbly Connect

In the action event, select ‘Format Date with Time Zone’. Map the date you captured from the Google My Business review. Specify the format you want to convert to and the time zone. This will ensure that the date is correctly formatted for your Airtable records.

Select the date field from the Google My Business review data. Choose the format you want to convert to, such as ‘YYYY-MM-DD’. Set the time zone to your preference, like ‘Asia/Kolkata’.

Once formatted, the date will be ready to be sent to Airtable along with the review details.

4. Sending Review Data to Airtable

Now that you have the review data and formatted date, it’s time to send this information to Airtable. In your Pabbly Connect workflow, add a new action step and select Airtable as the application. Choose ‘Create Record’ as the action event to insert the review into your Airtable base. using Pabbly Connect

Connect your Airtable account by providing the API key, which you can find in your Airtable account settings. After connecting, select the base and table where you want the review data to be stored. Map the fields for name, review comment, star rating, and the formatted date.

Provide your Airtable API key for authentication. Select the correct base and table from your Airtable account. Map the relevant fields with the captured data from Google My Business.

After mapping, click on ‘Save and Send Test Request’ to verify that the data is correctly sent to Airtable.

5. Recap and Finalizing Your Pabbly Connect Workflow

With the integration steps completed, let’s recap what has been accomplished using Pabbly Connect. You have successfully set up a workflow that captures new reviews from Google My Business and sends them to Airtable automatically. This eliminates the need for manual tracking of reviews.

To finalize your workflow, make sure to save all your changes in Pabbly Connect. You can also clone this workflow for other business locations or different applications as needed. This automation not only saves time but also ensures that you have all customer feedback organized in one place.

By following these steps, you can now effectively track customer feedback from Google My Business in Airtable, enhancing your business operations and customer engagement.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automatically track Google My Business reviews in Airtable. By setting up triggers and actions, you can streamline your feedback management process effortlessly. Start utilizing this integration today to enhance your customer service efficiency.