How to Integrate Applications

2024-12-24

How to Integrate Google Analytics with Chatwork to Automatically Receive and Notify Daily Reports

k.hieda

In business, the ability to accurately respond to user needs is a factor that makes you chosen by customers and the market. Quickly understanding website traffic data and user behavior and responding appropriately can help differentiate you from other companies. However, if you spend time manually obtaining and sharing reports every day, it may delay marketing strategies and operational improvements.

Therefore, at Yoom, we have developed automation that "obtains the latest reports from Google Analytics every day and notifies Chatwork." We believe this automation can help solve these challenges.

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 the Latest Reports from Google Analytics and Notifying Chatwork Daily

We considered it from the perspective of web administrators (site operators) and data analysts.

Benefit 1: Strengthening the Rapid Response System

By automatically notifying Chatwork of reports from Google Analytics, web administrators can regularly check traffic fluctuations and system issues. You can easily share the situation through Chatwork's interface and smoothly manage the progress of responses by utilizing the task management function. This improves the efficiency of the response system in website operations and reduces interruptions or delays in work.

Benefit 2: Preventing Missing Important Data

By using the automatic notification function, data analysts can regularly receive daily reports and have no worries about missing important data. By managing points that need attention using Chatwork's task function, analysis work can proceed efficiently. Additionally, since past reports can be easily referenced, it is useful for trend analysis and long-term strategy formulation. Centralizing data allows for more accurate data analysis.

[About Yoom]

From here, we will explain how to create automation that "obtains the latest reports from Google Analytics every day and notifies Chatwork" 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 a Workflow for Retrieving the Latest Reports from Google Analytics and Notifying Chatwork Daily

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
  1. Log in to Google Analytics and select the account with the property.
  2. Click the "Admin" button (gear icon) at the bottom left.
  3. Select the relevant property from the property column.
  4. Click "Property Settings" to display the "Property ID."

Chatwork

Step 1: Set 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 from the Sign in with Google Account button.

Enter the email address and password for the account to be integrated on the next screen.

Once logged in, proceed to grant permissions.

 

This completes the integration with Google Analytics.

Chatwork

Select Chatwork from the search results. You will be prompted to log in.

Enter the email address and password for the account to be integrated and allow access from Yoom.

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 the "My Project" in the Yoom workspace.

マイプロジェクトにテンプレートがコピーされます。赤枠内のタイトルをクリックで設定画面に遷移します。

ステップ3 スケジュールトリガー「指定したスケジュールになったら」

テンプレートの1つ目のプロセスをクリックします。あらかじめ設定済みですが、中身を確認します。

(1/1)実行時間の指定

下記項目は初期設定済みです。

  • スケジュールトリガーのタイトル
  • スケジュール設定

今回は、毎日朝10時に起動する設定にしています。任意のタイミングに変更が可能です。ちなみにCron設定ではより細かい時間の設定もできます。

>もっと詳しく:Cron設定方法

→保存する をクリック

ステップ4 アプリと連携する 【GA4】ユーザーレポートを取得

テンプレートの2つ目のプロセスをクリック!ここではGoogle アナリティクスから抽出する情報を取得する設定を行います。

(1/2)連携アカウントとアクションを選択

こちらに表示される項目は初期設定済みです。

  • アプリトリガーのタイトル
  • アプリ
  • Google アナリティクスと連携するアカウント情報
  • トリガーアクション

→次へをクリック

(2/2)連携アカウントとアクションを選択

  • プロパティID
    • Google アナリティクスにログインし、プロパティのあるアカウントを選択。
    • 左下の「管理」ボタン(歯車のアイコン)をクリック。
    • プロパティの列の中から、該当するプロパティを選択。
    • 「プロパティ設定」をクリックすると、「プロパティID」が表示されます。
  • 期間の開始
    • 計測期間の始めを設定します。形式は「YYYY-MM-DD」です。
    • 編集欄をクリックで、プルダウンが開きます。日付タブから日付の引用コードを埋め込みます。今回は毎日のレポートをチェックしたいため、昨日から今日までのデータを抽出するように設定してみました。
  • 期間の終わり
    • 今回は「本日」を最終日にしました。期間の開始と同様にプルダウンから日付を指定し、本日の引用コードを埋め込みました。

