How to Automatically Retrieve Product Rankings from Your Own E-commerce Site Daily and Notify via LINE WORKS

Items to Prepare in Advance

Chrome Extension

•  This operation uses Chrome, so please prepare an account.
  • Help: How to set up "Operate Browser"
• Please add the "Yoom Browser Operation Setting Tool" to your Chrome extensions.

• Extension: Yoom Browser Operation Setting Tool

• After adding the Chrome extension, please enable the setting to allow execution in incognito mode from the extension management.

LINE WORKS

• Client ID
• Client Secret
• Scope
  • Please log in to the LINE WORKS Developer Console with an account that has administrator privileges.
  • Help: How to register my app for LINE WORKS (API2.0)
• Bot ID
  • ＞LINE WORKS Official: Create a Bot
  • ＞LINE WORKS Developers Management Screen
• Talk Room ID
  • Click the three-dot leader at the top right to obtain the channel ID. The menu will open, and clicking the channel ID will display the ID.

Step 1: Setting Up My App Integration

To register the browser/app information to be integrated with Yoom, please log in to Yoom's workspace.

Browser Operation Account

Select the "Browser Operation Account" tab on the My Apps screen and click + New Connection.

The screen below will be displayed.

• Service Name/Identifier
  • Enter any value.
• Account Name
  • Chrome login account
• Password
  • Chrome password

Enter the above and click the Add button to complete the addition of the operation account.

New App Connection

Select the "App" tab on the My Apps screen and click + New Connection.

A list of apps that can be connected to Yoom will be displayed. Enter the app to be integrated in the search box and proceed with the registration of My App.

LINE WORKS

Select LINE WORKS from the search results to transition to the screen where you can enter the values required for integration.

Enter the information obtained from the LINE WORKS Developer Console into each field and click the Add button.

Help: How to register my app for LINE WORKS (API2.0)

This completes the registration of your LINE WORKS app.

Step 2: Copy Yoom's Flow Bot Template to My Project

Click the banner below.

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

Step 3: Schedule Trigger "At 9 AM Every Day"

Click on the first step of the template. This item is pre-configured, so the light blue icon (proof of completion) is lit, but we will explain the settings.

(1/1) Specify Execution Time

This time, since it is set to start every day, check all days of the week from the 'Day of the Week' tab and set it to start at 9:00. If you need to change the repeat days or time, you can easily set it from this screen.
More complex timing settings can be made from the Cron settings tab.

• Learn more: How to set Cron settings

→ Click Save and proceed to the next step.

Step 4: Operate the Browser "Operate the Browser"

Click on the second step of the template. Here, too, the light blue icon is lit, but additional operations to read the ranking are required.

※ Browser operations are only available with some paid plans.
※ A 2-week trial is available for paid plans.

(1/1) Detailed Settings for Browser Operations

In the pre-configuration, only the step "Access the site" is added.

Click on this step to set which site to access.

In the edit field for the target URL, enter the site's URL. Next, set the action to retrieve the ranking content.

Click the + button below the Access the Site item. The operation selection screen is displayed in a white frame. From this, select "Specify Operation in Browser."

Enter the URL of the site to access on the displayed screen and click the "Start Operation" button. The specified site opens in a separate window.

When you open the site, a window labeled 'Set Action on Element' is displayed in the lower left. This is the operation mode state. From this page, find the best-selling ranking content and perform operations to retrieve information in order from the first place.

First, click on the product name of the first place product, and a dropdown labeled "Action to be executed" will be displayed. Normally, it transitions to the product page, so select the 'Click' action from this item.

The page switches to the product page of the first place. Click on the product title again and select "Retrieve Displayed Value" from the dropdown.

The action operation screen is displayed. Here is the important point.

• The item name of the retrieved value is labeled 'Displayed Value' by default, but please add '1st Place' to avoid duplication with the item names for 2nd to 5th places.
• If the item name is not unique, multiple values will correspond to one item name, so it is necessary to separate the item names.

After entering, click the add button at the bottom right.

Next, click on the product name on the same screen to open the dropdown and retrieve the URL of the product page.

Again, add '1st Place' to the item name and click the add button at the bottom right.

