---
title: "How to add and remove data source accounts and data source connections in Google Sheets"
slug: "how-to-add-and-remove-data-source-accounts-and-data-source-connections-in-google-sheets"
description: "Learn how to add and remove data source accounts and connections in Supermetrics for Google Sheets with this comprehensive step-by-step guide."
updated: 2026-05-08T07:09:12Z
published: 2026-05-08T07:09:12Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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 ![Icon representing a document with a graph, indicating Supermetrics queries in Google Sheets sidebar.](https://cdn.document360.io/a13cead5-eaae-456f-9bd1-0941d590c0e3/Images/Documentation/google-sheets-queries-tab-icon.png) **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](/v1/docs/about-data-source-accounts).
5. Add the account names.

### Remove data source accounts

1. Open the Supermetrics sidebar in Google Sheets.
2. Go to the ![Icon representing a document with a graph, indicating Supermetrics queries in Google Sheets sidebar.](https://cdn.document360.io/a13cead5-eaae-456f-9bd1-0941d590c0e3/Images/Documentation/google-sheets-queries-tab-icon.png) **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](/v1/docs/about-data-source-accounts).
5. Click the **Cross (X) icon** next to an account name to remove it.Make sure that **ALL ACCOUNTS** is not selected. ![Supermetrics Ads interface showing data source selection and account options for queries, All accounts option marked with X.](https://cdn.document360.io/a13cead5-eaae-456f-9bd1-0941d590c0e3/Images/Documentation/google-sheets-all-accounts-setting.png)

### Add data source connections

1. Open the Supermetrics sidebar in Google Sheets.
2. Go to the ![A simple diagram illustrating connections between three nodes, indicating data source connections in Supermetrics sidebar in Google Sheets.](https://cdn.document360.io/a13cead5-eaae-456f-9bd1-0941d590c0e3/Images/Documentation/google-sheets-data-sources-tab-icon.png) **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 ![A simple diagram illustrating connections between three nodes, indicating data source connections in Supermetrics sidebar in Google Sheets.](https://cdn.document360.io/a13cead5-eaae-456f-9bd1-0941d590c0e3/Images/Documentation/google-sheets-data-sources-tab-icon.png) **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. ![Manage connection with Supermetrics, including removal option and shared connections.](https://cdn.document360.io/a13cead5-eaae-456f-9bd1-0941d590c0e3/Images/Documentation/google-sheets-remove-connection.png)

You can also [manage your data source connections on the Supermetrics Hub](/v1/docs/how-to-manage-data-source-connections-on-supermetrics-hub), including removing and reconnecting data source connections.