Skip to main content

GSheet API wiki

Working with the Google Sheet API?

Please add your learnings, favorite links and gotchas here by editing this page.

Using GSheet with Nango

Google Sheets uses the same OAuth mechanism as other Google services. Please use the Google template for it in Nango: google
Follow our quickstart to add an OAuth integration with the Google Sheets API in 5 minutes.

App registration & publishing

Google's APIs all use the same OAuth service. To which APIs you get access is determined by the scopes that you request.

Please check the main Google OAuth API wiki here for details on how to register an OAuth app with Google.

API specific gotchas

  • While setting up the OAuth app, use the https://www.googleapis.com/auth/spreadsheets scope for extended capabilities