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.
Useful links​
API specific gotchas​
- While setting up the OAuth app, use the
https://www.googleapis.com/auth/spreadsheets
scope for extended capabilities