System updates
Get started
Connect data
Build reports
Data sources
Manage teams
Transform data
- Data blending
- Custom fields
Google Sheets
Looker Studio
Excel
Power BI
- Set up Supermetrics for Power BI
- Using Supermetrics in Power BI
  - How to add images to Power BI reports
  - How to customize data loaded to your Power BI report
- Power BI troubleshooting
Data warehouses and cloud storage
- Set up Supermetrics for data warehouses and cloud storage
- Prerequisites and configuration for data warehouse and data lake destinations
  - AlloyDB
  - Amazon S3
  - Azure SQL Database
  - Azure Storage
  - Azure Synapse
  - BigQuery
  - Google Cloud Storage
  - Redshift
  - Snowflake
  - SFTP servers
  - BigQuery (marketplace)
- Transfers
- Monitoring
  - How to monitor your data warehouse transfers on the Supermetrics Hub
  - How to monitor your BigQuery (marketplace) data transfers
- Table Manager
- Data integrations troubleshooting
  - How to refresh account list in data warehouse destinations and Query Manager (API)
  - How to fix the “Confirm logout: Cannot execute query” error
Supermetrics Storage
- Using Supermetrics Storage
The Supermetrics API and Query Manager
- Using the Supermetrics API

How to install Supermetrics in Google Sheets

Supermetrics Support Site Team

Modified on: Mon, 22 Jul, 2024 at 4:00 PM

The first step in importing your data to Google Sheets with Supermetrics is to install the add-on.

Note

If you see a message saying that the Supermetrics add-on isn't allowed, get in touch with your organization's Google Workspace administrator for help. Follow Google's instructions to learn more about app installation issues and how to solve them.

Instructions

Open Supermetrics in the Google Workplace Marketplace.
Click Install.
Click Continue.
Sign in with the Google Account you want to use with Supermetrics.
Click Allow to give Supermetrics the permissions it needs to work.
Review our security and data privacy policy if you’d like to learn more about how we keep the data you process with us secure.
Open Google Sheets.
Navigate to Extensions → Supermetrics → Launch to open the Supermetrics sidebar.

Next steps

Set up a Supermetrics query in Google Sheets.