Google アナリティクスで取得した解析データは、どのように管理していますか? もし、Google スプレッドシートに集約をしているのであれば、ノーコードツールを利用してアプリ連携してみませんか。 ここでは、簡単に連携する方法をご紹介するので、ぜひ試してみてくださいね!
こんな方におすすめ
Google アナリティクスとGoogle スプレッドシートでの業務効率化を考えている方。
Google アナリティクスのデータをGoogle スプレッドシートで管理している方。
Google アナリティクスとGoogle スプレッドシートを連携して、データの管理精度を向上させたい方。
今すぐに試したい方へ
本記事ではノーコードツール「Yoom」を使用した連携方法をご紹介します。
難しい設定や操作は必要なく、非エンジニアの方でも簡単に実現できます。
下記のテンプレートから今すぐに始めることもできるので、ぜひお試しください!
In marketing, where speed is crucial, interpreting constantly changing numbers is an important task. To leverage this in the future, analysis results must be checked and managed daily.
<span class="mark-yellow">What we recommend here is an app integration that automatically aggregates analysis data obtained from Google Analytics.</span> How do you manage the analysis data obtained from Google Analytics? If you are aggregating it in Google Sheets, let's connect the apps using Yoom, which allows for no-code app integration.
Benefits of Integrating Google Analytics with Google Sheets
1. Resource Savings
The analysis results from Google Analytics will be added to Google Sheets at a predetermined time every day. This automates daily data collection, allowing you to allocate resources to other tasks. Additionally, even if you have a preferred layout in Google Sheets, you can automatically input numbers, making it easier for your team to manage the data.
2. Maintaining Data Accuracy
When entering analysis results manually, there is a risk of data inaccuracy due to input errors. Since the numbers from the analysis results can influence the direction of future web content, such errors should be avoided as much as possible. This is why we recommend reducing and automating the task of entering data into Google Sheets. Automation minimizes human errors that can occur during manual entry. Furthermore, since the analysis results are entered at the same time every day, data consistency is maintained, making it easier to manage.
[About Yoom]
How to Create a Flow for Integrating Google Analytics with Google Sheets
Here, we will explain how to automate the flow of "obtaining the latest report from Google Analytics daily and recording it in Google Sheets."
First, register with Yoom. A two-week trial period is available, so you can try it out!
1. Click on "View Details" on the banner below 2. Click on "Try This Template" at the bottom of the transitioned screen 3. Register with Yoom
*If you are already registered, a login screen will appear, so please log in.
Flowbot Template Used This Time Obtain the Latest Report from Google Analytics Daily and Record It in Google Sheets
STEP1: My App Integration
When the display appears as shown in the image, please select "My Apps" from the menu on the left side of the screen. We will now integrate Google Analytics and Google Sheets with Yoom.
Google Analytics Integration
First, we will proceed with the integration of Google Analytics.
1. Search from New Creation
Select "New Creation" at the top right and enter "Google Analytics" in the search box. Then, select the Google Analytics icon.
1. Click Sign With Google
The above screen will be displayed. Press Sign With Google.
2. Select Account Select the Google account of the Gmail address to integrate with Yoom.
3. Log in to Yoom
When the above display appears, check the terms and press Next.
4. Grant Permissions "When "Yoom is requesting additional access to your Google Account" is displayed, press Continue. Proceed to the authentication screen and select <span class="mark-yellow">Allow all permissions</span>.
Google Sheets Integration
Next, we will proceed with the integration of Google Sheets. Search for "Google Sheets" from the new connection button at the top right. Since Google Sheets is the same Google service as Google Analytics, the method for setting up My App integration is the same as before. Make sure not to forget to select <span class="mark-yellow">Allow all permissions</span> during the integration.
Once the My App integration of Google Analytics and Google Sheets is complete, use the copied template to set up the Flowbot. If you haven't copied it yet, please copy the Flowbot template from below.
1. Hover over the banner and click "View Details" 2. Click "Try This Template" on the page you navigated to 3. Register for Yoom * If you have already registered, the login screen will be displayed, so please log in.
STEP2: Set the Schedule Trigger
1. Open My Project Return to the Yoom screen and select "[Copy] Get the latest report from Google Analytics daily and record it in Google Sheets" from the menu on the left.
2. Open the calendar icon for "When the specified schedule is reached" The title and trigger action settings are complete, so click Next.
3. Set the trigger activation time
Check the days of the week you want to register the analysis results in Google Sheets and set the time to activate the trigger. By default, it is set to register at 10:00 every day. Once you have completed the input, press Save.
STEP3: Google Analytics Settings
1. Open the Google Analytics icon for "[GA4] Get User Report" The title and trigger action settings are complete, so proceed to the next step.
2. Enter the Property ID
Copy from the Google Analytics admin screen and paste it into the box.
3. Set the Period
Set the period for when to send the analysis data. By default, it is set to retrieve yesterday's data.
4. Run the Test Once you have entered the required fields, click the Test button. When "Test Successful" is displayed, the Google Analytics settings are complete. Press Save and proceed to the next step.
STEP4: Google Sheets Settings
1. Prepare Google Sheets Prepare a format to save the analysis results obtained from Google Analytics. The data that can be obtained is as shown in the image below.
This time, we created a spreadsheet to collect all the data.
Data can be automatically appended in any format without any issues.
2. Open the Google Sheets icon for "Add Record" The title and trigger action settings are complete, so scroll down.
3. Link the Database
Enter the items in the image.
By clicking inside the box, a list of linked Google Sheets will be displayed. Select the Google Sheet to which you want to add the analysis results obtained from Google Analytics.
Please set the tab name of the spreadsheet in the same way.
Regarding the table range, it depends on Google Sheets, so set it according to Google Sheets. This time, it was set as shown in the image.
4. Enter the Values of the Records to be Added
Fill in each item. The box names in the above image depend on the Google Sheets you prepared. Therefore, they may differ from the notation, but the setting method is the same.
First, hover the cursor inside the box and click. Select the item from the Google Analytics icon.
From the list of displayed data, select the one equal to the box item name and click to enter it.
For other boxes, also select and fill in the data equal to the item.
5. Run the Test Once you have completed the input, press the Test button. After confirming the test success, please save it.
6. Turn ON the Trigger
When the creation of the flow bot is complete, it will be displayed as shown above. The trigger is initially set to OFF, so turn it ON.
This completes the creation of the flow bot using Google Analytics and Google Sheets.
Flow bot template used this time Get the latest report from Google Analytics daily and record it in Google Sheets
Other Examples of Automation Using Google Analytics
There are many other examples of automation using Google Analytics in Yoom, so here are a few introductions.
1. Retrieve the latest report from Google Analytics daily and notify via Google Chat Notifications can also be sent to communication tools. This can be effective in preventing oversights.
2. Obtain the latest report from Google Analytics daily and notify via LINE It can be integrated with personal LINE. Creating a chat room allows for sharing with members.
3. Obtain the latest report from Google Analytics every day and record it in Microsoft Excel It is also compatible with Microsoft Excel. If you desire more complex data processing, this is recommended.
Summary
By integrating Google Analytics with Google Sheets, you can reduce the hassle of daily routine tasks. This leads to improved work efficiency, so be sure to give it a try. Automate repetitive daily tasks to save time!
Web会議終了後に音声を文字起こししてGoogle スプレッドシートに追加する
Google MeetやZoomでWeb会議が終了したら、音声を文字起こししてGoogle スプレッドシートに自動で追加します。
Google アナリティクスとGoogle スプレッドシートを連携するメリット
1.リソースの節約
Google アナリティクスの解析結果が、毎日決められた時間にGoogle スプレッドシートへ追加されるようになります。 これにより、日々のデータ収集が自動化されるので、その他の業務にリソースを割り振ることができるのではないでしょうか。 また、Google スプレッドシートを好みのレイアウトにしている場合でも数値を自動入力できるので、チームがやりやすい状態でデータを管理できて便利ですよ。
Google アナリティクスとGoogle スプレッドシートを連携することで、日々の定型業務の手間を省くことが可能です。 導入することで、業務効率向上につながるはずです。 Yoomならノーコードで簡単に連携を実現できるので、ぜひ取り入れてみてくださいね。 毎日繰り返す作業を自動化して、時間の節約をしてみましょう!
The person who wrote this article
a.ohta
After working as a general store manager, I started working from home as an SEO writer. Later, an outsourcing agreement was signed with a marketing startup for about 5 years.
Surrounded by students at the University of Tokyo, I held a computer and spent my days studying various business terms and how to use SaaS tools.
When I was a general store manager, time was taken over and over again by office work such as sales and inventory management, human resource management, and ordering, etc., and I was unable to serve customers and often missed sales times. Even when outsourcing, there are many detailed tasks such as input, etc., and “can't such monotonous tasks be automated?” I thought so, and I really sympathize with Yoom's vision!
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.
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.