Google ビジネス プロフィールと楽楽販売の連携イメージ
How to Integrate Applications

2024/11/12

How to Link Google Business Profile with Rakuraku Sales to Automatically Accumulate Reviews in Rakuraku Sales

k.hieda

Google Business Profile is a useful tool that allows users to prominently display business information on Google Search and Google Maps. It helps manage reputation through reviews and provides an effective approach to users with high purchasing intent. Our company has developed a flowbot that integrates this Google Business Profile with Rakuraku Sales, automatically accumulating reviews into a database. This enables the easy creation of data that can be utilized for marketing and product management. In the past, programming was required, but now you can experience the benefits of automation by utilizing a no-code flowbot template. We will explain the setup method and benefits in detail, so please read to the end.

Recommended for

The flowbot introduced this time is perfect for the following people.

  • Those utilizing Google Business Profile
  • Marketing personnel
  • Sales managers
  • Store staff

Benefits and Three Specific Use Cases of Automatically Adding Google Business Profile Reviews to Rakuraku Sales

We introduce a new automation solution for marketing personnel and sales managers to efficiently utilize reviews in their daily operations.

1. Reflect Customer Voices in the Database in Real-Time

Automatically accumulate reviews posted on Google Business Profile into Rakuraku Sales, centralizing real customer voices in the database. This allows marketing personnel to quickly analyze new reviews and always grasp the latest customer needs, as daily changes can be reflected in real-time. The market is constantly moving based on customer reactions and trends, and the ability to deploy strategies based on the latest data in a timely manner is a significant advantage. For example, if a product receives high praise in reviews, that reaction can be immediately utilized in promotions and campaigns.

2. Smooth Operation with Integrated Management of Sales Data and Reviews

By accumulating reviews in Rakuraku Sales, you can manage reviews and sales data in an integrated manner. For sales managers, data analysis that combines sales history and customer voices is extremely beneficial. If a particular product receives many high-rated reviews and frequent repeat purchases, it becomes easier to plan strategies to push similar products or repeat promotion campaigns. Additionally, analyzing reviews by region or purchase frequency makes it easier to conduct area-specific promotions and targeting. Such data-driven strategies ultimately lead to increased sales opportunities and customer loyalty, enhancing store operations.

3. Easy Review Management with Intuitive Operation

Using the easy-to-understand interface of Rakuraku Sales, you can manually categorize accumulated reviews and easily check the details of comments. Tasks such as categorization and detail checking can be done intuitively without complex operations, allowing even staff unfamiliar with the work to smoothly manage reviews. Additionally, staff can quickly check reviews and consider necessary responses, making it easier to improve services and customer interactions. By reducing the effort of review management, it becomes easier to focus on daily operations, improving the overall operational efficiency of the store.

From here, we will explain the setup method for automating notifications to Rakuraku Sales when a review is posted on Google Business Profile using Yoom's flowbot template.

[What is Yoom]

Integration Process

  • Register My Apps in Yoom (Google Business Profile and Rakuraku Sales)
  • Copy the template
  • Set up app triggers and database integration
  • Turn on the trigger button and check the integration operation
※Guidance
  • To use this service, you need to contract the API integration option in Rakuraku Sales and register Yoom's IP address. Please check here for Yoom's IP address.
  • Rakuraku Sales is only available in the Team Plan and Success Plan. Please note that operations and data connections of the set flowbot will result in errors in the Free Plan and Mini Plan.
  • Paid plans such as Team Plan and Success Plan have a 2-week free trial. During this period, you can also use restricted apps.
  • The trigger activation interval can be selected from 5 minutes, 10 minutes, 15 minutes, 30 minutes, and 60 minutes. Please note that the shortest activation interval varies depending on the plan.

How to Create an Integration Flow to Notify Rakuraku Sales When a Message is Received on Google Business Profile

Things to Prepare in Advance

We have listed the items needed during 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 candidates or select Business Profile settings from the three-dot icon of "Your Business Listed on Google".

  • You can obtain the profile ID by proceeding to 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.

Rakuraku Sales

  • Login information for Rakuraku Sales
  • Access token
    • In Rakuraku Sales, proceed from "Administrator Settings" to the "User Settings Tab" and select "User Management > Settings".
    • Click the "Generate" link in the API token field to generate an API token. Please copy this token.
  • Database to accumulate reviews
    • Create items according to the items that can be obtained from Google Business Profile. Setting with a unique value is key.
    • The items that can be obtained are as follows.
      • Review ID
      • Profile photo URL
      • Poster name
      • Star rating
      • Comment
      • Creation date
      • Update date
      • Resource name

Step 1: Setting Up My App Integration

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

A list of apps that can be connected in 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 connect or proceed to log in. Enter the email address and password for the connection on the next screen.

Once logged in, proceed to grant permissions.

