Connect your Google Analytics to Spreadsheets

• Google Sheets
• Microsoft Excel

​

Why use Superjoin’s Google Sheets-Google Analytics Integration?

Quick and Easy Integration

We’ve meticulously organized the data points to ensure easy accessibility in a format you’re already familiar with.

Preview your imports visually

Get a sneak peek of your data. Select columns, apply filters & limits as per your need before importing.

Automatic Refreshes

Enjoy one-click refreshes or schedule regular updates to ensure your sheets are always up to date.

Power of Google Sheets

Benefit from Google Sheets’ collaborative data analysis & other powerful capabilities.

​

Step-by-step walkthrough: How to connect Google Analytics to Google Sheets.

1

Get Add-ons

Select Add-ons and choose Get Add-ons. This action will redirect you to the Google Workspace Marketplace.

2

Search Superjoin

In the Google Workspace Marketplace pop-up window, search for “Superjoin”.

3

Click on Install

Click on Extensions from the Google Sheets menu.

Note: For the best experience, install Superjoin where there’s only a single account logged in the Chrome profile.

4

Launch Superjoin

Once installed, navigate back to the Extensions menu tab in Google Sheets. Launch Superjoin from here. You should now see Superjoin running as a side panel on the right side of your screen.

5

Pick Google Analytics

Click on “Connect new Source” and select Google Analytics from the list of available data sources.

6

Connect your account

7

Select filters

Select the filters that you want to apply to filter down the data that you want to work on.

8

Click Import

Now simply click on the “Import” button to bring this selected data into your Google Sheets.

9

Data pulled! Setup an auto-refresh schedule.

Superjoin lets you refresh your imported data instantly with one click or set it to auto-refresh on a pre-set schedule. This way, you won’t need to manually update your Google Analytics data in Google Sheets to reflect changes from the source.

​

Why use Superjoin’s Excel-Google Analytics Integration?

Quick and Easy Integration

We’ve meticulously organized the data points to ensure easy accessibility in a format you’re already familiar with.

Preview your imports visually

Get a sneak peek of your data. Select columns, apply filters & limits as per your need before importing.

One-Click Refreshes

Enjoy one-click refreshes to ensure your sheets are always up to date.

Power of Microsoft Excel

Benefit from Microsoft Excel’s powerful data analysis & visualization capabilities.

​

Step-by-step walkthrough: How to connect Google Analytics 4 to Microsoft Excel

1

Launch Add-ins

Click on Add-ins on the right side of the Excel toolbar.

2

Get Add-in

Click on the searchbar and type “Superjoin”. The results would show our add-in under the More search results section.

3

Authenticate with your Microsoft Account

Once Superjoin launches as a side panel, just click on Sign in with Microsoft and follow the steps to authenticate your Microsoft Office account with Superjoin.

4

Launch Superjoin

You should now see Superjoin running as a side panel on the right side of your screen.

5

Navigate to Queries

To begin, you can navigate to Queries, choose to Create new query.

6

Connect a New Source

Navigate to Sources, select Connect to a new source and search for Google Analytics.

7

Link Account

Click on the Connect button and follow the on-screen instructions to link your Google Analytics account.

8

Choose Account

Select your Google Analytics 4 property and view that you want to import data from.

9

Configure Data Selection

After connecting your account, a data preview window will appear, allowing you to select metrics and dimensions, apply date ranges, and set various filters to refine your Google Analytics data.

10

Import Data

Once you’ve configured your data selection, click the “Import” button to bring your Google Analytics data into Microsoft Excel.

11

Refresh Data

Your data has been imported successfully! You can refresh your data at any time by clicking the refresh button in the Superjoin panel.

Hope this guide helped you pull data from your Google Analytics to your spreadsheet.

If you have any further doubts, please don’t hesitate to reach out to our support team [email protected]. Thank you!