GSheet

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), go to Integrations -> Configure New Integration -> GSheet.

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

2. 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.

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

   cURL

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

   Node

   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.

4. 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
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
worksheets	Sync worksheets from a Google Sheets spreadsheet	Sync	🔗 Github

---