Google Sheets

Scope of Integration#

Yellow.ai Integration with Google Sheets enables you to seamlessly access Google sheets services. Any customer who has a Google account will be able to connect with yellow.ai using OAuth. Using this integration you can create, read, insert/update and clear values from a spreadsheet.

Use-cases#

Following are the use-cases which are currently accommodated in the Integration:

CreateSpreadsheet:-#

Create spreadsheet integration node helps user in creating a Google spreadsheet using the spreadsheet name and the sheet names provided by the user. These created spreadsheets can be found in user’s Google sheets account with which the integration is enabled.

Node Sample Inputs:-#

ParameterTypeSample
titlestringDemo Sheet
sheetsarray
[
{
"properties": {
"title": "Sheet 1 name"
}
},
{
"properties": {
"title": "Sheet 2 name"
}
}
]

GetValuesFromSheet:-#

Get values from sheet integration node helps user in retrieving values from sheet. Based on the Spreadsheet ID, Ranges and Major Dimension it will return the values.

Node Sample Inputs:-#

ParameterTypeSample
majorDimensionstringROWS(or)COLUMNS
rangesstringSheet1!A1:B2
spreadSheetIDstring1fExJP4rbjNKpbSHySJl4kOjwJ-mGUUzzsCs_qrC0YgI

Insert/UpdateValuesInSheet:-#

Insert/Update Values in Sheet integration node helps user in inserting or updating values in a sheet. This node inserts/updates the values in a spreadsheet in the specified range with provided values.

Node Sample Inputs:-#

ParameterTypeSample
majorDimensionstringROWS(or)COLUMNS
rangestringSheet1!A1:B3
valuesarray
[
[1, 2, 3],
[4, 5, 6]
]
spreadSheetIDstring1fExJP4rbjNKpbSHySJl4kOjwJ-mGUUzzsCs_qrC0YgI

ClearValuesInSheet:-#

Clear values in a sheet integration node helps users in clearing values in a spreadsheet using the Spreadsheet ID and the Range provided by the user.

Node Sample Inputs:-#

ParameterTypeSample
rangesarray["Sheet1!A1:B3","Sheet1!A4:B6"]
spreadSheetIDstring1fExJP4rbjNKpbSHySJl4kOjwJ-mGUUzzsCs_qrC0YgI

Configuration#

Configuring the integration with Google sheets is straightforward. Follow the steps defined below to start integrating:

Navigate to integration tab:-#

Inside your project, fom the switcher navigate to the Integrations, search for Google Sheets in the search bar, or you can find Google Sheets under Tools & Utilities section. Integration_Tab

Connect your google account:-#

One can easily enable Google sheets integration for their bot using Oauth. Follow the below steps to enable Google Sheets integration for your bot:-

  1. Click on Sign in with Google button.
  2. Login with your Google credentials in the window opened.
  3. Click on Allow Access to provide your bot the access to Google Sheets.

Integration_Gif Following the above steps will connect your Google Sheets with Yellow.ai platform.

References:-#

  1. Create a Spreadsheet
  2. Get Values from a Sheet
  3. Insert/Update Values in a Sheet
  4. Clear Values in a Sheet

Sample Experience#

Below is a video that depicts how this integration works

<VIDEO WILL BE UPLOADED WITH UPDATED UI DESIGN LANGUAGE>