How to integrate LINE Official Account with Microsoft Excel to retrieve the latest distribution numbers from the LINE Official Account daily and add them to Microsoft Excel
How to Integrate Applications
・
2025/01/08
How to integrate LINE Official Account with Microsoft Excel to retrieve the latest distribution numbers from the LINE Official Account daily and add them to Microsoft Excel
k.ueno
For companies utilizing LINE Official Accounts to communicate with customers, managing distribution data and analyzing information are likely to be significant challenges. If you are manually collecting daily data and entering it into Microsoft Excel, it requires time and effort. However, by integrating LINE Official Accounts with Microsoft Excel using Yoom, you can reduce the burden on the person responsible for data collection. Furthermore, by setting the acquisition time, you can obtain the latest distribution numbers at a specified date and time, preventing oversights and efficiently collecting necessary data. This article explains how to set up an automated flow to obtain the latest distribution numbers from LINE Official Accounts daily and add them to Microsoft Excel, as well as the benefits of implementing it. By incorporating this into your operations, you can improve work efficiency and enhance the accuracy of data analysis, so please take a look.
Recommended for
Those who find collecting and managing distribution data cumbersome
Marketing personnel who want to improve the accuracy of analysis
Managers who want to reduce manual data entry tasks
Executives who want to make strategic decisions based on data
Those using LINE Official Accounts and Microsoft Excel and want to streamline management tasks by integrating them
Benefits and Examples of Integrating LINE Official Accounts with Microsoft Excel
1. Centralized Data Management
By automatically aggregating distribution data from LINE Official Accounts into Microsoft Excel, you can centrally manage the necessary information on Microsoft Excel. For example, by registering complex collected data in a predetermined format, you can devise effective distribution strategies for specific time slots or days of the week. Additionally, aggregating data into Microsoft Excel makes it easier to share information with other team members. Each team member can formulate highly accurate strategies, aiming to improve the overall performance of the company.
2. Reduction of Manual Work
By implementing this flow, you can automate the task of manually entering daily distribution numbers from LINE Official Accounts into Microsoft Excel. For example, the task of copying data from the LINE Official Account management screen and pasting it into Microsoft Excel, which was previously done by a person every morning, will no longer be necessary. The time spent on data entry can be allocated to other important tasks, which is expected to improve productivity within the department.
3. Prevention of Oversights
By automatically registering daily distribution numbers from LINE Official Accounts into Microsoft Excel, you can suppress oversights during data collection. For example, in the conventional process, if work was busy, there was a possibility of missing data that should have been collected, leading to incorrect results during information analysis. By incorporating this flow, you can obtain the latest distribution numbers at a specified time and automatically add the information to Microsoft Excel, allowing you to perform analysis work based on accurate data.
Now, let's create a flow bot using the template "Obtain the latest distribution numbers from LINE Official Accounts daily and add them to Microsoft Excel".
[About Yoom]
How to Obtain the Latest Distribution Numbers from LINE Official Accounts Daily and Add Them to Microsoft Excel
By utilizing Yoom's schedule trigger, it is possible to receive the latest distribution numbers obtained from LINE Official Accounts using the LINE Official Account API and add the obtained distribution numbers to Microsoft Excel records using the API provided by Microsoft Excel. Generally, programming knowledge is required to achieve this, but with the no-code tool Yoom, it can be easily achieved without programming knowledge.
The work until the completion of the flow will proceed as follows:
Integration of LINE Official Accounts and Microsoft Excel My Apps
Copy the template
Set triggers for LINE Official Accounts and configure Microsoft Excel
Turn on the trigger
If you are not using Yoom, please register for free from here. If you are already using Yoom, please log in.
・Connect LINE Official Account and Microsoft Excel to My Apps
(1) First, connect your LINE Official Account to My Apps. After logging into your Yoom account, click on "My Apps" in the left column and search for the LINE Official Account from "New Connection".
(2) The app icon for the LINE Official Account will appear, so click on it.
(3) Enter the "Account Name" and "Access Token" of the LINE Official Account you want to connect, and click [Add]. For more information on how to add a LINE Official Account to My Apps, please refer to this article.
(4) Next, connect the Microsoft Excel app. Select Microsoft Excel in the same way as registering the LINE Official Account to My Apps.
(5) After clicking the Microsoft Excel app icon, you will be taken to the sign-in screen, but no further action is required, and the connection will be completed instantly. ・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 fail.
Once authentication is successful, you will be redirected to the My Apps screen of your Yoom account. Now, both apps are connected to your Yoom account.
・Copy the Template
After confirming that the new connection of the target app to your Yoom account is complete, click on the icon for "Try this template" in the template below.
The template will be copied, so click the "OK" button.
Please move to the "My Projects" screen of your Yoom account and check the template content.
There are three setup flows.
This time, we have prepared a Microsoft Excel sheet as shown below in advance. We will create a flow bot with the assumption that we will eventually add [Broadcast Message] to item 1 and [Targeting Message] to item 2.
・Check Trigger Content
(1) First, check the content of the schedule trigger.
Click "【Copy】Retrieve the latest distribution count from the official LINE account daily and add it to Microsoft Excel" from My Projects on the left side of the Yoom account screen.
After clicking, the template content will be displayed as shown in the screen below.
(2) Click on the trigger "When the specified schedule is reached".
(3) In this example, we have set it to operate at 9:00 every weekday. You can customize the settings by checking or unchecking boxes, changing the time, etc., so please set it according to your operation. For details on how to set up a schedule trigger, please check this page.
(4) After confirming or optionally changing the settings, click [Save].
・Setting up the Official LINE Account
(1) Next, click on the second action "Retrieve Distribution Count".
(2) Enter the account information to be linked and click [Next].
(3) In the item for setting date and time information such as "Date", you can quote and set information from [Date] by clicking the input bar as shown in the screen below. If you want to set 'Today', click the arrow for 'Today' under [Date] → select the desired one from the expanded information. In this flow, it needs to be written in the format "20220131", so we have selected '%Y%m%d'.
(4) After entering the information, click [Test], and if there are no issues, click [Save]. In this step, you can obtain the following information as output. The output information can be quoted and utilized in subsequent steps, as noted in the annotation "This value can be used in other operations."
・Setting up Microsoft Excel
(1) Finally, click on the third action "Add Record".
(2) After entering the information for the Microsoft Excel account to be linked, scroll down and fill in the "Database Integration" section. You can quote information from the linked account as shown in the image below. (As an example, we are quoting the drive ID information from the file storage location.)
(3) Information such as "Item ID" can also be quoted. After entering, click [Next].
(4) On the next screen, set to add a new record to the specified table in Microsoft Excel. Enter the items in the "Values of the record to be added" section. As an example, the image below quotes the outputs "Broadcast Message" and "Targeting Message" obtained in the previous step.
(5) After entering the necessary information, click [Test], and if there are no issues, click [Save]. This completes the setup.
・Turn ON the Trigger
By clicking the red-framed part "Turn ON the Trigger" on the screen below, the flow bot will start automatically.
Here is the template used this time
Other Automation Examples Using LINE Official Account and Microsoft Excel
There are other examples of automation using LINE Official Account and Microsoft Excel on Yoom, so here are a few introductions.
Add Users to Microsoft Excel When They Add Friends on LINE Official Account
When a new user adds a friend on the LINE Official Account, the information is added to Microsoft Excel. With automatic synchronization, you can prevent human errors such as registration omissions and transcription mistakes, achieving centralized management of user information.
Add Users to Airtable When They Add Your LINE Official Account as a Friend
This is a flow to add information to Airtable when a new user adds your LINE Official Account as a friend. It helps prevent human errors such as registration omissions and transcription mistakes. Additionally, it contributes to reducing the burden on staff and speeding up follow-ups.
Add users to Notion when they add your LINE Official Account as a friend
This flow is recommended for those who use LINE Official Accounts for customer acquisition and utilize Notion for business operations. By automating daily tasks, the time spent on transcription is reduced, leading to a decrease in the burden on staff and quicker follow-ups.
Summary
By integrating the LINE Official Account with Microsoft Excel, as introduced this time, you can manage and analyze data related to the distribution numbers of the LINE Official Account more efficiently. Additionally, by reducing manual work, errors during operations can be minimized, allowing for accurate data collection and management. By providing highly accurate analysis results based on precise data, more strategic decision-making may become possible.
Please take advantage of Yoom to experience automation through app integration.
The person who wrote this article
k.ueno
Until now, as customer support, we have made efforts to resolve users' questions and concerns.
I was moved to learn that by using Yoom, tasks that are becoming increasingly complicated on a daily basis will progress quickly!
From now on, we will continue to distribute content with easy-to-understand content so that people who aim to improve work efficiency can use the service smoothly.
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)
