Google Sheets

Google Sheets plugin for Connery.

How to set up the "Ask Google Sheets" action

Prepare Google Sheets

1. Create "FAQ List" sheet

This sheet should contain the list of questions and answers that the plugin will use to answer your questions.

• Create a "FAQ List" Google Sheet with the following columns: "Question" and "Answer".
  • The first row should contain the exact names of the columns.
  • The sheet may also contain other columns if needed.
• Add the questions and answers to the sheet.

2. Share the sheet with the service account

• Share the "FAQ List" Google Sheet with the service account email address (see below).

Create a service account on Google Cloud Platform

This plugin requires OAuth2 authorization to access the Google Sheets API. To authorize the plugin to access your Google Sheets, you must provide a JSON Key from a Google Cloud Platform service account. This service account must have access to the Google Sheet you want to use with this plugin.

Follow these steps to get the JSON Key, grant access to the Google Sheet, and configure the plugin:

1. Create a Service Account

• Go to the Google Cloud Console.
• Select your project, go to "IAM & Admin" > "Service Accounts", and create a new service account.
• Grant the necessary permissions to the service account based on what actions it needs to perform.
• Create and download a JSON Key file for the service account. This file contains the credentials used to authenticate your server-to-server API requests.

2. Share the Google Sheets with Service Account

• Find the service account's email address in the JSON Key file or in the service account details in the Google Cloud Console.
• Share the Google Sheets with this service account email, just like you would with any regular user.

3. Enable Google Sheets API

• Go to the Google Cloud Console.
• Make sure you are logged in with the correct Google account and select correct project.
• Navigate to "APIs & Services" > "Dashboard".
• Click on “+ ENABLE APIS AND SERVICES” at the top.
• Search for "Google Sheets API", select it, and click “Enable”.

4. Configure the action

• Install the plugin on on the Connery Platform.
• Configure the action.

Repository structure

This repository contains the plugin's source code.

Path	Description
./src/index.ts	The entry point for the plugin. It contains the plugin definition and references to all the actions.
./src/actions/	This folder contains all the actions of the plugin. Each action is represented by a separate file with the action definition and implementation.

Built using Connery SDK

This plugin is built using Connery SDK, the open-source SDK for creating AI plugins and actions.

Learn how to use the plugin and its actions.

Support

If you have any questions or need help with this plugin, please create an issue in this repository.