> For the complete documentation index, see [llms.txt](https://docs.coupler.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coupler.io/destinations/categories/spreadsheets/google_sheets/faq/update-google-sheets-destination-without-data-overwriting.md).

# Update Google Sheets destination without data overwriting

### Table of contents

1. [How Coupler.io works](#id-1.-how-coupler.io-works)
2. [Using "Cell address" with data overwriting to the right](#id-2.-using-cell-address-with-data-overwriting-to-the-right)
3. [Using "Range" without data overwriting](#id-3.-using-range-without-data-overwriting)

#### 1. How Coupler.io works

Coupler.io can save data to Google Sheets in one of the following ways:

* overwrite all data to the right starting from the top-left cell specified (i.e., C1)
* insert data into the defined range (i.e., A1:H10)

#### 2. Using "Cell address" with data overwriting to the right

*Please use this approach in case you need to calculate something using imported data and your data source has no fixed number of columns.*

To use this approach, please follow the next steps:

1. Define the start cell to put the imported data in
2. Set up formulas in the columns on the left from the start cell
3. Set up Coupler.io importer:

![](https://s3.amazonaws.com/helpscout.net/docs/assets/57fbf3029033600277a688ab/images/68adc21470fbde707702f4f1/file-9Lt3ySZjh9.png)

Below is an example where we imported data from Airtable to Google Sheets' "raw data" sheet and left the first two columns empty. After that, we used formulas to populate the first two columns with the information from the "extra info" sheet. Please use this [link](https://docs.google.com/spreadsheets/d/1QbEf9D7hI5yk0oKi4X1jFlNWrvnM3vBSYJMh7_IikjA/edit?usp=sharing) to view this example in Google Sheets.

![](https://s3.amazonaws.com/helpscout.net/docs/assets/57fbf3029033600277a688ab/images/68aec7cd60ee3762fc6b6291/file-UM12Vbpm86.png)

#### 3. Using "Range" without data overwriting

*Please use this approach in case your data source has a fixed number of columns and you need to insert data in the middle of the sheet without erasing data to the left or to the right.*

To use this approach, please follow the next steps:

1. Define the data range to insert data into (i.e., *C1:E10*)
2. Prepare the destination file with data/formulas on the left and on the right from the range selected for the data import
3. Set up Coupler.io importer:

![](https://s3.amazonaws.com/helpscout.net/docs/assets/57fbf3029033600277a688ab/images/68aec8b1eb3bae0b8ffc5738/file-8yltTXAE3H.png)

In case you use the **Replace** mode with a defined data range, data will be inserted only to the cells from the range, both columns and rows.

In case you use the **Append** mode with a defined data range - data will be inserted into the columns from the range, but without limiting the rows.

**Supported ranges (formats):**

* A1:B4 - Replace mode: data will be added to defined cells, Append mode: all rows in the data source are added to columns A, B 
* 1:5 - Replace mode: 5 rows of source data are inserted starting from A1, Append mode: all source data is inserted starting from A1 if A1 is empty, or starting from the first empty cell below A1
* B1:10 - Replace mode: 10 rows will be added starting from the B1 cell (no limits for columns), Append mode: all available data source rows will be added starting from the B1 cell if it's empty, or from the first empty cell below B1
* 1:F10 - Replace mode: 10 rows will be added from the F1 cell, Append mode: no limits in rows, starting from cell F1 if it's empty, or from the first empty cell below F1
* A: D15 - Replace mode: no limits in rows, starting from A15 cell, Append mode: no limits in rows, starting from cell A15 if it's empty, or from the first empty cell below A15

**Please review several examples below:**

*Example 1:*

* Range: C1:F5
* Mode: *Replace*
* Source data: contains 20 rows and 10 columns

*Result:* data is inserted into the cells in range C1:F5 (so only 4 columns from 10 are imported, 5 rows from 20 are imported).

![](https://s3.amazonaws.com/helpscout.net/docs/assets/57fbf3029033600277a688ab/images/68aecfb49353e37c5f1bffdd/file-pyZLaH5NGV.png)

*Example 2:*

* Range: C1:F50
* Mode: *Append*
* Source data: contains 25 rows and 10 columns

*Result:* data is inserted into the cells in range C1:F50 (so only 4 columns from 10 are imported, but all 25 rows are imported). 

![](https://s3.amazonaws.com/helpscout.net/docs/assets/57fbf3029033600277a688ab/images/68aed199be6bb04528143c5d/file-N5EbrC2P85.png)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.coupler.io/destinations/categories/spreadsheets/google_sheets/faq/update-google-sheets-destination-without-data-overwriting.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.