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:
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/spreadsheetsscope for extended capabilities