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

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

Action Parameters

ranges
array
spreadsheet_id
stringRequired

Action Response

data
object
error
successful
boolean

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

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

Action Response

data
object
error
successful
boolean

Clear values from a specified range in a spreadsheet.

Action Parameters

range
stringRequired
spreadsheet_id
stringRequired

Action Response

data
object
error
successful
boolean

Create a new google sheet.

Action Parameters

title
stringRequired

Action Response

data
object
error
successful
boolean

Apply formatting to a specified range of cells in a google sheets spreadsheet. note: the current implementation incorrectly uses logic for updating cell values. this needs to be refactored.

Action Parameters

blue
numberDefaults to 0.9
bold
boolean
end_column_index
integerRequired
end_row_index
integerRequired
fontSize
integerDefaults to 10
green
numberDefaults to 0.9
italic
boolean
red
numberDefaults to 0.9
spreadsheet_id
stringRequired
start_column_index
integerRequired
start_row_index
integerRequired
strikethrough
boolean
underline
boolean
worksheet_id
integerRequired

Action Response

data
object
error
successful
boolean

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
error
successful
boolean

Retrieve information about an existing google sheet.

Action Parameters

spreadsheet_id
stringRequired

Action Response

data
object
error
successful
boolean

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

Action Parameters

case_sensitive
boolean
query
stringRequired
range
string
spreadsheet_id
stringRequired

Action Response

data
object
error
successful
boolean

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

sheet_json
arrayRequired
sheet_name
stringRequired
title
stringRequired

Action Response

data
object
error
successful
boolean