Back to Blog

How to Connect GA4 to Google Sheets Without Coding 

You already know that from July 1, 2023, Universal analytics or Google Analytics 3 property will no longer be available. A change will not come overnight, and you have almost a year to get prepare for it. One aspect of such preparation is advanced reporting. 

Many of you have exported reports from Google Analytics to visualize, build interactive dashboards, or process the insights in many other ways for one thing – to make data-driven decisions. Soon, you’ll need to export these reports from the GA4 property. So, it’s better to learn in advance what this data flow looks like. Our guide is meant to help you deal with this and introduce how you can export data from Google Analytics 4 to Google Sheets.

What are the options to export GA4 to Google Sheets?

Natively, you can export a report from GA4 by manually downloading it as a CSV file. Then you can upload this file to Google Sheets to do the job. That’s the layman’s method that we’ll describe in the next section. However, it’s not that efficient, and you probably want to have something similar to the Google Analytics add-on for Google Sheets to automate exports on a schedule.

Unfortunately, there is no native direct GA4 to Google Sheets integration so far. But there is one for BigQuery! You can stream all of your raw events from Google Analytics 4 properties to BigQuery, and then automate exports of SQL queries to Google Sheets using Coupler.io. No coding or messing with APIs is needed – you can set up everything with just a few clicks. 

If this is what you need, scroll right to this part. In the meantime, we share the most basic way to export Google Analytics 4 to Google Sheets. 

Google Analytics 4 to Google Sheets – layman’s method

  • Select the report you want to export and click Share this report in the top right corner.
1 share ga4 report
  • Click Download file.
2 download file ga4 report
  • Choose Download CSV and welcome your GA4 report exported as a CSV file to your computer.
3 download csv ga4

The next stage is to upload this CSV file to Google Sheets. 

  • Create a new sheet or open an existing one, then go to File => Import.
4.1 import ga4 to google sheets
  • Select Upload and select your file with the GA4 report.
4.2 import ga4 to google sheets
  • Select the Import location and Separator type, then click Import data.
4.3 import ga4 to google sheets

That’s it. Here is what it looks like in Google Sheets:

4.4 import ga4 to google sheets

This way of exporting data from Google Analytics 4 to Google Sheets is good if you do this rarely, for example, once per month. But it excludes any automation, meaning that it does not fit for building any self-updating reports or dashboards. The next method will let you achieve this.

Connect GA4 to Google Sheets via BigQUery

Currently, there is no native integration to connect GA4 to Google Sheets. But we’ll create one using the GA4 link to BigQuery. After that, the BigQuery to Google Sheets integration by Coupler.io will let us automate the exports of queries from BigQuery to Google Sheets. So, our Google Analytics 4 to Google Sheets connection will include two steps:

  • Link GA4 to BigQuery.
  • Connect BigQuery to Google Sheets.

How to link Google Analytics 4 to BigQuery

To link GA4 to BigQuery, you need to have a Google Cloud project and a BigQuery project properly set up for your Google account associated with GA4. If you don’t have any BigQuery projects yet, please refer to our BigQuery Setup Guide with detailed step-by-step instructions. 

  • Click Admin in the bottom left corner of the Google Analytics panel.
5.1 link ga4 bigquery admin
  • Select BigQuery Links in the Product Links section.
5.2 bigquery links
  • Click the Link button to connect your BigQuery project.
5.3 bigquery links
  • Click Choose a BigQuery project to select a project to link to your GA4 property. 
5.4 choose bigquery project
  • Select a project, then click Confirm.
5.5 select bq project confirm
  • Select the location for your data, then configure the settings for your data from GA4 to BigQuery. Click Next.
5.7 ga4 bigquery link settings

You can choose two streaming export options (frequency):

  • Daily – the GA4 data will be exported once a day. In BigQuery, your GA4 data will be placed in tables named as follows: events_YYYYMMDD
  • Streaming – the GA4 data will be exported continuously, so you’ll have the most recent information available. BigQuery will create a separate daily table for your GA4 data named as follows: events_intraday_YYYYMMDD

You can turn on both options to have both daily and real-time sync. 

  • The last step is to review and submit the link. Click Submit to create the link.
5.8 ga4 bigquery link created

What’s next? If you go to BigQuery, you’ll see a newly created data set and tables in it. The data set name is generated as follows: analytics_{{property-id}}. In our case, it looks as follows:

5.9 ga4 data ib bigquery

The first stage of our GA4 to Google Sheets connection is ready. Now, proceed to the second one where we connect BigQuery to Google Sheets.

How to export data from GA4 to Google Sheets via BigQuery

As we mentioned in the beginning, you’ll need Coupler.io to automate the exports of queries from BigQuery to Google Sheets. 

Coupler.io is a data integration tool to import data from multiple sources such as BigQuery, Airtable, Facebook Ads, and others to Google Sheets, Microsoft Excel, and BigQuery. Coupler.io does not provide GA4 as a data source so far. However, if you feel that you need it, let us know about it.

Sign up to Coupler.io, click Add importer, and select the source and destination apps. In our case, these are BigQuery and Google Sheets, respectively.

6.1 bigquery google sheets

Then configure the connection to each of these as follows.

BigQuery as a source

Select a .json key file
  • Then enter the SQL query of the data you want to export to Google Sheets. For example, let’s export data from Google Analytics 4 to Google Sheets that we have in an entire BigQuery table. 
6.2 bigquery ga4 query

Our SQL query string will look like this:

SELECT * FROM `couplerio-demo.analytics_300876351.events_20220801`
6.3 sql query bigquery integration

Google Sheets as a destination 

  • Connect to your Google account and select a spreadsheet on your Google Drive to load BigQuery data from Google Analytics 4 to Google Sheets. You’ll also need to select a sheet or create a new one if you wish. 
6.4 destination google sheets ga4

Check out the optional parameters, such as Cell address / Range or Import mode, to meet your data transfer needs.

Automate exports on a schedule

Coupler.io allows you to automate data exports from BigQuery on a schedule, from every month to every 15 minutes. Toggle on the Automatic data refresh and configure the interval, days of the week, time preference, and zone.

10 schedule

Eventually, click Save and Run to launch your integration. Here is what the records exported from Google Analytics 4 to Google Sheets via BigQuery look like:

6.5 ga4 in google sheets

Why is this way of connecting GA4 to Google Sheets the best one?

The drawback and, at the same time, the advantage of the described method is the BigQuery Link. 

The drawback is that you have to set up two data flows instead of one which would connect GA4 to Google Sheets directly. However, it does not take much time and is not that difficult even if you haven’t used BigQuery before.

The benefit is that you have a backup copy of your GA4 data in BigQuery which is undisputedly a win. Besides, it’s much easier to query your Google Analytics data in BQ using the power of SQL. And Coupler.io allows you to export the required chunk of data with literally a few clicks (unfortunately, we did not count how many 🙂

Nevertheless, if you still believe that BigQuery is unnecessary for you to export data from Google Analytics 4 to Google Sheets, fill out this form. It’s a request for GA4 as a new data source at Coupler.io.

Back to Blog

Comments are closed.

Focus on your business
goals while we take care of your data!

Try Coupler.io