---
title: "How to add all accounts to a Google Sheets query"
slug: "how-to-add-all-accounts-to-a-google-sheets-query"
description: "Learn how to add all data source accounts to your Google Sheets query."
updated: 2025-06-26T16:24:38Z
published: 2025-06-26T16:24:38Z
---

> ## 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 all accounts to a Google Sheets query

You can add all your accounts in one data source — every account the logged-in user has access to — in the query’s results.

This feature is available in:

- Google Ads
- Google Analytics 4
- Microsoft Advertising

To activate this feature, open the Supermetrics sidebar and find the query using these data sources. Scroll down to the **Select accounts** section (labeled **Select properties** in Google Analytics 4) and add **All accounts** in the account list field.

If you’re using this feature with Google Ads, you can also add EXCLUDE_INVALID_ACCOUNTS to any query. This will make sure your queries run even if your account list includes any [inactive Google Accounts](/v1/docs/google-ads-permissions-troubleshooting-guide).