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

"I check the product rankings every day, but it would be convenient if I could do it more efficiently." "When sharing information with the entire team, there's always a time lag..." Many people might be feeling these kinds of concerns.
By implementing a system that automatically retrieves product rankings from websites and notifies Microsoft Teams at a set time every day, you can solve these issues. This system allows for smoother information management, quick trend identification, and rapid decision-making within the team.
Additionally, by utilizing our Flowbot template, you can easily implement this system without programming knowledge. This article will introduce the benefits and usage of this Flowbot in detail, so please read to the end.

Recommended for

This Flowbot is perfect for the following people:

Those who want to check their own e-commerce site's product rankings daily and share accurate information in a timely manner
Those who want to use Microsoft Teams to ensure the entire team has the same information simultaneously for quick decision-making
Those who want to automate routine work and focus on tasks that require manpower
Those who want to enhance information sharing accuracy by combining RPA and Microsoft Teams

Benefits and Specific Use Cases of Automatically Retrieving Product Rankings from Your E-commerce Site Daily and Notifying Microsoft Teams

Focusing on the three roles of e-commerce business managers, e-commerce operation staff, and team leaders, we will specifically introduce the effects of this automation flow on each. We will clearly convey the benefits of automation from the perspective of each role, so please refer to it.

1. Achieving Sales Strategies Leading to Revenue Growth

This automation flow automatically retrieves product rankings from the e-commerce site at a set time every day, allowing you to grasp the necessary information effortlessly. This enables the rapid and accurate planning of sales strategies based on ranking information.
For e-commerce business managers, receiving ranking information at a set time every day creates an environment where trends can be timely identified. Regular reporting allows for the confirmation of necessary information at any time, leading to swift management decisions. For example, you can consider strategies directly linked to revenue growth, such as appropriately restocking top-ranking products and planning and executing promotional campaigns that leverage trending products. Additionally, by making accurate decisions based on changes in sales conditions, you can differentiate from competitors and enhance your market advantage.

2. Streamlining Daily Tasks and Enhancing Operational Work

By automating the task of retrieving product rankings, you can prevent time lags and work errors that tend to occur when done manually. This system ensures that information is reliably retrieved and shared at a set time every day, eliminating the hassle and anxiety of managing information.
For e-commerce operation staff, automating the ranking retrieval task frees them from routine work that previously consumed a lot of time. As a result, they can focus on tasks that require manpower and creativity, such as checking inventory, managing orders, and preparing new product listings. Automation not only reduces time but also supports smoother overall operations, ultimately contributing to the progress and quality improvement of work.

3. Enabling Timely Information Sharing Across the Entire Team

By utilizing the notification function linked with Microsoft Teams, product ranking information is automatically shared at a set time every day. This allows the entire team to grasp the same information simultaneously, preventing discrepancies in understanding and enabling quick responses.
For team leaders and managers, automatic sharing of product ranking information creates an environment where all members can receive information at the same time. For example, analyzing the causes of lower-ranking products within the team and discussing improvement measures can create opportunities to review product strategies.

From here, we will explain how to set up "automatically retrieving product rankings from your own category daily and notifying Microsoft Teams" using Yoom's Flowbot template. In this setup method, we will introduce how to retrieve product names and URLs from the top 1 to 5 ranked products from a specified site and notify Microsoft Teams daily.

[What is Yoom]

Steps to Set Up Automatic Retrieval of Product Rankings from Your E-commerce Site Daily and Notify Microsoft Teams

By utilizing Yoom's schedule trigger, you can automatically operate the browser at a set time every day (e.g., 9 AM) to retrieve product rankings from your own category. This operation uses RPA (Robotic Process Automation) to automate manual browser operations.
The retrieved ranking information is notified to a specified channel via Microsoft Teams' API, allowing the entire team to timely confirm the necessary information. Generally, implementing such a system requires programming knowledge, but using the no-code tool Yoom makes it possible without programming knowledge.

Integration Process

