GSheet - Nango Docs

🚀 Quickstart

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

Create an integration

In Nango (free signup), go to Integrations -> Configure New Integration -> GSheet.

Nango has credentials you can use for testing. Activate them in the dashboard.

Authorize GSheet

Go to Connections -> Add Test Connection -> Authorize, then log in to GSheet. Later, you’ll let your users do the same directly from your app.

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 secret key, integration ID, and connection ID:

cURL
Node

curl "https://api.nango.dev/proxy/v4/spreadsheets/{sheetId}" \
  -H "Authorization: Bearer <NANGO-SECRET-KEY>" \
  -H "Provider-Config-Key: <INTEGRATION-ID>" \
  -H "Connection-Id: <CONNECTION-ID>"

Install Nango’s backend SDK with npm i @nangohq/node. Then run:

import { Nango } from '@nangohq/node';

const nango = new Nango({ secretKey: '<NANGO-SECRET-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 or API.

The {sheetId} in the URL represents the ID of the spreadsheet to retrieve.

✅ You’re connected! Check the Logs tab in Nango to inspect requests.

Implement Nango in your app

Follow our Auth implementation guide to integrate Nango in your app.To obtain your own production credentials, 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
Register an OAuth app with Google and obtain credentials to connect it to Nango

Official docs: Google Sheets API

🧩 Pre-built syncs & actions for Google Sheets

Enable them in your dashboard. Extend and customize to fit your needs.

Developer Metadata

Function name	Description	Type	Source code
`search-developer-metadata`	Search developer metadata by criteria	Action	🔗 Github

Sheets

Function name	Description	Type	Source code
`append-values-to-spreadsheet`	Append values to the end of a spreadsheet table	Action	🔗 Github
`copy-sheet`	Copy a sheet to another spreadsheet	Action	🔗 Github
`create-column`	Insert a new column into a sheet	Action	🔗 Github
`get-values`	Get values from a spreadsheet range	Action	🔗 Github
`upsert-row`	Append or update a row of values in a Google Sheet	Action	🔗 Github
`sync-rows`	Sync worksheet rows from a Google Sheet	Sync	🔗 Github

Spreadsheets

Function name	Description	Type	Source code
`batch-get-values`	Get values from multiple ranges	Action	🔗 Github
`batch-update-spreadsheet`	Apply multiple updates to a spreadsheet in a single request	Action	🔗 Github
`create-spreadsheet-row`	Insert a new row at a given index in a Google Sheet	Action	🔗 Github
`create-spreadsheet`	Create a new spreadsheet	Action	🔗 Github
`get-spreadsheet-by-data-filter`	Get spreadsheet data matching data filters	Action	🔗 Github
`update-conditional-format-rule`	Update or move a conditional format rule	Action	🔗 Github
`update-values`	Update values in a spreadsheet range	Action	🔗 Github

Values

Function name	Description	Type	Source code
`batch-clear-values-by-data-filter`	Clear values from ranges matching data filters, preserving formatting	Action	🔗 Github
`batch-clear-values`	Clear values from one or more ranges in a spreadsheet, preserving formatting	Action	🔗 Github
`batch-get-values-by-data-filter`	Get values from ranges matching data filters	Action	🔗 Github
`clear-values`	Clear values from a range, preserving formatting	Action	🔗 Github

Worksheets

Function name	Description	Type	Source code
`delete-worksheet`	Delete a worksheet by name from a Google Spreadsheet	Action	🔗 Github
`sync-worksheets`	Sync worksheets from a Google Sheets spreadsheet	Sync	🔗 Github

700+ APIs & Integrations

​🚀 Quickstart

​📚 Google Sheets Integration Guides

​🧩 Pre-built syncs & actions for Google Sheets

​Developer Metadata

​Sheets

​Spreadsheets

​Values

​Worksheets

🚀 Quickstart

📚 Google Sheets Integration Guides

🧩 Pre-built syncs & actions for Google Sheets

Developer Metadata

Sheets

Spreadsheets

Values

Worksheets