How to Automatically Retrieve Product Rankings from Your Company's E-commerce Site Daily and Notify via Google Chat
How to Utilize RPA
・
2025/01/21
How to Automatically Retrieve Product Rankings from Your Company's E-commerce Site Daily and Notify via Google Chat
k.hieda
<span class="mark-yellow">Have you ever felt the need to more efficiently grasp the ranking information of your company's e-commerce site in your daily work to make better use of your time?</span>
In the e-commerce business, understanding product rankings is an essential task, but manually collecting this information, while seemingly simple, ends up consuming a lot of time when done daily. To solve this issue, we propose a system to automate the acquisition of rankings. By automatically retrieving ranking information from your company's e-commerce site via a browser and notifying it to Google Chat, information sharing within the team can be done smoothly. Traditionally, such browser operations and app integrations required programming skills, making the implementation hurdle high. However, with our no-code compatible flow bot template, anyone can easily set it up without specialized knowledge. In this article, we will introduce the mechanism and specific benefits, so please read to the end.
Recommended for
This flow bot is perfect for the following people:
Those who want to simplify the daily task of acquiring product rankings and share information with the entire team using Google Chat
Those who want to timely grasp product trends and make quick decisions using RPA (Robotic Process Automation)
Those who find manual ranking acquisition and sharing time-consuming and want to improve efficiency
Those who want the entire team to act based on consistent ranking information and achieve smooth communication
Those who want to reduce cumbersome tasks and spend more time managing their company's e-commerce site
Three Benefits and Specific Use Cases of Automatically Acquiring Product Rankings from Your Company's E-commerce Site Daily and Notifying Google Chat
We will introduce the benefits of automation from the perspectives of e-commerce business managers, operational staff, and team leaders.
1. Achieving Rapid Sales Strategies Leading to Increased Revenue
<span class="mark-yellow"> By understanding the latest ranking information every morning, you can accurately capture trends and smoothly formulate sales strategies.</span> For example, an e-commerce business manager can immediately place additional orders for products that have entered the top rankings to prevent opportunity loss due to stockouts. Additionally, by conducting limited-time campaigns featuring these products, further sales increases can be aimed for. On the other hand, for lower-ranked products, the reasons can be analyzed and used as material for reviewing promotions or considering product improvements. In the e-commerce market, such quick decision-making directly leads to increased sales.
2. Free from Routine Tasks, Focus on Other Important Tasks
Manually acquiring product rankings is an essential daily task for e-commerce operational staff. However, even simple tasks can consume a lot of time when done daily. <span class="mark-yellow">By introducing this automation flow, the process from acquiring to sharing rankings can be automated, reducing daily work time.</span> For example, operational staff can use the time saved through automation to analyze past sales data and propose products that lead to increased sales. They can also focus on creative tasks such as preparing special pages for new products or considering promotional content. By entrusting daily routine work like ranking acquisition and sharing to the flow bot, operational staff can focus on the tasks they should be working on.
3. Timely Information Sharing Across the Entire Team
By utilizing a flow bot integrated with Google Chat, it is possible to automatically acquire the product names and URLs of the top 5 ranked products every morning at 9 AM and notify Google Chat. The notification content can be customized, such as increasing it to the top 10, adjusting the target categories, or changing the notification time. <span class="mark-yellow">This allows the entire team to share the same information at a set time and act quickly.</span> For example, a team leader can use the ranking information shared every morning to instruct members on promotional plans for priority products or check inventory status and coordinate with the purchasing department. This prevents "information delays" or "recognition gaps" within the team and builds a system that does not miss sales opportunities. Additionally, by discussing based on the same data, smooth decision-making is possible, leading to improved team performance.
From here, we will explain how to set up "automatically acquiring product rankings from your company's product category daily and notifying Google Chat" using <span class="mark-yellow">Yoom's flow bot template</span>. This time, we will set it up to acquire the product names and URLs of the top 1 to 5 products from a specified site and notify Google Chat daily.
[What is Yoom]
Steps to Set Up Automatic Daily Acquisition of Product Rankings from Your Company's E-commerce Site and Notification to Google Chat
By utilizing Yoom's schedule trigger, you can automatically operate the browser at a set time every day (e.g., 9 AM) to acquire product rankings from your company's product category. This operation uses RPA (Robotic Process Automation) to automate browser operations that humans would manually perform. The acquired ranking information is notified to a specified channel via Google Chat's API, allowing the entire team to timely confirm the necessary information. Generally, implementing such a system requires programming knowledge, but with the no-code tool Yoom, it is possible without programming knowledge.
Integration Process
Register My Apps with Yoom (Google Chat and browser operation account)
Copy the template
Schedule trigger, browser operation, and app integration
Turn on the trigger button and start integration
Items to Prepare in Advance
Chrome Extensions
This operation uses Chrome. Please prepare an account.
After adding the Chrome extension, go to manage extensions and enable it to allow running in incognito mode.
Google Chat
Since the integration of Google Chat and Yoom can only be performed by someone with Google Cloud Platform admin rights, please request the admin to integrate Yoom with Google Chat.
This completes the registration of My App for Google Chat.
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 "Every day at 9 AM"
Click on the first step of the template. This item is pre-configured, so the light blue icon (indicating 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 from the 'Day of the Week' tab and set it to start at 9:00. You can change the repeating days and times from this screen. More complex timing settings can be configured from the Cron settings tab.
Click on the second step of the template. Here too, the light blue icon is lit, but additional operations to read the rankings are required.
※ Browser operations are available only on some paid plans. ※ A 2-week trial of the paid plan is available.
(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 under the "Access the site" item. A selection screen will appear in a white frame. From this, select "Specify operation in the browser."
Enter the URL of the site to access on the displayed screen and click the "Start Operation" button. The specified site will open in a separate window.
If the window "Set Action to Element" is displayed at the bottom left of the opened site, it is in operation mode. 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 to display a pull-down labeled "Operate Action." Usually, 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 pull-down.
The action operation screen is displayed. Here is the important point.
In the edit field for "Item Name of Retrieved Value," only "Displayed Value" is written by default, but please add "1st" to avoid duplication with item names from 2nd to 5th.
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.
On the same screen again, click the product name to open the pull-down. This time, retrieve the URL of the product page.
Also add "1st" to the item name here, and click the Add button at the bottom right.
On the same screen, select "Go back to the previous page." Return to the previous page and then retrieve the "Displayed Value" and "Product Page URL" for 2nd place and beyond.
When you click from the first place in the ranking and return to the previous page, the series of operations will be displayed on the Yoom operation page as shown above. Repeat this flow until you retrieve the values for the 5th place product page.
Incidentally, if the site is set to display products in 4 columns, there may be a situation where you need to select a button to slide to the right before retrieving the 5th place. In that case, select "Click" for the action.
Once the operations from 1st to 5th are completed, 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 the top "Access the site." Once all specified values on the site are retrieved, the "Retrieved Values" will display the items and values.
The test was successful, so the "Displayed Values" and "Product Page URLs" from 1st to 5th were retrieved. These items will be used for editing the template for notification to Google Chat 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 settings for Google Chat.
(1/2) Select Linked Account and Action
This is pre-configured.
Title of the App Trigger
App
Account information linked with Google Chat
Action
→ Click Next.
(2/2) API Connection Settings
Resource Name of the Space
Click the edit field to open a pull-down, and the space names of linked Google Chat will be displayed. When you select a space name, the ID will be quoted.
Message Content
Create a template for the notification. It is also possible to mention specific members.
Click the edit field to display the items retrieved in the previous operation in a pull-down.
Enter 1st: in the edit field, and as you select the displayed value (product name) and the page URL, the reference code will be embedded. Similarly, enter the item names and embed the reference 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 steps.
Step 6: Turn ON the App Trigger
Once all steps are configured, a completion screen will be displayed.
After turning on the trigger, use the toggle at the top left of the template to start the flow bot.
The flow bot setup was easily completed without programming. The template used is here.
Make the Most of It! 3 Automation Examples Using RPA and Google Chat
By combining RPA with Google Chat, a wide range of possibilities opens up. In particular, centralizing notifications in Google Chat can be expected to improve work efficiency.
1. Automatically Share Website Update Information
This flow automatically retrieves website information daily and notifies the team via Google Chat. It eliminates the hassle of manually collecting information and streamlines information sharing within the team.
2. Automate Registration from Google Forms to Jobcan Attendance
Automatically register employee information submitted via Google Forms into Jobcan Attendance using RPA. After that, share it on Google Chat. This prevents manual input errors and ensures accurate information management.
3. Automate Registration from Yoom Form and Google Chat Notification
When employee information is entered in the Yoom form, RPA automatically registers it in Jobcan Attendance and sends a notification via Google Chat. This reduces workload and enables accurate information sharing.
Summary
For those who find challenges in obtaining daily product rankings and sharing them within the team, Yoom's Flowbot might be a helpful solution. By implementing a system that retrieves ranking information from your own e-commerce site every morning and automatically notifies Google Chat, you can reduce the burden of manual tasks, enabling quick decision-making and smooth information sharing within the team. Additionally, Yoom's Flowbot template is designed to not require any particular programming skills, and its operation is intuitive and easy to understand. You can build an automation flow tailored to your company simply by following the template, eliminating the hassle of customizing from scratch. Even those trying automation for the first time can use it with confidence. Be sure to experience this convenience firsthand through a free trial.
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!
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.
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.
.avif)
.avif)
.avif)
.avif)
