How to Automatically Record Google Analytics Information in Google Sheets Daily

STEP1: My App Integration

When the display appears as shown in the image, please select "My App" from the menu on the left side of the screen.
From here, we will integrate Google Analytics and Google Sheets with Yoom.

Google Analytics Integration

First, we will start 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 window.
Then, select the Google Analytics icon.‍

1. Click Sign With Google

2. Select an Account
‍Choose the Google account with 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 the message "Yoom is requesting additional access to your Google account" appears, press Continue.
Proceed to the authentication screen and select <span class="mark-yellow">Allow all permissions</span>.

Google Sheets Integration

Next, we will integrate Google Sheets.
Search for "Google Sheets" from the new connection button at the top right.
Since Google Sheets is a Google service like Google Analytics, the My App integration setup method 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 with Google Analytics and Google Sheets is complete, use the copied template to set up the Flowbot.

‍STEP2: Schedule Trigger Setup

1. Open My Project
‍Return to the Yoom screen and select "[Copy] Retrieve the latest report from Google Analytics daily and record it in Google Sheets" from the menu on the left.

2. Open the "When the specified schedule is reached" calendar icon
‍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 AM every day.
Once the input is complete, press Save.

STEP3: Google Analytics Setup

1. Open the "Retrieve [GA4] User Report" Google Analytics Icon
‍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 the required fields are filled, click the Test button.
When "Test Successful" is displayed, the Google Analytics setup is complete.
Press Save and proceed to the next step.

STEP4: Google Sheets Setup

1. Prepare Google Sheets
‍Prepare the 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 without any issues regardless of the format.

2. Open the "Add Record" Google Sheets Icon
‍The title and trigger action settings are complete, so scroll down.

3. Link the Database

Fill in 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.

Also, 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 prepared Google Sheets. Therefore, there may be differences from the notation, but the setup method is the same.

First, place the cursor inside the box and click.
Select the item of the Google Analytics icon.

From the displayed data list, select and click the one equal to the box item name to enter it.

For other boxes, select and fill in the data equal to the item.

5. Run the Test
‍Once the input is complete, press the Test button.
After confirming the test success, please save.

6. Turn ON the Trigger

When the creation of the Flowbot is complete, the above display will appear.
The trigger is initially set to OFF, so turn it ON.

This completes the creation of the Flowbot using Google Analytics and Google Sheets.

Flowbot Template Used This Time
Retrieve the latest report from Google Analytics daily and record it in Google Sheets

Other Automation Examples Using Google Analytics and Google Sheets

In addition to the integrations introduced today, various automations can be achieved by utilizing the APIs of Google Analytics and Google Sheets.

If you find something interesting, please give it a try!

Automation Examples Integrating Google Analytics and Google Sheets

You can obtain the latest information from Google Analytics' user and event reports daily and add it to Google Sheets.
Additionally, it is possible to set up an integration where, when a row is added in Google Sheets, the latest user or event reports are retrieved from Google Analytics.

Example of Automation Using Google Analytics

Retrieve the latest report from Google Analytics daily and notify via chat tool

Automatically retrieve the latest report from Google Analytics daily and notify via Slack, Discord, etc.

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.

Automation Example Using Google Sheets

Add a Row in Google Sheets and Automatically Update the Database

When a row is added in Google Sheets, it is automatically registered in Notion, Airtable, etc.

Create a folder in cloud storage when a row is added in Google Sheets

Automatically create a folder in Google Drive, OneDrive, etc., when a row is added in Google Sheets.

Transcribe Audio and Add to Google Sheets After Web Meeting

After a web meeting on Google Meet or Zoom ends, the audio is transcribed and automatically added to Google Sheets.

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 convenient for your team to manage data in a way that suits them.

2. Maintaining Data Accuracy

When entering analysis results manually, there is a possibility that data accuracy may not be maintained due to input errors.
Since the numerical results of the analysis can influence the future direction of web content, such errors should be avoided as much as possible.
Therefore, it is recommended to automate the task of entering data into Google Sheets.
This is because automation can prevent human errors that may occur during manual entry.
Moreover, since the analysis results are entered at the same time every day, it may become easier to analyze the data.

Conclusion

By integrating Google Analytics with Google Sheets, you can eliminate the hassle of daily routine tasks.
Implementing this integration should lead to improved work efficiency.
With Yoom, you can easily achieve this integration without any coding, so give it a try.
Automate repetitive daily tasks to save time!