> 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.md).

# Google Sheets

Google Sheets is a cloud-based spreadsheet tool that lets you store, organize, and analyze data in your browser. As a Coupler.io destination, it's one of the most popular places to send data — great for building reports, dashboards, and automated data backups without any engineering work.

## Why use Google Sheets as a destination?

* **No setup overhead** — connect with a single OAuth sign-in and start sending data in minutes
* **Works with any Coupler.io source** — from Airtable and HubSpot to Facebook Ads and Salesforce, any source can flow into Google Sheets
* **Flexible write modes** — replace your data on every run for up-to-date reports, or append rows to build a running history
* **Formulas stay intact** — control exactly which cells Coupler.io writes to, so your formulas and formatting in adjacent columns are preserved
* **Dynamic sheet names** — use macros to auto-create a new sheet on every run (e.g., one sheet per day)

## Prerequisites

* A Google account with access to Google Sheets
* The destination spreadsheet must already exist, or Coupler.io will create a new sheet tab inside an existing file
* Your Google account must have edit access to the destination spreadsheet

## Quick start

{% hint style="success" %}
If you just want to get data flowing fast, connect your Google account, pick an existing spreadsheet, and run the data flow. You can fine-tune cell ranges and write modes after your first successful run.
{% endhint %}

## How to connect

{% stepper %}
{% step %}
**Add a source to your data flow.** In Coupler.io, create a new data flow and configure your source — this can be any supported integration like Airtable, HubSpot, Facebook Ads, or any other source. You can add multiple sources to a single data flow.
{% endstep %}

{% step %}
**Select Google Sheets as your destination.** In the Destination section of your data flow, choose Google Sheets from the list of available destinations.
{% endstep %}

{% step %}
**Connect your Google account.** Click **Connect** and sign in with the Google account that has access to your destination spreadsheet. Review the requested permissions (Coupler.io needs access to read and write spreadsheet data) and approve them. Once authorized, the connection is saved for future data flows.
{% endstep %}

{% step %}
**Select your spreadsheet and sheet tab.** Use the dropdown to pick an existing spreadsheet from your Google Drive. Then select the sheet tab where data should land — or type a new tab name and Coupler.io will create it automatically on first run.
{% endstep %}

{% step %}
**Run your data flow.** Click **Run** to execute your first manual import. Once it completes successfully, your data will appear in the destination sheet. You can then review the results and set up a schedule.
{% endstep %}
{% endstepper %}

## Supported features

| Feature                   | Supported |
| ------------------------- | --------- |
| Replace mode              | Yes       |
| Append mode               | Yes       |
| Automatic scheduling      | Yes       |
| Type enforcement          | No        |
| Dynamic sheet name macros | Yes       |
| Templates                 | Yes       |
| Cell range targeting      | Yes       |


---

# 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:

```
GET https://docs.coupler.io/destinations/categories/spreadsheets/google_sheets.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.