How to Integrate Google Analytics with Slack to Streamline Daily Data Sharing

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 the way, Cron settings allow for more detailed time configurations.

＞Learn more: How to set up Cron

→ 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 obtain information extracted from Google Analytics.

(1/2) Select 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 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, since we want to check the daily report, we set it to extract data from yesterday to today.

• End of the period
  • This time, "Today" was set 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! Data from yesterday was extracted in the output.

→ Click Save

Step 5 Integrate with Apps "Send Message"

Click on the third template! In this process, you will configure the content to be automatically sent to Slack.

(1/2) Select Linked Account and Action

These items are pre-configured.

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

→ Click Next

(2/2) API Connection Settings

• Channel ID
  • Click the edit field to display a list of channel candidates from the linked Slack account. When you select the appropriate channel, the ID is automatically referenced.

• Message Content
  • Click the edit field to open a dropdown, displaying the output extracted in the previous process.
  • When you select the content to be sent to Slack, the embed code is automatically referenced.

→ Click Test → Success!

→ Click Save This concludes 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.

Other Automation Examples Using Google Analytics and Slack

In addition to the integrations introduced today, it is possible to achieve various automations by utilizing the APIs of Google Analytics and Slack.

If there is something that interests you, please give it a try!

‍‍Automation Example Integrating Google Analytics and Slack

You can also automatically notify Slack after obtaining Google Analytics event reports daily and adding them to Google Sheets or Microsoft Excel.

Example of Automation Using Google Analytics

Retrieve the latest report from Google Analytics daily and record it in the database

Retrieve the latest report from Google Analytics daily and automatically record it in Google Sheets or Microsoft Excel.

Send the latest report from Google Analytics via email every day

Automatically retrieve the latest report from Google Analytics every day and send it via email using Outlook or similar services.

Examples of Automation Using Slack

Notify Slack of Inquiry Contents

Automatically notify Slack of inquiry contents sent via Google Forms or Gmail.

Post a summary of the meeting content to Slack after the web meeting ends

Once a web meeting on Google Meet or Zoom ends, transcribe and summarize the content, and automatically notify Slack.

Notify Slack When a File is Saved to Cloud Storage

Automatically notify Slack when a file is saved to Google Drive or similar services.

Two Benefits of Automating Daily Google Analytics Report Retrieval and Slack Notifications

From the perspective of data analysts and IT support/operations teams, we explore the advantages of using Google Analytics and Slack for automation.

Benefit 1: Reduced Data Analysis Time

By automatically notifying Slack with the latest reports from Google Analytics daily, the time spent manually retrieving reports is significantly reduced. This allows data analysts and marketing teams to access the necessary data on time, enabling quick analysis and decision-making. As a result, they should be able to quickly find solutions to problems and formulate strategies swiftly!

Benefit 2: Prevention of Missing Important Data

With automatic notifications ensuring regular data checks, the risk of missing important data is reduced. Especially for IT support and operations teams, it becomes possible to respond early to sudden traffic changes or system issues. Therefore, even if troubles occur, they can respond quickly, leading to stable business operations!

Conclusion

In this article, we introduced a method to automate notifications by integrating Google Analytics and Slack without programming. This eliminates the need for manual report retrieval, potentially streamlining the work of data analysts and IT support/operations teams. Additionally, receiving reports daily on Slack means users don't need to retrieve them manually! Furthermore, receiving notifications on Slack allows for immediate review and analysis, saving time.

With Yoom's Flowbot, even those who are not good at programming can start automating today. Please consider incorporating automation to help improve work efficiency.

See you again!