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