How to integrate Google Analytics with Microsoft Teams to receive daily reports and notifications in Microsoft Teams

Google Analytics is used by many companies to analyze and improve website performance. However, manually obtaining reports every day and sharing them with the team is a hassle.

Therefore, at Yoom, we have developed a flowbot that "retrieves the latest reports from Google Analytics every day and notifies Microsoft Teams." By integrating with Microsoft Teams, automatic report notifications become possible, significantly reducing manual work. By receiving the latest data simultaneously at a set time every day, the entire team can quickly share information, leading to improved work efficiency.

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

Two Benefits of Automating the Retrieval of the Latest Google Analytics Reports and Notifying Microsoft Teams Daily

From the perspective of digital marketers and data analysts, we considered the efficiency of integrating Google Analytics with Microsoft Teams.

Benefit 1: Quickly Improve Marketing Strategies

For digital marketers, an environment where the latest data can be checked immediately is crucial. By automatically notifying Microsoft Teams of Google Analytics reports daily, you can quickly grasp the overall performance of the website and user trends, and make necessary improvements immediately. Since manual data retrieval is unnecessary, it is easier to focus on data analysis, and marketing strategy reviews can be carried out efficiently.

Benefit 2: Smooth Information Sharing Across the Team

Automation is also a significant benefit for data analysts and other team members. Since reports can be shared simultaneously using Microsoft Teams, everyone can proceed with discussions based on the same data. This reduces manual reporting work and creates an environment where the entire team can take swift action. Along with time savings, communication within the team becomes smoother.

[About Yoom]

Here, we will explain how to implement automation to "retrieve the latest reports from Google Analytics daily and notify Microsoft Teams" using Yoom's templates without coding.

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 Microsoft Teams

Things to Prepare in Advance

We have listed the items needed for the integration work.

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".

Microsoft Teams

Microsoft365 login information (email, phone number, Skype ID, password)

*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.

＞Help: My App Registration Procedure and Precautions in Microsoft365 Services

Step 1: Setting Up My App Integration

Here, we will set up the registration of the app to be integrated with 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.

‍

On the next screen, enter the email address and password for integration.

Once logged in, proceed with granting permissions.

This completes the integration with Google Analytics.

Microsoft Teams

Select Microsoft Teams from the search results.

You will be redirected to this screen, where you will enter your Microsoft365 login information.

This completes the My App registration.

Step 2: Copy Yoom's Template to My Project

Click on 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 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 you prefer. By using Cron settings, you can set more detailed times.

＞Learn more: How to set Cron settings

→ Click Save

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

Click on the second process of the template! Here, we will set up to extract information from Google Analytics.

(1/2) Select the Integration Account and Action

The items displayed here are pre-configured.

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

→ Click Next

(2/2) Select the Integration 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
- For daily settings, the last day is today. Specify the date from the dropdown just like the start of the period, and embed today's reference code.

→ Click Test → Success, yesterday's data has been extracted in the output.

→ 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 Microsoft Teams.

(1/2) Select the Integration Account and Action

These items are pre-configured.

Title of the app trigger
App
Account information to integrate with Microsoft Teams
Trigger 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, and the ID will be referenced.

Channel ID
- Click the edit field to open a dropdown. Choose from the channel candidates, and the ID will be automatically referenced.

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 send to Microsoft Teams, and the embed code will be automatically referenced.

‍

There are mention settings and attachment settings areas, but please configure them as needed.

▼ Mention Settings Area

▼ Attachment Settings Area

＞Help: How to send a message with a file in Microsoft Teams

→ Click Test → Success

→ Click Save This is the end of the settings for this flow.

Step 6: Turn the App Trigger 【ON】

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

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

<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 Automations Using Google Analytics and Microsoft Teams

Microsoft Teams and Google Analytics offer many more templates.

1. Automatically Record Google Analytics Reports in Google Sheets

Automatically record the latest Google Analytics reports in Google Sheets daily. This eliminates the need for manual data entry, allowing you to focus on important tasks and improving overall work efficiency.

2. Automatically Notify Google Analytics Reports to Chatwork

Retrieve reports from Google Analytics daily and automatically notify them in Chatwork. This allows you to check the latest data in a timely manner, reducing manual work and enabling quick decision-making across the team.

3. Automatically Notify Microsoft Teams of kintone Comments

Automatically notify Microsoft Teams of comments posted on kintone. This allows the entire team to share information in real-time, facilitating quick progress management and response, thereby preventing project delays.

Summary

In this article, we introduced how to automatically notify Microsoft Teams with Google Analytics reports daily and the benefits of doing so. Automation eliminates the need for manual report retrieval and sharing, allowing digital marketers to quickly respond to campaign improvements, and enabling data analysts and the entire team to efficiently share information. Daily operations become smoother, allowing for quicker decision-making and strategy revisions.

<span class="mark-yellow">With Yoom, even those who are not good at programming can easily start automating. Please make use of it to improve your work efficiency.</span>

＞Start integrating with Yoom for free

See you next time!