Google Workspace: Generate Token

Enable APIs

1. Go to the Google Developer Console.
2. Click Select a Project >> New Project. If you have an existing project, you can select it from ALL.

3. Provide valid values, and click Create.

4. Navigate to Dashboard, and click on ENABLE APIS AND SERVICES.

5. Search for Google Drive API and Google Sheets API, and click Enable.

Get a Client ID and Client Secret

1. Navigate to the tab OAuth consent screen and choose the valid option.

2. Enter the Application name and Authorized domains, and click Save.

3. Click Credentials tab >> Create Credentials, and OAuth client ID from the dropdown list.

4. In the Application type list, select Web Application.

5. Enter valid Name and Authorized Redirect URIs, and click Create.

6. Copy Client ID and Client Secret, and click OK.

7. Click OAuth 2.0 Client IDs, and get Client ID and Client Secret.

Generate Refresh Token

1. Go to the Google OAuth Playground
2. Click Settings icon.
3. Click Use your own OAuth credentials, and enter OAuth Client ID and OAuth Client secret generated in Get Client ID and Client Secret

4. Select Select & authorize APIs. Select the desired scope you want for your application and click on Authorize APIs. Required Scope:
   https://www.googleapis.com/auth/admin.directory.user
   https://www.googleapis.com/auth/admin.directory.domain
   https://www.googleapis.com/auth/admin.directory.group

5. Click on Exchange authorization code for tokens.

6. You’ll get the Authorization code, click on the Exchange authorization code for tokens button.
7. Copy Refresh Token.