Google Sheets

Setup Guide
You can find your Google app credentials by visiting your Google Cloud Console dashboard. 
You'll need the following information to set up your Google App with Paragon 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.
Add the Redirect URL to your Google app
Paragon 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 Paragon. The Redirect URL is:
1
https://passport.useparagon.com/oauth
Copied!
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 Paragon.
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.
Enable Google Sheets API in Google Cloud Console Dashboard
1. In your Google Cloud Console dashboard, navigate to APIs & Services > Library in the sidebar.
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.
Add your Google app to Paragon
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 Paragon development keys.
Connecting to Google Sheets
Once your users have connected their Google Sheets account, you can use the Paragon SDK to access the Google Sheets API on behalf of connected users.
See the Google Sheets REST API documentation for their full API reference.
Any Google Sheets API endpoints can be accessed with the Paragon SDK as shown in this example.
1
// You can find your project ID in the Overview tab of any Integration
2
​
3
// Authenticate the user
4
paragon.authenticate(<ProjectId>, <UserToken>);
5
            
6
// Get SpreadSheet 
7
await paragon.request("googlesheets", "/spreadsheets/{spreadsheetId}", { 
8
    method: "GET",
9
});
10
  
11
  
12
// Query SpreadSheet data
13
await paragon.request("googlesheets", "/spreadsheets/{spreadsheetId}/values/{range}", { 
14
    method: "GET",
15
});
16
  
Copied!
Building Google Sheets workflows
Once your Google Sheets account is connected, you can add steps to perform the following actions:
Get Rows from Spreadsheet
When saving or getting files in Google Sheets, you can reference data from previous steps by typing {{ to invoke the variable menu.

Google Drive

HubSpot

Last modified 2mo ago

Copy link

Contents

Setup Guide

Add the Redirect URL to your Google app

Enable Google Sheets API in Google Cloud Console Dashboard

Add your Google app to Paragon

Connecting to Google Sheets

Building Google Sheets workflows