How to export Google Analytics data to Google Sheets with Amigo Data:
1. Connect Google Analytics to Amigo Data
2. Choose your property, dimensions and metrics to export
3. Click IMPORT and set the refresh schedule to automatically update the report
Google Analytics is a web traffic service offered by Google that lets you track website traffic and activities such as sessions, pages per session, engagement rate, engagement time, the bounce rate of visitors, source of the traffic, conversion figures, and many more. Google Analytics can help you identify poorly performing pages with techniques such as funnel visualization, where visitors came from, how long they stayed and the website and their geographical location.
Useful and feature-packed as it is, Google Analytics isn’t the most user-friendly and the user interface is not very intuitive. It is complex and can be overwhelming and cumbersome even for a veteran user.
But fret not, for there are ways you can circumvent this without missing out on the perks that Google Analytics offers by integrating it with Google Sheets using our tool Amigo Data.
Why connect Google Analytics to Google Sheets
Having the data in a spreadsheet, neatly organized and sorted not only makes it much easier to understand and keep track of the performance of your website, it also makes custom visualization of the data possible. You can highlight the peak and the lows and other important values. Google Sheets provides analytic tools for all kinds of purposes.
Why use Amigo Data to export Google Analytics data to Google Sheets
It is important that you keep an eye on your website performance regularly so that issues do not creep in unnoticed chipping away a crucial competitive edge from your website. Small issues, if not addressed quickly, could accumulate and may require large time and resources to rectify.
Constantly monitoring your website on Google Analytics however is not feasible and is not the most productive use of your time. You can use Amigo Data to perform the task for you.
Let me show you in this brief tutorial how you can use Amigo Data to export Google Analytics data to Google Sheets, and automate the task of monitoring and analyzing your website performance.
Export Google Analytics Data to Google Sheets using Amigo Data
To get the most from the tutorial that follows, I’d recommend that you install the Amigo Data addon so that you can test it yourself as you follow along.
You can get the addon from Google Workspace Marketplace. Click install and give the necessary permissions.
Another way to get the addon is to open a new Google Sheets document. Then go to Extensions→Add-ons→Get add-ons. Search for Amigo Data and install.
Connecting Google Analytics to Amigo Data
Once the installation is complete, the Amigo Data add-on should appear in your Extensions menu.
Go to Extensions→Amigo Data→Connect. Then choose Google Analytics from the list of sources, name your connection (or leave the default as it is; you can change it later) and click Authorize. You’ll be redirected to an authorization page. Choose the Google account and give the necessary permissions.
If all goes well, you should see a new dashboard appear in your Google Sheets tab, as shown below.
You can either close this or continue from here to the next step.
Importing data from Google Analytics to Google Sheets
We can now start importing data from Google Analytics to Google Sheets.
Launch Amigo Data by going to Extensions→Amigo Data→Connect. Click the connection that you have created. (You can omit this step if you didn’t close the dashboard that popped up in the previous step.)
Now, follow the steps given in the infographic below to import the data from Google Analytics to Google Sheets.
Setting automatic refresh schedule
Amigo can refresh to report periodically–hourly, daily, weekly or on certain days of your choice–so that you do not have to export the report each time you want to share it with someone or save it to a spreadsheet. To do so, select or customize the time period and click Yes, set the refresh timing.
You can also set this up later. To edit the report or set the refresh schedule, expand the View Reports tab, set the options and switch the toggle. Then click Save & Run.
Amigo can also send you alerts on your email or Slack channel with snapshots of the report so that you don’t even have to open the spreadsheet to keep up to date with the performance of your website.
To set up alert, click Get Alerts→Add data alert and customise the alert, add the email(s) to which you want the alert sent and/or Slack channel(s). Once done, click Set Alert.
Amigo will send you a snapshot of the report periodically, and you always have the latest information wherever you are.
Amigo Data makes it super easy to export Google Analytics data to Google Sheets. And it gives you the option to import only those metrics that matters to you. It is useful in certain situations since it allows you to take specific actions and focus on a particular metric. Moreover, large datasets can sometimes be distracting and laborious to work with.
If you’re still here and haven’t had the add-on installed, get it here.
You can also use Amigo Data to export data from various other sources such as Google Ads, Facebook Ads, MySQL, and Snowflake among others. For tutorials on them and other Google Sheets guides, you can find them here.
Some related articles you may find useful: