How to Automatically Retrieve Product Rankings from Your Company's E-commerce Site Daily and Notify via Slack
How to Utilize RPA
・
2025/01/23
How to Automatically Retrieve Product Rankings from Your Company's E-commerce Site Daily and Notify via Slack
k.hieda
Are you spending too much time manually obtaining and sharing product rankings every day? In the e-commerce industry, it's crucial to quickly grasp market trends and swiftly establish appropriate sales strategies. However, manually collecting and sharing ranking information can be time-consuming and labor-intensive, leading to communication delays. The solution to these challenges is a system that automatically retrieves information from websites and notifies Slack. By leveraging this automation, you can effortlessly collect and share ranking information, reducing work time and enabling real-time information sharing across the team. Traditionally, implementing such a system required programming skills, posing a hurdle for adoption. However, with our Flowbot template, you can easily set it up without specialized knowledge. This article will introduce the benefits and specific use cases of the Flowbot template in detail. Please read to the end.
Recommended for:
This Flowbot is perfect for those who:
- Feel burdened by manually obtaining product rankings
- Want to streamline daily routine tasks using RPA
- Wish to share information timely with the entire team using Slack
- Want to quickly establish sales strategies based on ranking information
- Want to reduce the hassle of information sharing and secure time for tasks that require manual work
Benefits and specific use cases of automatically obtaining daily product rankings from your e-commerce site and notifying Slack:
From the perspectives of e-commerce business managers, operational staff, and team leaders, we explored new ways of working and the potential of automation.
1. Achieve information sharing that leads to sales strategies:
This Flowbot automatically operates at a set time every day, collecting product ranking information from e-commerce sites and notifying Slack. This eliminates the hassle of obtaining rankings and creates a system where the entire team can share the latest information simultaneously. By utilizing this system, you can timely grasp daily ranking changes, quickly catch trends, and create an environment where you don't miss sales opportunities. For example, you can quickly execute strategies to increase sales by restocking top-ranked products or swiftly launching promotions for specific products. E-commerce business managers can make immediate decisions based on this information and develop flexible sales plans that keep up with competitors.
2. Reduce daily tasks and focus on work that requires human intervention:
Manually obtaining and sharing product rankings may seem simple, but it accumulates significant time daily. This automation flow automatically obtains rankings and notifies Slack, reducing such manual tasks and securing time for other necessary work. By introducing this system, e-commerce operational staff can be freed from simple tasks, allowing them to engage in more creative work. Additionally, daily routine tasks like obtaining rankings and sharing information tend to be concentrated on specific individuals, but automation can prevent such personalization, creating an environment where the entire team can easily share tasks.
3. Efficiently share necessary information with the entire team:
By utilizing Slack, you can automatically notify product rankings daily. Moreover, with Slack, you can create threads based on the notified information and start discussions about arising tasks on the spot, enabling efficient communication. By receiving the same information at a set time every day, the entire team can respond timely with a common understanding. For example, you can discuss the priority of sales strategies on the spot or smoothly share improvement measures for lower-ranked products. By utilizing this system, team leaders can prevent delays in information sharing and discrepancies in understanding, achieving an operational system that doesn't miss sales opportunities. Additionally, since interactions are consolidated on Slack, you can easily review the discussion history, which is helpful for considering the next measures.
From here, we will explain how to set up "automatically obtaining daily product rankings from your e-commerce site and notifying Slack" using the Yoom Flowbot template. This time, we will set it to obtain the product names and URLs of the top 1 to 5 products from a specified site and notify Slack daily.
[About Yoom]
Steps to set up automatic daily product ranking retrieval and Slack notification:
Using Yoom's schedule trigger, automatically operate the browser at a set time every day (e.g., 9 AM) to obtain product rankings on the e-commerce site. This operation utilizes RPA (Robotic Process Automation) to automate browser operations that humans perform manually. The obtained ranking information is notified to the designated channel via Slack'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's possible without programming knowledge.
Integration process:
- Register your app with Yoom (for Slack and browser operation accounts)
- 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
Since Chrome will be used, please prepare an account.
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 (proof of completion) is lit, but let's explain the settings.
(1/1) Specify Execution Time
Since this is a setting to start every day, check all days in the 'Specify Day' tab and set it to start at 9 AM. If you need to change the repeat days or times, you can easily set it from this screen. More complex timing settings can be made 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 ranking are required.
※ Browser operations are available only in some paid plans. ※ A 2-week trial is available for paid plans.
(1/1) Detailed Settings for Browser Operations
In the pre-settings, only the step "Access the Site" is added.
Click "Access the Site" 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 screen for selecting operations will be 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 will open in a separate window.
When you open the site, a window labeled 'Set Action to Element' will appear at the bottom left. This indicates the operation mode.
On this page, find the best-selling ranking content and retrieve information in order from 1st place.
First, click on the product name in 1st place to display a dropdown menu labeled with the action to be performed.
Usually, it transitions to the product page, so select the 'Click' action from this item.
Navigate to the 1st place product page.
Click on the product title again and select "Retrieve Displayed Value" from the dropdown menu.
The action operation screen will be displayed. Here is the important point.
The item name of the retrieved value is labeled 'Displayed Value' by default, but please add '1st' 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 menu and retrieve the product page URL.
Again, add '1st' to the item name and click the add button at the bottom right.
Again, on the same screen, select 'Go Back to 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 1st place and go back to the previous page, the series of operations will be displayed on the Yoom operation page as shown above.
Repeat this process to retrieve the values of the product pages from 2nd to 5th place.
By the way, if the product display is set to 4 columns, you need to select the slide right button before retrieving the 5th place. There is 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.
After completing the operations from 1st to 5th place, perform a test.
Click the test button at the bottom right of the Yoom operation screen.
When the test starts, the retrieval of values will begin in order from 'Access the Site'. Once all specified values on the site are retrieved, the items and values will be displayed in "Retrieved Values".
The test was successful, so the "Displayed Value" and "Product Page URL" from 1st to 5th place were retrieved. These items will be used for editing the template message to notify Microsoft Teams in the next step.
→ Click Save.
Step 5 Integrate with Apps "Send a Message"
Click on the third step of the template. Edit the notification content for Slack.
(1/2) Select Integration Account and Action
This is pre-configured.
Title of the App Trigger
App
Account information for integrating with Slack
Action
→ Click Next.
(2/2) API Connection Settings
Channel ID
Click the edit field to display a list of channel candidates from the integrated Slack account. When you select the relevant channel, the ID will be automatically referenced.
Message
Create a template message for notification. You can also mention specific members.
Click the edit field to display the items retrieved in the previous operation in the dropdown menu.
Enter '1st: ' in the edit field and select the displayed value (product name) and page URL to embed the reference code. 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 current process.
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 activate the flow bot.
<span class="mark-yellow">The flow bot setup was easily completed without programming. </span>Here is the template used.
Make the Most of It! 3 Automation Picks Using RPA and Slack
Combining RPA with Slack expands the possibilities for improving work efficiency. In particular, centralizing notifications in Slack enhances efficiency.
1. Automatically Retrieve Daily Web Information and Share with the Team
By automatically retrieving website information daily and notifying it on Slack, it can be easily and reliably shared with the entire team. This prevents the personalization of information gathering tasks that were done manually and significantly improves the efficiency of information sharing.
2. Automatically Update Jobcan Attendance from Google Forms
When employee information is registered via Google Forms, it is automatically registered in Jobcan Attendance using RPA, and the team is notified via Slack. This reduces manual work, improves data accuracy, and increases work speed.
3. Automate Jobcan Attendance and Slack Notifications from Form
Automatically reflect form inputs in Jobcan Attendance using RPA and send notifications to Slack. This prevents errors from manual operations and reduces workload. Additionally, it offers flexibility to freely customize registration details and notification items.
Summary
For those who find "manually obtaining product rankings cumbersome" or "delays in response due to sharing time lags" to be a concern, Yoom's Flowbot template can be a great help. By implementing this template, ranking retrieval and notifications are automated, reducing daily routine work and enabling timely information sharing across the team. This is expected to create an environment where you can focus on quick decision-making and sales strategy planning. Additionally, Yoom's Flowbot template can be set up without any coding, making it easy to implement even without programming knowledge. It can be configured with intuitive operations, allowing you to start using it immediately without specialized skills. Experience its ease of use with a free trial! Try the free trial 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!
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)
