Google's Guide: https://developers.google.com/identity/protocols/oauth2/service-account
Authorization protocol: OAuth 2.0
This guide walks you through how to set up Google Sheets if you have already connected with another Google Service Account.
If you have not connected with another Google Service Account before, please see: Google Service Account - Sheets.
User Impersonation tokens
Google Service Accounts allow you to retrieve access tokens for any user in a G Suite / Google Workspace account with user impersonation. To get tokens for a specific user, use the
provider_user_idquery parameter in the Get User Connection API call. See Retrieve user tokens for more information.
- In the Xkit platform, click "New Connector" in the sidebar.
- Click "Google Sheets Service Account".
- In the Google Cloud Platform, use the sidebar to go to the "API & Services" dashboard
- Click "+ ENABLE APIS AND SERVICES".
- Search "Google Sheets" and click on it.
- Click "ENABLE".
- Return to the Xkit Google Sheets Service Account connector page.
- Adjust Catalog Settings fields to customize how the connector will appear to users and click "Save".
- Select the requested Scopes and click "Save".
You've now successfully connected Google Sheets Service Account with Xkit!
You'll note that the
https://www.googleapis.com/auth/admin.directory.user.readonly scope is required in order to use Google Service Accounts.
Supplying this scope gives you read-only access to the Directory API of the Admin SDK. In order to retrieve tokens for each individual user in a Google Workspace / G Suite organization, you need to:
- Enable the Admin SDK for your application in the developer console
- Call the List Users endpoint to get a list of all users in an organization
- Use each user's email address in the
provider_user_idquery parameter in the Get User Connection API to retrieve an access token for each user
Each individual access token will enable you to impersonate the specific user.
Updated almost 2 years ago