Google Sheet
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Service ID
google_sheet | Status
Live |
Auth types
OAuth 2.0 | Scopes
People API, v1 - https://www.googleapis.com/auth/userinfo.email
Google Sheets API, v4 https://www.googleapis.com/auth/spreadsheets
Google Drive API, v4 (Read Only) https://www.googleapis.com/auth/drive.readonly |
Supported Trigger | Supported Trigger
- Create a spreadsheet
- Add new row
- Update a value |
You'll need the following information to set up your Google App with Cobalt Connect:
- Client ID
- Client Secret
- Scopes Requested
Note: You'll need to create a new project in Google Cloud Console if you don't already have one.
Cobalt provides a redirect URL to send information to your Google app. To add the redirect URL to your Google app:
1. Copy the link under "Redirect URL" in your integration settings in Cobalt. The Redirect URL is:
https://passport.useparagon.com/oauth
2. In your Google Cloud Console dashboard, navigate to APIs & Services > Credentials in the sidebar.
3. Press "+ Create Credentials", then select OAuth client ID.
4. Select "Web application" from the Application type drop-down menu.
Note: You'll need to configure Google's consent screen for access to Client ID and Client Secret if you haven't already.

5. Under Authorized redirect URIs, press the "+ Add URI" button.
6. Paste-in the redirect URL from Cobalt.
7. Press the blue "Create" button.

Google provides you with the Client ID and Client Secret needed for the next steps after adding the redirect URL to your project.
2. Search for "Google Sheets API" from the API Library.
3. Select the "Google Sheets API".
4. Press the blue "Enable" button to enable the API for your application.

1. Select Google Sheets from the Integrations Catalog.
2. Under Integrations > Connected Integrations > {YOUR_APP} > Settings, fill out your credentials from the end of Step 1 in their respective sections:
- Client ID: Found at the end of Step 1.
- Client Secret: Found at the end of Step 1.
- Permissions: Select the scopes you've requested for your application. They should begin with
sheets
.
Press the blue "Connect" button to save your credentials.
Note: Leaving the Client ID and Client Secret blank will use Cobalt development keys.
Last modified 8mo ago