![]() ![]() 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.Authentication can be used in Google Sheets to ensure that the solution will continue running even if individual users' permissions change.Service accounts present numerous benefits: ![]() A service account is a special type of Google account that is associated with your Google Cloud Project that can be used to run API requests on your behalf. Service Account in Google Sheets connector is used to authenticate to Google Sheets using a Google Cloud service account. Your Google account should have Edit permission to all spreadsheets that you will use in Workato. Private key (Applicable only to Service Account Auth)Īdvanced settings (Applicable only to Service Account Auth)Ĭonnecting to Google Sheets connector is as simple as signing in to the Google account. GCP Project service account email (Applicable only to Service Account Auth) You can automatically collect and insert data from several online sources. It can be accessed from anywhere even your Android or iOS devices. As you know, this makes sharing and collaborating with others a breeze. Give this Google Sheets connection a unique name that identifies which Google Sheets instance it is connected to.Ĭhoose OAuth 2.0 when using a user account and Service Account when using a service account to connect to Google Sheets. Google Sheets is 100 free and comes together with Drive, Docs, and Slides. For production use cases, we highly recommend service account authentication. Connecting via Service Account allows you to authenticate your Google Sheet connection without tying the connection to a specific person in your organisation. ![]()
0 Comments
Leave a Reply. |