How to integrate Google Business Profile with Airtable to add reviews to Airtable when they are posted on Google Business Profile

Google Business Profile is a tool that many companies use to directly approach customers. It seems to be particularly useful in building trust with customers by collecting user feedback through reviews. By integrating Airtable, review data is automatically organized into a database, making management even smoother. Previously, specialized programming settings were required, but with our no-code Flowbot template, you can save on setup effort and achieve automation. We will introduce specific usage and benefits. Please read to the end.

Recommended for

The Flowbot introduced this time is perfect for the following people:

Those who utilize Google Business Profile
Marketing personnel who want to manage customer reviews without missing any
Those who find data entry tasks time-consuming and tedious

Benefits and 3 Specific Use Cases of Automatically Adding Google Business Profile Reviews to Airtable

This Flowbot is an automation solution particularly useful for marketing and customer support personnel. We will introduce specific use cases from each perspective.

1. Collect and Analyze Customer Feedback

For marketing personnel, quickly gathering and analyzing customer feedback is important. With this Flowbot, reviews posted on Google Business Profile are automatically recorded in Airtable, and information such as star ratings, comments, and the reviewer's name is aggregated in real-time. For example, you can understand how a new campaign is perceived by customers from changes in star ratings and comments, making it easier to make timely decisions for the next steps. The collected data can be customized within Airtable, aiding in the planning of effective marketing campaigns based on customer feedback.

2. Reduce Manual Input Burden and Prevent Errors

Customer support personnel are an important point of contact for enhancing customer satisfaction. By introducing this Flowbot, reviews posted on Google Business Profile are automatically added to Airtable, significantly reducing the burden of manual input. By automatically importing review data, you may prevent errors from manual work and improve data accuracy. In handling reviews, accurate and speedy information gathering becomes possible, which is expected to lead to improved customer satisfaction.

3. Manage Data Visually with Airtable's Versatile Views

Marketing analysts have the role of understanding seasonal trends through the analysis of review data and planning appropriate marketing strategies. By utilizing Airtable's Kanban view, calendar view, and Gantt chart, data can be managed visually. In the Kanban view, you can check the progress of review responses, and in the calendar view, you can see the periods and trends when posts are concentrated. For example, if positive reviews increase after a summer campaign, you can use it as a reference to deploy a similar approach in the fall. By leveraging Airtable's flexible display features, we support accurate marketing initiatives.

From here, we will explain how to set up automation to notify Airtable when a review is posted on Google Business Profile using Yoom's Flowbot template.

[About Yoom]

Integration Process

Register My Apps on Yoom (Google Business Profile and Airtable)
Copy the template
Set up app triggers and database integration
Turn on the trigger button and verify the integration operation

How to Create a Flow to Notify Airtable When a Message is Received on Google Business Profile

Things to Prepare in Advance

We have listed the items needed for the integration work.

Google Business Profile

Login information (email address and password)
Account ID to retrieve reviews
Location ID
- Similarly, click the edit field to select from the candidates, or select the business profile settings from the three-dot icon of "Your business listed on Google."

‍

You can obtain the profile ID by proceeding to the detailed settings.

The business profile ID at the top becomes the location ID. Copy it and paste the sequence of numbers after locations/ to complete the location ID input.

‍

Airtable (OAuth)

‍

Airtable login information
Database to accumulate reviews
- Headers were created from the items obtainable from Google Business Profile. The item names are arbitrary. Setting them with unique values is key.

Step 1: Setting Up My App Integration

Here, we will set up the app information to be registered with Yoom. Log in to Yoom's workspace and click + New Connection within the My Apps screen.

A list of apps that can be connected with Yoom will be displayed. Select the app to connect from the search window and proceed with My App registration.

Google Business Profile

Click the app name that hit in the search results.

Click Sign in with Google and select the Google account to integrate or proceed to log in. Enter the email address and password for integration on the next screen.

Once logged in, proceed to grant permissions.

The screen will switch to allow access from Yoom. Click Select pages and choose the pages to allow access (the page containing the database used for integration is required), then click the Allow button. This completes the My App registration for Google Business Profile.

Airtable

Select Airtable from the search results.

Click Allow access to complete the My App registration for Airtable.

Step 2: Copy Yoom's Flowbot Template to My Project

Click this banner.

The template will be copied to My Project. You can access My Project from the left menu bar.

Step 3: App Trigger "When a Review is Posted"

Click on the first step of the template.

Extract items that can be obtained from Google Business Profile.

(1/2) Select Linked Account and Action

The items displayed here are pre-configured.

App Trigger Title
App
Account Information Linked with Google Business Profile
Trigger Action

→ Click Next

(2/2) API Connection Settings for App Trigger

Trigger Activation Interval
- You can select from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
Account ID
- Click the edit field to open a dropdown. The ID corresponding to the business account will be picked up from the linked accounts. Selecting the relevant account will quote the ID.

Location ID
- Similarly, click the edit field to display candidates.
- Alternatively, the sequence of numbers from the pre-obtained business profile ID becomes the location ID. Enter the sequence after locations/ to complete the setup.

‍

→ Click Test → Success. In addition to the review content, you can also obtain the reviewer's name and star rating.

‍

→ Click Save

Step 4: "Register Record" to Link with App

Next, click on the second step of the template.

In this step, you will configure the settings to add to the Airtable app.

(1/2) Select Linked Account and Action

The items displayed here are pre-configured.

App Trigger Title
App
Account Information Linked with Airtable
Action

→ Click Next.

(2/2) Detailed Settings for Database Operations

Enter values in the following edit fields. All can be obtained from the URL.

Base ID
Table ID or Name

Record Information

Link the output obtained from Google Business Profile to each item in the Airtable app.

Field Name
- Enter the table item name. In the sample table, it would be something like creation date.
Value
- Click the edit field to display the output obtained from Google Business Profile. Link the appropriate value to the field from the output.

In the default display, only one box for entering values is shown, but click "Add Record Information" to increase the boxes according to the number of items and link the output to all items. This time, the item names are matched to the output content, so there will be a total of 8 boxes.

‍

→ Click Test. → Success

→ Click Save. This completes the setup of this flow bot.

Step: Turn ON the App Trigger

Once all steps are configured, a complete screen will be displayed.

Turn ON the Trigger to activate the flow bot. Please toggle the switch located at the top left of the template.

<span class="mark-yellow">You have set up the flow bot without programming.</span> The review information has been added to Airtable.

Here is the template used this time.

Make the Most of It! 3 Ways to Automate Using the Google Business Profile App

In addition to Airtable, Google Business Profile can be integrated with apps to leverage automation.

1. Automatically Add Review Data to kintone for Efficient Analysis

Automatically add reviews posted on Google Business Profile to kintone. You can list reviews without manual work and use it as a database for marketing and improvement purposes.

2. Notify Reviews on Slack for Smooth Response

Automatically notify reviews posted on Google Business Profile to Slack. Members can quickly grasp the reviews, enhancing information sharing efficiency. This leads to faster responses and makes it easier to improve customer satisfaction.

3. Automatically Add Reviews to Notion for Internal Knowledge Sharing

When a review is posted on Google Business Profile, it will be added to Notion. This ensures that customer feedback is shared seamlessly with internal team members.

Summary

By using this flowbot, reviews from Google Business Profile are automatically stored in an Airtable database. The aggregation of reviews makes it easier for each person in charge to understand customer feedback and aids in analysis. Accumulating data in Airtable establishes a data foundation that can be quickly and effectively utilized for customer service and marketing strategies, leading to improved customer satisfaction. The flowbot is intuitive to operate, so please consider implementing it with confidence. You can proceed with the implementation of the template from the banner below.

‍

See you again!

‍