How to import website data to Google Sheets

Copy/pasting data from your web analytics platform to Google Sheets can be a total nightmare. 

It’s boring, time-consuming, and you’re bound to copy data into the wrong cell at some point.

And that’s why today, I’m going to show you how to import your website data to Google Sheets.

Ready? Let’s go.

How to import website data to Google Sheets

Step 1: Install the Supermetrics add-on

To get started, you need to install the Supermetrics add-on for Google Sheets. You can find it on the add-ons menu in G Sheets → “Get add-ons” → “Supermetrics” → “Install.”

Or, you can install Supermetrics from the GSuite Marketplace.

Next, sign in with your Google account and give Supermetrics all the necessary permissions.

After that, you can find Supermetrics under “Add-ons” in your Google Sheets.

Here’s how to install the add-on.

Step 2: Get your website data into Google Sheets

Now that you have the add-on, let’s run your first query.

First, launch the Supermetrics sidebar. To do that, click on “Add-ons” → “Supermetrics” → “Launch sidebar”.

In the sidebar, you’ll see:

Data source: this allows you to choose the data source you want to pull data from. To pull website data, you can choose Google Analytics, HubSpot, or Adobe Analytics.

Select views: this lets you choose the Google Analytics view (or property) you want to get data from.

Select date: this is for setting  the date range for your data. You can either choose one of the preset dynamic date ranges or set your custom range.

Select metrics: here you can choose the metrics you want to add to your report.

Select dimensions: choose how you want to split your metrics.

Segments, filters, and options give you even more control over your data. For example, you can segment your traffic based on devices, sources, or browsers.

Or you can filter your data in descending order in the options section.

Once you’re happy with your query, click on “Get data to the table.” And when your query is done, your data will load to the spreadsheet.

In case you want to modify your query, simply click on any cell containing data from the query in question, and the sidebar will reopen. Then click on “Modify” to make any changes you want.

Watch how to run your first query:

Step 3: Set up automatic refreshes and triggers

If you want to analyze the same data points daily, weekly, or monthly, you can use Supermetrics to automate new data transfers to your Google Sheets.

To set up a trigger to your spreadsheet, go to “Add-ons” → “Supermetrics” → “Schedule refresh & emailing.” 

From here, you can choose how often you want to refresh your report (daily, weekly, or monthly) and whether you want an email notification when it happens.

Learn how to set up triggers:

Web analytics template for Google Sheets

Instead of spending hours building reports from scratch, you can swipe our ready-made template and tweak them to your needs.

Traffic equals opportunity. The more traffic you have to your website, the more chances you have to convert visitors into customers.

Analyzing your traffic will help you understand:

• How your website is performing in general
• What devices people use to visit your website
• What sources bring the most traffic
• What your top landing pages are

Get the Google Analytics 4 reporting template >>

No more copy/paste

Yaaas! We did it guys. We got rid of the most boring part of marketing reporting: manual data collection. 

Now it’s up to you to decide how you’ll analyze your data and what kinds of reports you want to build.

And if you want to feature your awesome reports in our marketing reporting template gallery, let me know on Twitter or LinkedIn.

Happy automating!