Googlesheets

Learn how to use Googlesheets with Composio

Overview

Enum

GOOGLESHEETS

Description

Google Sheets is a web-based spreadsheet program that is part of the Google Drive office suite.

Authentication Details

client_id
stringRequired
client_secret
stringRequired
oauth_redirect_uri
stringDefaults to https://backend.composio.dev/api/v1/auth-apps/add
scopes
stringDefaults to https://www.googleapis.com/auth/spreadsheets

Actions

Lookup a row in a specific spreadsheet by a column and value.

Action Parameters

spreadsheet_id
stringRequired
range
string
query
stringRequired
case_sensitive
boolean

Action Response

data
object
successful
boolean
error

Get all the worksheet names in a spreadsheet. note: use this action to get valid sheet names before using any other action.

Action Parameters

spreadsheet_id
stringRequired

Action Response

data
object
successful
boolean
error

Create a new google sheet from a json object. this action takes a json structure and converts it into a google sheet where: - the first row contains the keys as headers - subsequent rows contain the corresponding values - all rows must have the same structure (keys) args: title (str): the title of the new google sheet sheet name (str): name of the worksheet within the spreadsheet sheet json (list[dict]): list of dictionaries with consistent keys

Action Parameters

title
stringRequired
sheet_name
stringRequired
sheet_json
arrayRequired

Action Response

data
object
successful
boolean
error

Create a new google sheet.

Action Parameters

title
stringRequired

Action Response

data
object
successful
boolean
error

Retrieve information about an existing google sheet.

Action Parameters

spreadsheet_id
stringRequired

Action Response

data
object
successful
boolean
error

Perform a batch update operation on a specified google sheets spreadsheet. note: if no first cell location is provided, the values will be appended to the first empty row of the sheet from the top.

Action Parameters

spreadsheet_id
stringRequired
sheet_name
stringRequired
first_cell_location
string
values
arrayRequired
includeValuesInResponse
boolean
valueInputOption
stringDefaults to USER_ENTERED

Action Response

data
object
successful
boolean
error

Clear values from a specified range in a spreadsheet.

Action Parameters

spreadsheet_id
stringRequired
range
stringRequired

Action Response

data
object
successful
boolean
error

Perform a batch get on a specific spreadsheet. note: if ranges aren’t provided, data from the first sheet will be returned.

Action Parameters

spreadsheet_id
stringRequired
ranges
array

Action Response

data
object
successful
boolean
error