> ## Documentation Index
> Fetch the complete documentation index at: https://nango.dev/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Sheets

> Integrate your application with the Google Sheets API

## 🚀 Quickstart

Connect to Google Sheets with Nango and see data flow in 2 minutes.

**1. Create an integration**

In Nango ([free signup](https://app.nango.dev)), go to [Integrations](https://app.nango.dev/dev/integrations) -> *Configure New Integration* -> *Google Sheets*.

> [!NOTE]
>
> Nango has a [Nango-managed OAuth app](https://nango.dev/docs/guides/auth/auth-guide.md#nango-managed-oauth-apps) you can use in development and production. Select it when you create the integration.

**2. Authorize Google Sheets**

Go to [Connections](https://app.nango.dev/dev/connections) -> *Add Test Connection* -> *Authorize*, then log in to Google Sheets. Later, you'll let your users do the same directly from your app.

**3. Call the Google Sheets API**

Let's make your first request to the Google Sheets API (fetch a specific spreadsheet). Replace the placeholders below with your [Environment API key](https://nango.dev/docs/reference/backend/http-api/api-keys.md), [integration ID](https://app.nango.dev/dev/integrations), and [connection ID](https://app.nango.dev/dev/connections):

> [tab] cURL
>
> ```bash theme={null}
> curl "https://api.nango.dev/proxy/v4/spreadsheets/{sheetId}" \
>   -H "Authorization: Bearer <NANGO-API-KEY>" \
>   -H "Provider-Config-Key: <INTEGRATION-ID>" \
>   -H "Connection-Id: <CONNECTION-ID>"
> ```

> [tab] Node
>
> Install Nango's backend SDK with `npm i @nangohq/node`. Then run:
>
> ```typescript theme={null}
> import { Nango } from '@nangohq/node';
>
> const nango = new Nango({ apiKey: '<NANGO-API-KEY>' });
>
> const res = await nango.get({
>     endpoint: '/v4/spreadsheets/{sheetId}',
>     providerConfigKey: '<INTEGRATION-ID>',
>     connectionId: '<CONNECTION-ID>'
> });
>
> console.log(JSON.stringify(res.data, 2, null));
> ```

Or fetch credentials with the [Node SDK](https://nango.dev/docs/reference/backend/backend-sdk/node.md#get-a-connection-with-credentials) or [API](https://nango.dev/docs/reference/backend/http-api/connections/get.md).

> [!NOTE]
>
> The `{sheetId}` in the URL represents the `ID` of the spreadsheet to retrieve.

✅ You're connected! Check the [Logs](https://app.nango.dev/dev/logs) tab in Nango to inspect requests.

**4. Implement Nango in your app**

Follow our [Auth implementation guide](https://nango.dev/docs/guides/primitives/auth.md) to integrate Nango in your app.

To use your own OAuth app instead of the Nango-managed one, follow the setup guide linked below.

## 📚 Google Sheets Integration Guides

Nango maintained guides for common use cases.

* [How to register your own Google Sheets OAuth app](https://nango.dev/docs/api-integrations/google-sheet/how-to-register-your-own-google-sheet-api-oauth-app)\
  Register an OAuth app with Google and obtain credentials to connect it to Nango

* [Google App & Security Review](https://nango.dev/docs/api-integrations/google-shared/google-security-review)
  Pass Google's OAuth app verification to go to production with your own OAuth app (not needed with the Nango-managed app)

Official docs: [Google Sheets API](https://developers.google.com/sheets/api/reference/rest)

## 🧩 Pre-built syncs & tools for Google Sheets

Explore Nango-provided tools in your dashboard. Extend and customize them to fit your needs.

### Sheets

| Function name | Description | Type |
| - | - | - |
| `rows` | Sync worksheet rows from a Google Sheet | [Sync](https://nango.dev/docs/guides/functions/syncs/sync-functions.md) |

### Worksheets

| Function name | Description | Type |
| - | - | - |
| `worksheets` | Sync worksheets from a Google Sheets spreadsheet | [Sync](https://nango.dev/docs/guides/functions/syncs/sync-functions.md) |

### Others

| Function name | Description | Type |
| - | - | - |
| `append-values-to-spreadsheet` | Append values to the end of a spreadsheet table | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `batch-clear-values-by-data-filter` | Clear values from ranges matching data filters, preserving formatting | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `batch-clear-values` | Clear values from one or more ranges in a spreadsheet, preserving formatting | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `batch-get-values-by-data-filter` | Get values from ranges matching data filters | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `batch-get-values` | Get values from multiple ranges | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `batch-update-spreadsheet` | Apply multiple updates to a spreadsheet in a single request | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `clear-values` | Clear values from a range, preserving formatting | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `copy-sheet` | Copy a sheet to another spreadsheet | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `create-column` | Insert a new column into a sheet | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `create-spreadsheet-row` | Insert a new row at a given index in a Google Sheet | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `create-spreadsheet` | Create a new spreadsheet | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `delete-worksheet` | Delete a worksheet by name from a Google Spreadsheet | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `get-spreadsheet-by-data-filter` | Get spreadsheet data matching data filters | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `get-values` | Get values from a spreadsheet range | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `search-developer-metadata` | Search developer metadata by criteria | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `update-conditional-format-rule` | Update or move a conditional format rule | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `update-values` | Update values in a spreadsheet range | [Tool](https://nango.dev/docs/guides/functions/tools.md) |
| `upsert-row` | Append or update a row of values in a Google Sheet | [Tool](https://nango.dev/docs/guides/functions/tools.md) |

***


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.