Connect GA4 to Google Sheets

Connect GA4 to Google Sheets

It is very simple to connect GA4 to Google Sheets, it can be done in a fast and easy manner with Windsor.ai.

First Step:

You need to select Google Analytics 4 as a Data Source and Grant Access to Windsor.ai.

Second step:

Select Google Sheets as a data destination.

Third Step:

You can choose between two options:

Option 1: Advanced and for large data volumes

1. Click this link to install the Google Sheets add-on
2. Go to Extension – Ad Data and Analytics by Windsor.ai – Login
3. Enter your API key: [your API Key] and click Login
4. Start using the add-on in Google Sheets from the Add-ons menu in Extension – Ad Data and Analytics by Windsor.ai – Get Data into Sheet in Google Sheets document and select your fields

Option 2: Quickstart

• Copy the snippet below into your Google Sheet. Only works for fast queries below 60 seconds, use the add-on in case of issues.

• The URL works as an API data feed and the fields can be adjusted with the parameters in the URL.

• You can add any field that is available in the data sources you have added.
  

  ---

  =IMPORTDATA(“https://connectors.windsor.ai/googleanalytics4?api_key=[your API Key]&date_preset=last_28d&fields=account_name,clicks,date&_renderer=googlesheets")

  and replace  [your API Key] with your API key. The list of selected fields must contain a date field. The fields which are listed after &fields= are simply a set of standard fields which you can customise. A full list of metrics and dimensions can be found in our GA4 connector documentation. Customise the URL to your liking.

   

Try Windsor.ai today

Access all your data from your favorite sources in one place.
Get started for free with a 30 - day trial.

Start Free Trial

Other way to integrate GA4 data to Google Sheets

The most efficient way to transfer your data to Google Sheets from GA4 is through GA4’s interface, allowing you to export any report in CSV format and seamlessly import it into Sheets. Follow these 5 steps:

1. Open the desired built-in report or exploration for export, such as the Acquisition report.
2. Click on the share icon located in the top right corner to open the Share this report sidebar.
3. Choose the Download file option. You will then have the choice to download the file as a PDF or CSV. Opt for the CSV format, as discussed earlier.
4. After downloading the file, you can either copy and paste the data directly from the CSV file or import it into Google Sheets. To import, navigate to File → Import and upload the file.
5. During the import process in Sheets, you’ll encounter options and settings, allowing you to choose the Import location (create a new spreadsheet, insert new sheet(s), etc.) and Separator type. Click on the Import data button to complete the process.

While the data may initially appear unorganized in Sheets, you can refine and structure it for better comprehension.

Now, for Explorations in GA4, there’s added flexibility in exporting data, including the option to send it directly to Google Sheets.

Upon selecting the Google Sheets option, a new tab opens, allowing you to click on the Import data button to finalize the process.

This streamlined approach eliminates the need to download the data separately before importing it into Google Sheets, as it directly opens in the new tab.

Note: To download files for standard reports and explorations, you must have Editor/Admin access. Presently, there isn’t an option within the GA4 interface for scheduling reports to be emailed or updated in Sheets.