How to add and remove data source accounts and data source connections in Google Sheets

This guide will walk you through how to add and remove data source accounts and data source connections in Supermetrics for Google Sheets.

Instructions

Add data source accounts

1. Open the Supermetrics sidebar in Google Sheets.

2. Go to the Queries tab.

3. Click the edit icon on any query that uses the data source you want to add accounts to.

4. Navigate to the Select accounts dropdown. Note that this label might change depending on the data source you're using — in Google Analytics 4, for example, it reads Select properties. Learn more about data source account names.

5. Add the account names.

Remove data source accounts

1. Open the Supermetrics sidebar in Google Sheets.

2. Go to the Queries tab.

3. Click the edit icon on any query that uses the data source you want to remove accounts from.

4. Navigate to the Select accounts dropdown. Note that this label might change depending on the data source you're using — in Google Analytics 4, for example, it reads Select properties. Learn more about data source account names.

5. Click the Cross (X) icon next to an account name to remove it.Make sure that ALL ACCOUNTS is not selected.
   

Add data source connections

1. Open the Supermetrics sidebar in Google Sheets.

2. Go to the Data sources tab.

3. Click the chevron next to the data source's name.

4. Click + Add connection.

Remove data source connections

1. Open the Supermetrics sidebar in Google Sheets.

2. Go to the Data sources tab.

3. Click the chevron next to the data source's name.

4. Hover over the data source connection's name, and click the trashcan icon to remove the connection.

You can also manage your data source connections on the Supermetrics Hub. Learn more about how to remove and reconnect data source connections on the Hub.