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