# Google Sheets

Google Sheets is Google's cloud-based spreadsheet application. By connecting Google Sheets to Coupler.io as a **source**, you can automatically export data from your spreadsheets to any supported destination — including other spreadsheets, BI tools, databases, and AI tools — on a schedule, without manual exports or copy-pasting.

Coupler.io's Google Sheets integration connects via **Google OAuth** and lets you pull data from one or more sheets in a spreadsheet, merge data across multiple sheets, and use regex patterns to automatically include new sheets as they appear.

## Why connect Google Sheets to Coupler.io?

* **Consolidate spreadsheet data** — Merge data from multiple sheets or multiple spreadsheets into a single destination for unified reporting and analysis.
* **Automate recurring exports** — Schedule data transfers so your reports, dashboards, and data pipelines stay current without manual intervention.
* **Use regex-based sheet matching** — Automatically include new sheets that match a naming pattern (e.g., `Sales 2026.+`) without updating your data flow every time a new sheet is added.
* **Flexible destinations** — Export to AI tools, Google Sheets, Excel, BigQuery, Looker Studio, or other supported destinations.

## Prerequisites

Before connecting, make sure you have:

* A **Google account** with access to the Google Sheets spreadsheet(s) you want to export
* A Coupler.io account

{% hint style="info" %}
The Google account you connect must have at least **Viewer** access to the spreadsheet. If you need to export from a shared spreadsheet, make sure the spreadsheet has been shared with your Google account before connecting.
{% endhint %}

## Quick start

{% hint style="success" %}
Start by selecting a single sheet and using `A:Z` as the range — this exports all columns and all existing rows, including any new rows added in the future. If you need to merge data from multiple sheets with the same structure, select all of them: Coupler.io will stitch the data by column headers and add a **Sheet Name** column so you can identify the source of each row.
{% endhint %}

## How to connect

{% stepper %}
{% step %}
In Coupler.io, create a new **data flow** and select **Google Sheets** as the source.
{% endstep %}

{% step %}
Click **Connect** and sign in with your Google account. Grant Coupler.io permission to access your Google Drive and Sheets data.
{% endstep %}

{% step %}
Select the **spreadsheet** from your Google Drive and choose one or more **sheets** to export from. Alternatively, enter a **regex pattern** to match sheets by name.
{% endstep %}

{% step %}
Set the **Range** for each selected sheet (e.g., `A:Z` to export all columns and rows, or `A1:Z100` for a fixed range).
{% endstep %}

{% step %}
Choose your **destination** and run the import.
{% endstep %}
{% endstepper %}


---

# Agent Instructions: 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/sources/category/files-and-tables/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.