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
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!
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.
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
@@TechinStudio Agree. It'd be nice if they accept PayPal.
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!
Wow that was very clear!
Glad it was helpful!
I have a rest API of salesforce and I want to push data from spreadsheet to that API, could someoe guide me?
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.
Is it only read access? What about writing and modifying the sheet?
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.
I have done those types of integrations already for different clients 😊
Good job!
Interesting stuff!
really handy for people who always work with excel files
atuação de milhões
Is there any reason you couldn't use Cloud Functions for this instead of Run?
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.
Would have been nice if they had shown you how to implement the code.
full code of the case is in the link in the description
They have to force the dialog
SAD
wow
Cute