How to Integrate Google Analytics with Telegram to Automatically Notify Daily Reports

When you receive a lot of emails every day, it can be quite a hassle to save files to Dropbox each time.
Moreover, many people might have experienced the struggle of missing a file save or saving a file in the wrong folder, making it difficult to find later.

In this article, we will introduce a method to automatically save files received in Gmail to Dropbox!

By using no-code tools, you can easily set up automation between Gmail and Dropbox.
You can start using it right away, so be sure to give it a try!

Recommended for

Those who want to automatically upload files attached to Gmail to Dropbox
Those who want to integrate Gmail and Dropbox to facilitate smooth file sharing within the team
Those who want to prevent the loss of attachments and ensure proper document storage

For those who want to try it immediately

In this article, we will introduce the integration method using the no-code tool "Yoom".

No complicated settings or operations are required, and even non-engineers can easily achieve it.

You can start right away using the template below, so please give it a try!

Many companies use Google Analytics to collect and analyze data daily, but manually downloading reports and sharing them with the entire team takes a lot of time and effort. The manual work can also make smooth decision-making difficult.

With Yoom's Flowbot, you can automatically obtain the latest Google Analytics data daily and notify the team via Telegram. By reducing manual work, the entire team can stay updated with the latest data, facilitating smooth information sharing and improving work efficiency. No programming knowledge is required, and we will introduce an easy way to implement it, so please read to the end.

Two Benefits of Automating the Retrieval of the Latest Reports from Google Analytics Daily and Notifying via Telegram

From the perspective of data analysts and IT operations personnel, we considered the benefits of integrating Google Analytics with Telegram.

Benefit 1: Enhanced Security for Data Sharing

Google Analytics allows for detailed data analysis, and Telegram offers end-to-end encryption. Through integration, important data can be shared securely. For data analysts handling highly confidential reports, being able to share data with peace of mind while minimizing the risk of information leaks is attractive. For example, even when the marketing team exchanges confidential competitive data, it can be done safely.

Benefit 2: Flexible Operation and Customizability

Google Analytics allows for the creation of custom reports and integration with other tools. By using Telegram's bot, the latest web performance data can be automatically notified at a set time every day, greatly reducing the need for manual data checking and sharing tasks. For IT operations personnel, the ability to streamline daily operational tasks and integrate different tools for centralized data management is a significant advantage. For instance, metrics such as the number of users, sessions, and conversion rates are automatically reported daily, allowing for smooth operations while always being aware of the latest status.

[What is Yoom]

Here, we will explain how to implement the automation of "retrieving the latest reports from Google Analytics daily and notifying via Telegram" using Yoom's template without coding.

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

＞Register for free with Yoom

From here, we will introduce how to create a flowbot that retrieves the latest reports from Google Analytics daily and notifies via Telegram.

How to Create an Integration Flow to Get the Latest Reports from Google Analytics Daily and Notify via Telegram

Things to Prepare in Advance

Here is a list of items needed during the integration process.

Google Analytics

Login Information
- Please 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".

Group for notifications (the bot needs to be added)
- How to create a new bot is here
- Access Token

Step 1: Setting Up My App Integration

Here, you 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 to 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

Search and select Google Analytics. When the screen below is displayed, click the button to sign in to your Google account to proceed with the integration.

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.

Select Telegram from the search results. When selected, the screen below will be displayed, and you will be asked for the account name and access token.

Enter any name for the account name. The access token is issued when a new bot is created on Telegram.

＞Official: BotFather

After entering the access token, click the add button to complete My App registration.

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 my project. Click on the title within the red frame to navigate to the settings screen.

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

Click on the first process of the template. It is pre-configured, but let's check the content.

(1/1) Specify Execution Time

The following items are pre-configured.

Title of the schedule trigger
Schedule settings

The pre-configuration is set to start every day at 10 AM. The timing can be changed as desired. For more detailed settings, you can use Cron.

＞More details: How to set up Cron

→ Click Save

Step 4: Integrate with the App to Retrieve 【GA4】 User Reports

Click on the second process of the template! Here, we will proceed with setting up the information to be extracted from Google Analytics.

(1/2) Select the Linked Account and Action

The items displayed here are pre-configured.

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

→ Click Next

(2/2) Select the Linked 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 start 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
- In this setting, the last day is set to today. As with the start of the period, select the date from the dropdown and embed today's reference code.

→ Click Test → Success. The output extracted yesterday's data.

→ Click Save

Step 5: Integrate with the App to "Send a Message"

Click on the third template! In this process, we will set up the content to be automatically sent to Telegram.

(1/2) Select the Linked Account and Action

These items are pre-configured.

Title of the app trigger
App
Account information linked with Telegram
Trigger action

→ Click Next

(2/2) API Connection Settings

‍

Chat ID
- The group ID of Telegram is not directly displayed in the usual UI, but it can be obtained using a Bot. Use the string of the access token (API key) obtained earlier to get the ID of the group the Bot belongs to.
- https://api.telegram.org/bot<access token string>/getUpdates
- Accessing this API endpoint will display information about the groups the bot is participating in, including the group ID. For example, chat":{"id":-123456789,...} where the value of id is the group ID.

Message Content
- Clicking the edit field opens a dropdown, and the output extracted in the previous process is picked up.
- When you select the content to be sent to Telegram, the embed code is quoted.

→ Click Test → Success

→ Click Save The settings for this flow are now complete.

Step 6: Turn the App Trigger 【ON】

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

Turn the Trigger 【ON】 to start the flow bot.

<span class="mark-yellow">Automation was easily implemented without using programming.</span> Notifications of the report were confirmed on Telegram.

Here is the template used this time.

‍

Make the Most of It! 3 Automations Using Google Analytics and Telegram

Telegram and Google Analytics have developed many other templates.

1. Automatically Record Google Analytics Data in Google Sheets Daily

Automatically obtain the latest Google Analytics data daily and record it in Google Sheets. This eliminates the need for manual data entry and facilitates smooth sharing. It saves time, allowing you to focus on analysis and improvement, thereby enhancing work efficiency.

2. Receive the Latest Google Analytics Report on Chatwork Daily

Automatically obtain the latest report from Google Analytics and notify it on Chatwork. This eliminates the need for manual checking, ensures that information is regularly delivered to the entire team, allows for immediate understanding of website performance, and facilitates smooth progress of operations.

3. Automatically Notify Telegram of kintone Comment Updates

This setting automatically sends a notification to Telegram when a comment is posted on kintone. This allows you to stay informed of important updates without constantly checking kintone. It improves work efficiency and makes it easier to manage the progress of the entire team.

Summary

In this article, we introduced how to automatically notify Google Analytics reports to Telegram daily and the benefits for IT operations personnel. This automation eliminates the need for manual report retrieval and sharing, significantly streamlining daily operations. With integration between tools and centralized data management, you can always keep track of the latest web performance data and respond quickly. With Yoom, you can easily automate without any programming knowledge. Please make use of it to improve your work efficiency.

＞Start integrating Yoom for free

See you again!