■Overview
This is a flow that retrieves the latest reports from Google Analytics every day and records them in Google Sheets.
■Recommended for
1. Companies using Google Analytics
・Those who check and improve website access status
・Those who compare their numbers with competitors to understand their strengths and weaknesses and apply them to their business
2. Those who utilize Google Sheets in their work
・Those who manage and share information on shared sheets within the team
・Those who use it for data accumulation
■Benefits of using this template
Google Analytics is a tool that can be used to enhance the overall engagement of your website by optimizing content.
However, manually retrieving the necessary data each time and adding it to Google Sheets takes away time from core tasks that should be focused on.
By using this flow, you can retrieve reports from Google Analytics at a specified time every day and add the results to Google Sheets.
Automating report retrieval and eliminating manual work allows you to allocate the time previously spent on manual tasks to solving issues.
This enables the entire team to focus on core tasks, facilitating smooth progress of overall operations.
■Notes
・Please integrate Yoom with both Google Analytics and Google Sheets.


When a row is added
When a row is updated
【GA4】Get User Report
【GA4】Retrieve Event Report
Input Value into Cell
Retrieve Value
Delete Values
Create a New Spreadsheet
Copy Sheet (Tab)
Add a New Sheet (Tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Information
Get Sheet Names
Repeat Formula
Input Values into Range
Embed Image in Cell
Sort by Specific Column
【GA4】Get User Report
【GA4】Retrieve Event Report
When a row is added
When a row is updated
Input Value into Cell
Retrieve Value
Delete Values
Create a New Spreadsheet
Copy Sheet (Tab)
Add a New Sheet (Tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Information
Get Sheet Names
Repeat Formula
Input Values into Range
Embed Image in Cell
Sort by Specific Column
Hide Sheet
Add Note to Specified Cell
Add Column
Delete Columns