Google Sheets

Overview of the Google Sheets BDK Book.

Overview

This integration provides automation capabilities for Google Sheets, enabling streamlined workflows and enhanced productivity. Connect your processes with Google Sheets to automate routine tasks and improve operational efficiency.

Prerequisites

1. Add the Book to Your Agent

To use the Google Sheets BDK Book, you need to add it to your agent. This allows the agent to learn and execute the automation procedures in the Book. Follow the steps below to get started:

1. Go to Books from the left navigation menu.

2. Click on + New Book.

3. Search for Google Sheets (BDK) and click on the book.

4. You'll be prompted for connectivity details if the book requires configuration.

5. Click on Add to finish adding the book to your agent.

6. Publish your agent.

Connectivity

This section outlines the available methods for connecting to the Book, along with the required configuration details for each.

Connect using Client Email, Token URI and Private Key (secure account method)

Gets the credentials from the service account keys.

Label	Description	Type
Client Email	The client email of the service account registered in the Google Cloud Console.	text
Token URI	The token URI of the Google Cloud Console.	text
Private Key	The private key of the service account registered in the Google Cloud Console.	sensitive

Continue with Google (oauth)

Click on Continue with Google to open a secure login page where you can sign in and grant access to the application. Once authorized, the Kognitos agent will be able to interact with your account—without ever storing your credentials directly.