Google Sheets

Overview of the Google Sheets book.

The following documentation is for Google Sheets v1.6.4 (BDK).

Overview

Google Sheets is a powerful cloud-based spreadsheet application with real-time collaboration capabilities. This integration enables automated data entry, spreadsheet management, and collaborative workflow automation. Streamline data analysis and enhance team productivity through automated spreadsheet operations.

Prerequisites

1. Required Books

The following Book(s) need to be added to your agent so it can learn and understand the automation procedures defined within them:

• Google Sheets

How to Add the Book(s)

1. Go to Books → All Books.

2. Search for the name of the book and click on it.

3. Click on Install or Add Connection to add the book to your agent.

4. If adding a connection, you'll be prompted for connectivity details.

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

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

To connect to the Google Sheets book, click on Continue with Google. This will redirect you to Google's secure authentication page where you can sign in with your Google account and authorize the application. Once connected, the Kognitos agent will have access to your Google Sheets while keeping your credentials secure.