How to integrate Google Analytics with LINE WORKS to automatically send daily reports to LINE WORKS

In modern business, quick information sharing within a team is crucial. Especially, checking website performance data daily is essential for improving marketing and strategy. However, the task of manually obtaining and sharing reports every day is time-consuming, often causing other important tasks to be postponed. Additionally, errors in data transcription and oversight due to manual work are frequently cited challenges.

To address this, Yoom has developed a flow bot that "automatically retrieves the latest reports from Google Analytics daily and notifies LINE WORKS." This automation reduces these burdens and efficiently delivers accurate data to the team.

We will introduce a method to achieve this without programming and the specific benefits of implementation. Please read to the end.

Two Benefits of Automating the Retrieval of Daily Reports from Google Analytics and Notification to LINE WORKS

From the perspective of marketing teams and system administrators, let's see how this automation improves work efficiency.

Benefit 1: Smooth Information Sharing Among Teams

By automatically notifying LINE WORKS of Google Analytics reports daily, the entire team, including marketing, development, and sales, can always access the latest data. This allows each department to quickly strategize based on unified information, reducing communication gaps. Additionally, using LINE WORKS' task management feature promotes information centralization, improving the overall workflow efficiency.

Benefit 2: Preventing Manual Errors

Automating reports can prevent transcription errors due to manual work. Especially, system administrators and data analysts can efficiently proceed with tasks using accurate data. Sharing accurate data with the team on LINE WORKS enables the marketing team to act quickly based on reliable information.

[About Yoom]

Here, we explain how to create automation to "retrieve the latest reports from Google Analytics daily and notify LINE WORKS" using Yoom's template.

You can try it from the free plan. Register now and get started!

＞Register for free on Yoom

How to Create an Integration Flow to Retrieve the Latest Reports from Google Analytics Daily and Notify LINE WORKS

Things to Prepare in Advance

We have listed the items needed for the integration process.

Google Analytics

Login Information
- Prepare your email address and password to link with your Google account
Property ID

Log in to Google Analytics and select the account with the property.
Click the "Admin" button (gear icon) at the bottom left.
Select the relevant property from the property column.
Click "Property Settings" to display the "Property ID".

LINE WORKS

Log in to the LINE WORKS Developer Console with an administrator account.
＞Help: How to Register My App for LINE WORKS (API2.0)

Step 1: Setting Up My App Integration

Here, we will set up the app to be integrated into Yoom. Log in to Yoom's workspace and click on new connection from the My Apps section!

A list of apps that can be connected with Yoom will be displayed. Search for the app to be connected from the search window at the top and proceed with My App registration.

Google Analytics

When this screen is displayed, proceed with the integration by clicking the sign-in button for Google Account.

Enter the email address and password for integration on the next screen.

Once logged in, proceed to grant permissions.

This completes the integration with Google Analytics.

LINE WORKS

Select LINE WORKS from the search results.

Enter the information obtained from the LINE WORKS Developer Console in each field and click the add button.

＞Help: How to Register My App for LINE WORKS (API2.0)

This completes the registration of My App.

Step 2: Copy Yoom's Template to My Project

Click this banner. The template will be copied to "My Project" in the Yoom workspace.

The template will be copied to your project. Click the title within the red frame to navigate to the settings screen.

Step 3: Schedule Trigger "When the specified schedule is reached"

Click the first process of the template to check the pre-configured contents.

(1/1) Specify Execution Time

The following items are pre-configured.

Title of the schedule trigger
Schedule settings

This time, it is set to start every day at 10 AM. You can change it to any timing, and with Cron settings, you can set more precise times.

＞Learn more: How to set Cron settings

→ Click Save

Step 4: Integrate with the App 【GA4】 Obtain User Report

Click the second process of the template! Here, you will set up the information to be extracted from Google Analytics.

(1/2) Select Integrated Account and Action

The items displayed here are pre-configured.

Title of the app trigger
App
Account information integrated with Google Analytics
Trigger action

→ Click Next

(2/2) Select Integrated Account and Action

Property ID
- Log in to Google Analytics and select the account with the property.
- Click the "Admin" button (gear icon) at the bottom left.
- Select the relevant property from the property column.
- Click "Property Settings" to display the "Property ID".
Start of the period
- Set the beginning of the measurement period. The format is "YYYY-MM-DD".
- Click the edit field to open a dropdown. Embed the date reference code from the date tab. This time, we set it to extract data from yesterday to today to check daily reports.

End of the period
- This time, we set "Today" as the last day. As with the start of the period, specify the date from the dropdown and embed today's reference code.

→ Click Test → Success, yesterday's data was extracted as output.

→ Click Save

Step 5: Integrate with the App "Send Message"

Click the third template and set up the content to be automatically sent to LINE WORKS in this process.

(1/2) Select Integrated Account and Action

These items are pre-configured.

Title of the app trigger
App
Account information integrated with LINE WORKS
Trigger action

→ Click Next.

(2/2) API Connection Settings

Bot ID
- Click the edit field to open a dropdown. The candidate bots from the integrated account will be displayed. Selecting one will automatically quote the ID.

Talk Room ID
- Click the three-dot leader at the top right of the LINE WORKS talk room. A menu will open, and clicking the channel ID will display the ID. Obtain the ID and enter it in the edit field.

‍

Message Content
- Click the edit field to open a dropdown, and the output extracted in the previous process will be displayed.
- Select the content to be sent to LINE WORKS, and the embedding code will be automatically quoted.

→ Click Test. → Success

→ Click Save This concludes the setup for this flow.

Step 6: Turn the App Trigger 【ON】

Once all processes are configured, a complete screen will pop up.

Turn the trigger 【ON】 and start it.

<span class="mark-yellow">Automation was achieved in a short time without using programming.</span> Here is the template for this time.

Make the Most of It! 3 Automation Tips Using Google Analytics and LINE WORKS

LINE WORKS and Google Analytics offer many other templates as well.

1. Automatically Record Google Analytics Reports in a Spreadsheet

Automatically obtain the latest Google Analytics reports daily and record them in a Google Spreadsheet. This centralizes data management and ensures the entire team can work based on the latest information. It also helps reduce manual input errors and saves working time.

2. Automatically Notify Reports on Slack

Automatically obtain Google Analytics reports daily and notify them on Slack. This allows you to share information in real-time with specific members, enabling quick decision-making. Since manual work is no longer necessary, operations become more efficient.

3. Automatically Notify Project Progress on LINE WORKS

When the project progress is updated in Notion, an automatic notification is sent to LINE WORKS. This allows you to immediately grasp the progress status and facilitates smooth collaboration within the team. It eliminates the hassle of sending notifications manually, thereby improving work efficiency.

Summary

By integrating Google Analytics with LINE WORKS, daily report retrieval is automated. This reduces the effort of manually obtaining and sharing reports, potentially improving work efficiency. Additionally, since the latest data is reliably notified on LINE WORKS at a set time every day, delays and omissions in information sharing can be prevented. Furthermore, the elimination of manual errors allows for operations to proceed based on highly reliable data.

<span class="mark-yellow">With Yoom's Flowbot, even those who are not good at programming can start working on automation today.</span> Be sure to incorporate automation to help improve work efficiency.

＞Start integrating with Yoom for free

See you later!