Again, select "Go Back to Previous Page" on the same screen. Go back to the previous page and then retrieve the "Displayed Value" and "Product Page URL" for 2nd place and beyond.

‍

When you perform the operations from clicking on the first place in the ranking to going back to the previous page, the series of flows is displayed on the Yoom operation page as shown above. Repeat this flow until you retrieve the value of the 5th place product page.

Incidentally, if the site's product display is set to 4 columns, there may be a situation where you need to select the slide right button before retrieving the 5th place. In that case, also select "Click" for the action.

Once the operations for 1st to 5th places are complete, proceed to the test.

Click the test button at the bottom right of the Yoom operation screen. When the test starts, the retrieval of values begins in order from 'Access the Site.' Once all specified values on the site are retrieved, the items and values are displayed in "Retrieved Values."

The test was successful, and the "Displayed Values" and "Product Page URLs" for 1st to 5th places were retrieved. These items will be used for editing the template for notification to LINE WORKS in the next step.

→ Click Save.

Step 5: Integrate with Apps "Send Message"

Click on the third step of the template. Edit the notification content for LINE WORKS.

(1/2) Select Linked Account and Action

This is pre-configured.

• Title of App Trigger
• App
• Account information linked with LINE WORKS
• Action

→ Click Next.

(2/2) API Connection Settings

• Talk Room ID
  • Click the three-dot leader at the top right of the LINE WORKS talk room. A menu opens, and clicking on the channel ID displays the ID. Enter the obtained ID in the edit field.

‍

• Message Content

• Create a template for the notification. Mentions to specific members are also possible.

• Click the edit field, and the items obtained in the previous operation will be displayed in a dropdown menu.

Enter '1st Place:' in the edit field, and select the displayed value (product name) and page URL to embed the quote code. Similarly, enter the item names and embed the quote codes for 2nd place and below.

Once the input is complete, click the test button at the bottom left. → Success

→ Click Save. This concludes the current process.

Step 6: Turn ON the App Trigger

When all steps are set, a completion screen is displayed.

After turning on the trigger, use the toggle at the top left of the template to activate the flow bot.

<span class="mark-yellow">No programming is required, and the flow bot setup was easily completed.</span> Here is the template used.

Make the Most of It! 3 Automation Picks Using RPA and LINE WORKS

By combining RPA with LINE WORKS, the possibilities for more convenient use expand. In particular, centralizing notifications in LINE WORKS improves efficiency.

1. Automatically Retrieve and Share Website Information Daily

This is a flow bot that retrieves website update information daily and automatically notifies via LINE WORKS. This system reduces the manual effort of collecting information and allows for efficient information sharing within the team. For example, by notifying about website updates, all members can grasp the information at the same time, enabling smooth collaboration.

‍

2. Automatically Transfer Registration Details from Google Forms to the Attendance Management System

When employees register via Google Forms, their information is automatically entered into the Jobcan attendance system using RPA, and notifications are sent to LINE WORKS. This automation helps prevent transcription errors and registration omissions, while also reducing the workload of management tasks. Additionally, using Google Forms allows multiple personnel to easily input and share data, which is expected to improve the overall efficiency of HR operations.

‍

3. Seamlessly Reflect Yoom Form Input Information in the Attendance System

When employee information is registered through the form, it is automatically registered in the Jobcan attendance system using RPA, and a notification is sent via LINE WORKS. This reduces the effort required for registration tasks and prevents transcription errors. Additionally, by using the notification feature in LINE WORKS, information sharing becomes smoother, contributing to more efficient communication. The template is customizable, allowing you to build an automation flow that suits your company.

‍

Summary

Manually obtaining product ranking information and sharing it with the team can unknowingly consume a lot of time. To streamline this process and make daily operations smoother, we recommend utilizing Yoom's Flowbot template. <span class="mark-yellow">This template is characterized by its ease of implementation through intuitive operation, even without programming skills.</span> Once implemented, the automation of obtaining and sharing ranking information is expected to improve the accuracy and speed of daily operations. Additionally, the time saved can be used to focus on strategic tasks such as planning promotional campaigns and reviewing sales strategies. Experience the benefits of enhanced daily operational efficiency. Start your free trial from the banner below.

See you again!