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

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

No pre-built syncs or actions available yet.

Not seeing the integration you need? Build your own independently.

---