The screen will switch to allow access from Yoom. Click Select Page and choose the page 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.

Rakuraku Sales

Select Rakuraku Sales from the search results. A screen for entering each value will be displayed.

  • Access token
    • Please enter any value.

Enter the access token obtained in advance and click Add to complete the My App registration for Rakuraku Sales.

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 the 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 choose from 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes.
  • Account ID
    • Clicking on the edit field will open a dropdown. The ID corresponding to the business account will be picked up from the linked account. Selecting the relevant account will quote the ID.
  • Location ID
    • Similarly, clicking on the edit field will display candidates.
    • Alternatively, the sequence of the business profile ID obtained in advance becomes the location ID. After locations/, enter the sequence to complete the setup.

→ Click Test → Success. In addition to the review content, you can also obtain the poster'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 set up to add to the Rakuraku Sales app.

(1/2) Select Linked Account and Action

The items displayed here are pre-configured.

  • App Trigger Title
  • App
  • Account Information Linked with Rakuraku Sales
  • Action

→ Click Next.

(2/2) Detailed Settings for Database Operation

Link with the database to be added.

  • Domain
  • Account ID
    • The above can be obtained from the URL.
  • DB Schema ID
    • Can be obtained from the Rakuraku Sales administrator settings screen operations.
  • Key Item Registration Mode
    • Opening the dropdown allows you to choose from the following two options:
      • Prioritize Auto Numbering
      • Prioritize Entered Key Value
  • Approval Flow ID (Optional)
Registered Data

Link the output obtained from Google Business Profile to each item in the Rakuraku Sales database.

  • Header Item ID
  • Value
    • Clicking on the edit field will display the output obtained from Google Business Profile. Link the value suitable for the item from among them.
  • In the default display, only one box for entering values is shown, but click "Add Registered Data" to increase the boxes and link the output to all items according to the number of items.

→ 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>

Here is the template used this time.

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

In addition to Rakuraku Sales, you can leverage automation through app integration with Google Business Profile.

1. Efficiently Manage and Analyze Review Data with kintone

Automatically add Google Business Profile reviews to kintone for centralized data management. By utilizing kintone's database functions, you can conduct multifaceted analysis of accumulated review data, aiding in the revision of marketing strategies and service improvement. By eliminating manual input, you can manage the latest review data at all times, promoting efficient data utilization.

2. Flexible Collaboration Utilizing Reviews in Notion

Automatically add Google Business Profile reviews to Notion to facilitate smooth information sharing within the team. By leveraging Notion's document features, it becomes easier to organize ideas and improvements based on review data, aiding in the consideration of response strategies. This eliminates the manual effort and allows for immediate access to the latest review information through intuitive operations.

3. Notify Reviews to Google Chat for Quick Response and Improved Customer Satisfaction

When a review is posted on your Google Business Profile, an automatic notification is sent to Google Chat. This allows the entire team to check reviews in real-time, helping to prevent any missed responses.

Summary

By utilizing the flowbot template introduced this time, you can automatically add reviews from Google Business Profile to Rakuraku Sales, which can be useful for daily marketing and customer service. By centralizing the latest review data, it becomes easier to reflect customer feedback in your strategies, allowing for flexible responses in sales and store operations. Furthermore, Rakuraku Sales' intuitive interface enables staff to easily grasp reviews, which is expected to improve operational efficiency. Please try this automation flow, which can be easily implemented without any coding, at least once. You can proceed with the template implementation from the banner below.

See you again!

The person who wrote this article
k.hieda
10 years as a web planner and director. When I worked for a web production company, my main focus was on proposing modifications and operation plans to clients and proceeding with production. I'm currently a parallel worker. We produce blogs in Yoom's content division, and receive external public relations projects for companies in our individual business. Since we are starting a private lodging, we aim to thoroughly improve the efficiency of routine work!
Tags
Google Business Profile
Rakuraku Hanbai
Integration
Automation
Automatic
App integration
No items found.
What is Yoom hyperautomation?
Conventional RPA can only automate simple repetitive tasks, and the setup process was very complicated.
With “hyperautomation,” which combines various technologies such as AI, API, RPA, and OCR, it is possible to automate many tasks that could not be realized until now more easily than before.
Don't Just Connect Apps—Automate Everything
Most tools simply connect one app to another, leaving the complex tasks to you. Yoom goes much further: From document creation and browser automation to OCR and generative AI, Yoom handles it all seamlessly in one platform.

Why settle for basic integrations? Streamline your entire workflow with Yoom’s powerful hyperautomation.
Learn more about Yoom
Helpful Materials
I understand Yoom! 3-piece set of materials
Download materials
Understand in 3 minutes! Yoom service introduction materials
Download materials
Find out by Before After! Yoom Case Study Collection
Download materials
See a list of useful materials