Follow these steps to connect your Shopify data to Supermetrics and use your data in any of our data destinations — Google Sheets, Looker Studio, Excel, data warehouses, and Power BI, as well as the Supermetrics API. You can also connect to data sources from the Supermetrics Hub.
You can share your data source connection with your team and use the connection across all data destinations you use with Supermetrics. Learn more about shared connections.
Before you begin
There are two ways to connect Supermetrics to Shopify:
- From your Shopify store
This is the recommended way of connecting your Shopify store to Supermetrics with an easy-to-follow guided setup. - From your data destination
You can also go to your data destination and connect to Shopify from there.
Check below the prerequisites for account types and permissions related to Shopify and store connections.
Three types of Shopify accounts can connect to Supermetrics:
- Store owner
- This role has full access once it's connected to Supermetrics
- Staff
- See "Granting permissions" to learn about the permissions this role requires
- Collaborator (Shopify partner)
You can confirm a store's owner by logging into Shopify and navigating to Settings → Users and permissions. You'll see the store owner's name at the top of the page.
Collaborators have to follow a different set of instructions to connect. Learn how to connect a Shopify collaborator or partner account to Supermetrics.
Shopify store owners can add staff to their Shopify store. Learn how to add a new staff account or edit permissions for an existing staff account, including giving them permission to use apps like Supermetrics.
- To give a staff account access to Supermetrics, open the Permissions menu in Shopify, and then click Apps and channels. Supermetrics should be listed with any other apps linked to the store.
- While all store owners can link new apps to a store, staff members need specific permissions ("Manage and install apps and channels" and "Approve app charges").
- Additionally, owners must grant each staff or collaborator account these permissions before they can connect to Supermetrics:
- Home
- Orders
- Draft orders
- Products
- Gift cards
- Customers
- Reports
- Dashboards
- Marketing
- Discounts
If you want to pull data for multiple Shopify stores, you'll need to repeat the authentication process for each one.
Once you've completed authentication for your first store, reauthenticate your connection using the name of your second store. Repeat this process for each store.
Instructions
Connect to Supermetrics from Shopify
It's recommended to connect to Supermetrics from your Shopify store. This method offers an easy-to-follow guided setup.
Step 1: Install Supermetrics app to your Shopify store
- Find Supermetrics in the Shopify app store. Supermetrics is available in the Store Management category.
- Click Add app.
- Review the permissions, and click Install app.
After installation, the Supermetrics app shows in the left sidebar under Apps.
Step 2: Create connection to your Supermetrics team
- Go to the Supermetrics app in your Shopify store.
- Click Create or refresh a connection.
- Login to your Supermetrics account.
- Select the team you want to connect to Shopify with, and click Continue.
- Click Back to Shopify.
Step 3: Connect Shopify to your data destination
- Select your data destination (Google Sheets, Looker Studio, or Excel) from the list of reporting platforms.
- Follow the instructions for your data destination.
If you need to refresh your connection and reauthenticate, click Create or refresh a connection in your Supermetrics app.
Connect to Shopify from your data destination
Follow these instructions to connect to Shopify from Google Sheets, Looker Studio, Excel, data warehouse destinations, Power BI, and the Supermetrics API. You can also connect to Shopify from the Supermetrics Hub.
Make sure you've installed the Supermetrics add-on before you connect.
- Open a new Google Sheets file.
- Navigate to Extensions → Supermetrics → Launch sidebar to open Supermetrics.
- Click Create new query.
- Under Data source, select Shopify.
- Choose to make this connection shared or private.
- You'll be asked to install our app the first time you connect. Click Install app to proceed.
- Enter your store's name. The store name is the first part of the store's URL. For example, for mystorename.myshopify.com the store name is 'mystorename'.
- Click Start.
- Enter your email, click Next, enter your password, and click Log in.
- Select the accounts you want to include in your reporting.
Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Google Sheets.
Make sure you've connected Supermetrics to Looker Studio before following the steps below.
- Open the Supermetrics Looker Studio data source gallery.
- Navigate to Shopify and click Start free trial.
- You'll see two buttons saying Authorize. If you're using Supermetrics for the first time, click the left-hand one and log in with the Google Account you use with Supermetrics.
- Once that's done, or if you've done it before, click the right-hand Authorize button (under "Shopify requires authorization to connect to data").
- Select the team with the connection you want to use with Shopify.
- Choose to make this connection shared or private.
- You'll be asked to install our app the first time you connect. Click Install app to proceed.
- Enter your store's name. The store name is the first part of the store's URL. For example, for mystorename.myshopify.com the store name is 'mystorename'.
- Click Start.
- Enter your email, click Next, enter your password, and click Log in.
- Select the accounts you want to include in your reporting.
- Scroll down to the bottom of the page. To create a report with our template, select Use report template for new reports. To create a blank report, deselect this option.
- In the pane's top right, click Connect.
- Click Create report.
- Click Add to report.
Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Looker Studio.
Make sure you've installed the Supermetrics add-on before you connect.
- Open an Excel file.
- Click Data → Show Supermetrics.
- Under Data source, select Shopify.
- Choose to make this connection shared or private.
- You'll be asked to install our app the first time you connect. Click Install app to proceed.
- Enter your store's name. The store name is the first part of the store's URL. For example, for mystorename.myshopify.com the store name is 'mystorename'.
- Click Start.
- Enter your email, click Next, enter your password, and click Log in.
- Select the accounts you want to include in your reporting.
Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Excel.
Follow these instructions to set up a transfer with Supermetrics for BigQuery (marketplace). See the instructions below for other data warehouse destinations.
Set up transfer for BigQuery (marketplace)
Make sure you've enrolled the data source before you connect.
- Log in to the Google Cloud Platform.
- Navigate to BigQuery → Data transfers.
- Click + Create transfer.
- Select the Shopify data source.
- Fill in the transfer details. See detailed instructions on how to set up a transfer.
- Under Third-party connection, click Connect source.
- Accept the agreement.
- Click Authorize with Shopify.
- You'll be asked to install our app the first time you connect. Click Install app to proceed.
- Enter your store's name. The store name is the first part of the store's URL. For example, for mystorename.myshopify.com the store name is 'mystorename'.
- Click Start.
- Enter your email, click Next, enter your password, and click Log in.
- Select the accounts you'd like to include in your reporting and define the transfer settings.
- Click Submit.
- Click Save.
Set up data warehouse transfer on the Supermetrics Hub
Make sure you've set up a data warehouse destination before you connect.
- Log in to the Supermetrics Hub.
- In the left-side menu, under Export, go to Data warehousing → Transfers.
- Click Create new.
- Select the Shopify data source, and click OK.
- Fill in the transfer details. See detailed instructions on how to set up a transfer.
- In the Connections section, click Add new connection.
- You'll be asked to install our app the first time you connect. Click Install app to proceed.
- Enter your store's name. The store name is the first part of the store's URL. For example, for mystorename.myshopify.com the store name is 'mystorename'.
- Click Start.
- Enter your email, click Next, enter your password, and click Log in.
- In the transfer setup view, select the accounts you'd like to include in your reporting.
- Click Create transfer.
- Log in to the Supermetrics Hub.
- In the left-side menu, under Export, click Power BI.
- Click Select data source.
- Select the Shopify data source.
- You'll be asked to install our app the first time you connect. Click Install app to proceed.
- Enter your store's name. The store name is the first part of the store's URL. For example, for mystorename.myshopify.com the store name is 'mystorename'.
- Click Start.
- Enter your email, click Next, enter your password, and click Log in.
- Fill in the query details.
- Click Run query to test your query.
- Log in to the Supermetrics Hub.
- In the left-side menu, under Transform, click Query Manager (API).
- Select for Supermetrics API from the dropdown menu next to the page title.
- Click Select data source.
- Select the Shopify data source.
- You'll be asked to install our app the first time you connect. Click Install app to proceed.
- Enter your store's name. The store name is the first part of the store's URL. For example, for mystorename.myshopify.com the store name is 'mystorename'.
- Click Start.
- Enter your email, click Next, enter your password, and click Log in.
- Fill in the query details. See detailed instructions on how to set up a Supermetrics API query in Query Manager.
- Click Run to test your query.
- Log in to the Supermetrics Hub.
- In the left-side menu, select Connect → Data sources.
- Scroll down to the list of data sources you haven't connected to. You see this list below your existing connections, under the title Connect to new data source.
- Hover over the Shopify data source, and click Connect.
- You'll be asked to install our app the first time you connect. Click Install app to proceed.
- Enter your store's name. The store name is the first part of the store's URL. For example, for mystorename.myshopify.com the store name is 'mystorename'.
- Click Start.
- Enter your email, click Next, enter your password, and click Log in.
More resources
- Shopify: Query setup guide
- Shopify permissions guide
- How to edit the time zone for a Shopify query
- How to reauthenticate a data source in Looker Studio, Google Sheets, or Excel
- How to reauthenticate a data source in data warehouse, API, or cloud storage platform
- How to manage data source connections on the Supermetrics Hub