Skip to main content
  • 🚀 Quickstart
  • 🧑‍💻 OAuth app setup
  • 🚨 API gotchas
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
  • 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>"
Or fetch credentials dynamically via 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.
Next step: Embed the auth flow in your app to let your users connect their GSheet accounts.
Questions? Join us in the Slack community.