Google Sheets

This page contains the setup guide and reference information for the Google Sheets connector.

Prerequisites

Before connecting your Google Sheets account, ensure that:

• You have an active Google account with access to Google Sheets.

• You have access to the Google Cloud Console.

Setup Guide

Follow these steps to connect your Google Sheets account:

00:00: This guide will walk you through creating a Google off client for Google Sheets 00:04: in a structured Manner and use the credentials created on Carrigan dashboard. 00:10: First visit the console. 00:12: Cloud. Google.com page 00:15: Go to Google developer console Cloud resource manager and 00:19: start by creating a new project. 00:22: Enter your desired project name. For example. 00:24: Karigon Google Sheets project. 00:28: Proceed by clicking the create button 00:31: Select the newly-created project. 00:34: Click the menu icon at the top, right? 00:37: Access the enabled apis and services section. 00:41: Look for resources docs and products. 00:45: Enter Google Sheets API in the search bar and selected from the search results. 00:51: Enable the Google Sheets API 00:54: Go back to the enabled apis dashboard. 00:57: Access the O of consent screen section 01:01: Select the internal option under user type 01:05: Play create. 01:08: Proceed by selecting and filling the app named field. 01:11: For example carraig on Google Sheets app 01:15: Select the email address from the drop-down. 01:18: Sent an email address under developer contact information. 01:23: They then proceed to the next step. 01:26: Access the option to add or remove scopes. 01:30: Alexa manually add Scopes field and add the appropriate Scopes, 01:34: please. Add them one at a time. 01:37: Include the scope in the table 01:40: Update the changes made. 01:43: Save and move on to the next step. 01:46: Return to the dashboard 01:49: Access the credential section 01:52: Create new credentials. 01:55: Select the option 40 off client ID. 01:59: Click the application type field. 02:02: Choose the web application option. 02:05: Add new uri's Under authorized redirect. 02:08: Uri's. 02:10: Enter the URI here. 02:13: Add the early to the list and add another one. 02:17: Enter the secondary here. 02:20: Create the credentials. 02:23: Copy the client ID and secret and paste them in your Carrigan dashboard 02:27: Google Sheets Authentication. 02:30: You are now set up to authenticate Google Sheets on Carrigan dashboard and 02:34: start building your hipaa-compliant workflow.

1. Visit Google Cloud Console: Go to console.cloud.google.com.

2. Create a Project: Click “Create Project”, set a name (e.g., Keragon Google Sheets Project), and click Create.

3. Select the Project: After creation, click Select Project.

4. Enable APIs: Use the menu to go to “Enabled APIs & services” → Click the Search field → Search and select Google Sheets API → Click Enable. Repeat for Google Drive API.

5. Configure OAuth Consent Screen:

   • Go to OAuth consent screen from the menu.

   • Choose Internal as the user type, click Create.

   • Fill in App name (e.g., Keragon Google Sheets App), User support email, Developer contact email.

   • Click Save and continue.

   • Click Add or remove scopes, then manually add:

     • https://www.googleapis.com/auth/spreadsheets

     • https://www.googleapis.com/auth/drive

   • Click Add to table, confirm both scopes are checked, then click Update.

   • Click Save and continue → Back to dashboard.

6. Create OAuth Credentials:

   • Go to Credentials → Click Create credentials → Choose OAuth client ID.

   • Set Application type to Web application.

   • Under “Authorized redirect URIs”, add:

     • https://api.us-east-1.keragon.com/rest/auth/callback

     • https://api.us-1.keragon.com/rest/auth/callback

   • Click Create.

7. Get Your Credentials:

   • Copy the Client ID and Client Secret.

   • Go to the Keragon dashboard, navigate to the Google Sheets connector setup, and paste in the credentials.

You are now ready to authenticate and use Google Sheets in your HIPAA-compliant workflows on Keragon.

Troubleshooting and Common Errors

Limitations and Notes

• The connector supports Google Sheets files that the authenticated user owns or has access to.

• API quota limits from Google may apply and affect the number of operations you can perform daily.

• Only OAuth 2.0 is supported for authentication.

• Certain advanced features like conditional formatting or charts are not accessible through this connector.

• Ensure that spreadsheets are not too large; reading or writing large datasets may result in timeouts.