→テストをクリック →成功 アウトプットには昨日のデータが抽出されました。

→保存する をクリックします

ステップ5  アプリと連携する「メッセージを送る」

テンプレートの3つ目をクリック!このプロセスではChatworkへ自動送信する内容を設定します。

(1/2)連携アカウントとアクションを選択

こちらの項目は初期設定済みです。

  • アプリトリガーのタイトル
  • アプリ
  • Chatworkと連携するアカウント情報
  • トリガーアクション

→次へをクリックします。

(2/2)API接続設定

  • チャンネルID
    • 編集欄をクリックすると、連携したChatworkのアカウントからチャンネルの候補一覧が表示されます。該当のチャンネルを選択すると、自動でIDが引用されます。
  • メッセージ内容
    • 編集欄をクリックするとプルダウンが開き、先ほどのプロセスで抽出したアウトプットが表示されます。
    • Chatworkに送信する内容を選択すると、自動で埋め込みコードが引用されます。
    • >ヘルプ:Chatworkでのメンション方法

→テストをクリックします。 →成功

→保存するをクリックします 今回のフローでの設定はここまでです。

ステップ6 アプリトリガーを【ON】にする

全てのプロセスが設定済みになると、コンプリート画面がポップアップされます。

トリガーを【ON】にして、フローボットを起動しましょう。

<span class="mark-yellow">プログラミングを使わず、短時間で自動化を実現できました。</span>Chatworkにはレポートが投稿されていました。

今回のテンプレートはこちらです。

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

We have developed many other templates for Chatwork and Google Analytics.

1. Automatically Record Google Analytics Reports Daily

Automatically retrieve the latest reports from Google Analytics every day and record them in Google Sheets. This eliminates the need for manual data retrieval, allowing you to focus more on core tasks.

2. Notify Google Analytics Reports to Microsoft Teams

Automatically retrieve Google Analytics reports daily and notify them to Microsoft Teams. This allows the entire team to access them in real-time, enabling efficient information sharing.

3. Instantly Notify kintone Comments in Chatwork

Automatically notify comments posted on kintone in Chatwork. This allows the person in charge to check the status in real-time and respond promptly.

Summary

In this article, we introduced a method to integrate Google Analytics with Chatwork to automatically send reports daily. This automation eliminates the need for manual report retrieval and sharing, allowing web administrators and data analysts to focus on their daily tasks. By utilizing Chatwork's task management features, you can smoothly address actions based on the report's content.

This enables quick decision-making and responses, potentially improving overall operational efficiency.

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

Start Yoom integration for free

See you again!

The person who wrote this article
k.hieda
10 years as a web planner and director. When I worked for a web production company, my main focus was on proposing modifications and operation plans to clients and proceeding with production. I'm currently a parallel worker. We produce blogs in Yoom's content division, and receive external public relations projects for companies in our individual business. Since we are starting a private lodging, we aim to thoroughly improve the efficiency of routine work!
Tags
Chatwork
Automatic
Automation
Integration
Google Analytics
App integration
No items found.
What is Yoom hyperautomation?
Conventional RPA can only automate simple repetitive tasks, and the setup process was very complicated.
With “hyperautomation,” which combines various technologies such as AI, API, RPA, and OCR, it is possible to automate many tasks that could not be realized until now more easily than before.
Don't Just Connect Apps—Automate Everything
Most tools simply connect one app to another, leaving the complex tasks to you. Yoom goes much further: From document creation and browser automation to OCR and generative AI, Yoom handles it all seamlessly in one platform.

Why settle for basic integrations? Streamline your entire workflow with Yoom’s powerful hyperautomation.
Learn more about Yoom
Helpful Materials
I understand Yoom! 3-piece set of materials
Download materials
Understand in 3 minutes! Yoom service introduction materials
Download materials
Find out by Before After! Yoom Case Study Collection
Download materials
See a list of useful materials