Register My App with Yoom (for Microsoft Teams 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

This operation uses Chrome, so please prepare an account.
- Help: How to Set Up "Operate Browser"
Please add the "Yoom Browser Operation Setting Tool" in Chrome extensions.

Extension: Yoom Browser Operation Setting Tool

After adding the Chrome extension, please go to extension management and turn on the setting to allow execution in incognito mode.

Microsoft Teams

Microsoft365 login information (email address, phone number, Skype ID, password)
Chat ID
- Right-click on the chat where you want to send notifications and select "Copy Link". You can obtain it from the copied URL.

The part written in the format "19: ～ .space" within the link is the chat ID.

Step 1: Setting Up My App Integration

To register the browser/app information to be integrated with Yoom, please log in to the Yoom 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 window and proceed with My App registration.

Microsoft Teams

Select Microsoft Teams from the search results. When the screen below is displayed, enter your Microsoft365 login information.

This completes the My App registration for Microsoft Teams. ※Microsoft365 (formerly Office365) has a home plan and a general business plan (Microsoft365 Business), and if you are not subscribed to the general business plan, authentication may not be possible.

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 (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 of the week from the 'Specify Day' tab and set it to start at 9:00. Additionally, if you need to change the repeat days or times, you can easily set it from this screen.
More complex timing settings can be configured from the Cron settings tab.

Learn more: How to Set Cron Settings

→Click Save to 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 rankings are required.

※ Browser operations are available only on some paid plans.
※ A two-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 "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 selection screen will appear in a white frame.
From this, select "Specify Operation in Browser."

Enter the URL of the site to access in 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.
From this page, find the best-selling ranking content and perform operations to retrieve information in order from first place.
First, click on the product name in first place, and a dropdown labeled "Action to Execute" will appear.
Normally, it will transition to the product page, so select the 'Click' action from this item.

You will transition to the first-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, 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" from 2nd place onwards.

‍

When you click from the first place in the ranking and return to the previous page, the series of operations will be displayed as shown above on the Yoom operation page.
Repeat this process to retrieve the values of the product pages from 2nd to 5th place.

Incidentally, if the site is set to display products in four columns, there may be a point where you need to select a button to slide to the right before retrieving the 5th place. In that case, also select "Click" for the action.
Once the operations from 1st to 5th place 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 will begin in order from 'Access the Site'. Once all specified values on the site have been 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 place were retrieved. These items will be used in the next step to edit the template for notification to Microsoft Teams.

→Click Save.

Step 5: Integrate with Apps "Send Message to Channel"

Click on the third step of the template. Edit the notification content settings for Microsoft Teams.

(1/2) Select Integration Account and Action

This is pre-configured.

App Trigger Title
App
Account Information for Integration with Microsoft Teams
Action

→ Click Next.

(2/2) API Connection Settings

Team ID
- Click the edit field to open a dropdown, and the space name of the integrated Microsoft Teams will be displayed. Select the space to send the message to obtain the ID.

Channel ID
- Click the edit field to open a dropdown. Select from the channel candidates to automatically quote the ID.

‍

Message
- Create a template for notification. Mentions to specific members are also possible.

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

Enter '1st:' 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.
In Microsoft Teams, HTML tags are supported to display notification messages in a rich and structured format. Therefore, you need to insert the tag for line breaks.
To set mentions, enter the value in the box to link mention values below the message edit area. Insert values for attachment information in the same way.

After entering, click Test. → 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 start the flow bot.

No programming is required, and the flow bot setup was completed easily. Here is the template used.

‍

Make the Most of It! 3 Automation Examples Using RPA and Microsoft Teams

By combining RPA with Microsoft Teams, the potential for streamlining operations expands. Centralizing notifications in Microsoft Teams, in particular, makes management easier.

1. Automatically Retrieve Website Information Daily and Notify the Team

Automatically retrieve website updates daily and notify Microsoft Teams. This eliminates manual work and allows the entire team to share the same information in a timely manner. It enhances the efficiency of information gathering and promotes active communication.

2. Automatically Process Employee Information Registered with Google Forms

Register employee information from Google Forms into Jobcan Attendance using RPA and notify via Microsoft Teams. This prevents input errors and reduces working time. Tasks can be divided among multiple personnel, allowing HR operations to proceed smoothly.

3. Automatic Integration of Employee Information via Form Registration

Employee information registered in the form is entered into Jobcan Attendance using RPA and notified. This prevents transcription errors and registration omissions, reducing the workload of the person in charge. Customization of items can also be freely set.

Summary

The flow bot introduced this time is a system that automatically retrieves the product rankings from a website daily and notifies Microsoft Teams. By implementing this system, you can eliminate time lags and uncertainties in information sharing caused by manual work, delivering the necessary information accurately to the entire team. Yoom's flow bot template is characterized by its ease of setup, even without programming skills. Additionally, with a wide range of templates tailored to business workflows, anyone can easily find the optimal automation flow for their tasks. Its no-code, intuitive operation allows you to start implementation immediately without specialized knowledge. Feel free to try it out and experience firsthand how it can improve your business operations. Consider this new method to make your daily tasks run more smoothly!

See you again!