Google Sheets
Overview of the Google Sheets book.
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)
Go to Books → All Books.
Search for name of the book and click on it.
Click on Install or Add Connection to add the book to your agent.
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.
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 Gmail Book, click on Continue with Google. This will 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.
Last updated
Was this helpful?