![]() ![]() You may do so from the Google Sheets UI by sharing the sheet with your Service Account's email. Lastly, since your service account does not have access to any sheets, you will need to explicitly share your Google Sheets which you need to run automations on. ![]() # Sharing required Google sheets with Service account Note that after you download the key file, you cannot download it again.Ĭopy the private key from -BEGIN PRIVATE KEY- to -END PRIVATE KEY-\n both inclusive and paste it as input on Workato. Next, this obtain private key (opens new window) and download the key in JSON format. To create a service account, follow this guide to create a new service account (opens new window) in your GCP project. Log in your Google Cloud Platform (GCP) console and enable the Google Sheets API in the API library (opens new window). Read more about service accounts here (opens new window). You may reduce the risks of 429 rate limit errors by requesting for quota increases directly from Google. Service accounts consume their own API quotas which can be managed through GCP.Service accounts have their own permissions so they may only access the Google sheets which are shared with them. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |