Is there a tutorial, example or documentation of how one can make calls to Sheets API while developing locally? I CANNOT seem to figure it out. Interestingly enough, I am able to access Sheets data if I use Cloud Shell or deploy my application on Cloud Run, but all my attempts to do test locally have failed. FYI, I'm using gcloud SDK
Service account impersonation may be what you are looking for. In the document "Use service account impersonation" there is a section titled "Set up Application Default Credentials for using client libraries". I have used it to access Firestore from my local machine. It may work with the Sheets API too. Let us know how it goes!
Tune into our #AskGoogleCloud premiere on Friday, March 12 10AM PT for a chance to ask Google Cloud’s serverless experts any questions regarding serverless architectures → goo.gle/3tnTgOL Get $300 and start running workloads for free → goo.gle/3qbhDxS
Do you want to run this job unattended on a schedule? If so check out our video "Introducing Cloud Run Jobs" for a good way of doing it. Combine that with the code you see here for reading Google Sheets, and you'll be in a good starting place.
You can use the client library to write to sheets as well. We didn't include that because we wanted to keep the video short and simple. Search for "google sheets api" and you will find example code for writing.
Good point. We could just as easily have used Cloud Functions, or App Engine. Cloud Run, Cloud Functions, and App Engine are all serverless and work really well. Which one you use is largely personal preference.
