---
title: "How to use the APPEND_RESULTS setting in Google Sheets queries"
slug: "how-to-use-the-append-results-setting-in-google-sheets-queries"
description: "Learn how to use the APPEND_RESULTS setting in Google Sheets to pull historical data, manage headers, and refresh queries effectively."
updated: 2025-09-05T16:09:51Z
published: 2025-09-05T16:09:51Z
---

> ## 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 use the APPEND_RESULTS setting in Google Sheets queries

The APPEND_RESULTS setting can pull older historical data for Google Sheets queries that can’t use the Date dimension.

If your query can use the Date dimension, use the [Combine new results with old setting](/v1/docs/how-to-use-the-combine-new-results-with-old-setting-in-google-sheets) instead.

> [!NOTE]
> Important to note when using the APPEND_RESULTS setting
> 
> - This setting will remove the column and row headers. You need to manually add headers if needed and start the query under the headers. For example, if you add headers to row 1, start the query from row 2.
> - The first column will be the fetch date.
> - Every time you refresh the query, the results are added with today's date. This means if you refresh the query twice within the same day, the result rows will double
> - If you add the APPEND_RESULTS setting to an existing query, there will be an extra empty row. Because of this, we recommend adding this setting to new queries only. If needed, test the query before creating the final query and adding the setting.

## Instructions

The `APPEND_RESULTS` setting will add an additional column to the beginning of your query that indicates the fetch date.

1. In the Supermetrics sidebar, click **Create new query** and set up the query details.
2. If a **Date range** setting is available, set it to **Today**.
3. Navigate to the **Options** section.
4. In the **Advanced settings** field, type `APPEND_RESULTS`.
5. All refreshes after this point will append the data to the bottom of your existing data with a new Fetch date column.
6. Run the query.