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

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!

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 flow bot that "obtains the latest reports from Google Analytics every day and notifies Microsoft Teams." By integrating with Microsoft Teams, automatic report notifications are possible, significantly reducing manual work. By having the entire team receive the latest data simultaneously at a set time every day, information can be shared quickly, and work efficiency is expected to improve.

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 Process of Obtaining the Latest Google Analytics Reports Daily and Notifying Microsoft Teams

From the perspective of digital marketers and data analysts, we considered the efficiency gained by 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 having Google Analytics reports automatically notified to Microsoft Teams daily, you can quickly grasp the overall performance of the website and user trends, allowing for immediate necessary improvements. Since manual data retrieval is no longer necessary, it is easier to focus on data analysis, and marketing strategy reviews can be efficiently advanced.

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 tasks and creates an environment where the entire team can take swift action. Along with time savings, communication within the team becomes smoother.

[About Yoom]

From here, we will explain how to implement automation to "obtain 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 Obtain the Latest Reports from Google Analytics Daily and Notify Microsoft Teams

Things to Prepare in Advance

We have listed the 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."

Microsoft Teams

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

※Microsoft365 (formerly Office365) has plans for home use and general corporate use (Microsoft365 Business), and if you are not subscribed to the general corporate plan, authentication may fail.

＞Help: Steps and Precautions for Registering My Apps 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 your 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 Apps 【GA4】 Obtain User Report

Click on the second process of the template! Here, you will configure the settings to extract information from Google Analytics.

(1/2) Select 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 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 as with the start of the period, and embed today's reference code.

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

→ Click Save

Step 5 Integrate with Apps "Send Message"

Click on the third template! In this process, you will set the content to be automatically sent to Microsoft Teams.

(1/2) Select 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. Select 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 embedding code will be automatically referenced.

‍

There are mention settings and attachment settings areas, but please configure these 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 configured, a completion screen will pop up.

Turn the trigger 【ON】 and 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 Automation Tips 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 every day. 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 Comments in kintone

Automatically notify Microsoft Teams of comments posted in 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 skilled in programming can easily start automating. Please use it to improve your work efficiency.</span>

＞Start integrating Yoom for free

See you again!