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
OAUTH2
Actions
GOOGLESHEETS_BATCH_GET
Perform a batch get on a specific spreadsheet. note: if ranges aren’t provided, data from the first sheet will be returned.
Action Parameters
Action Response
GOOGLESHEETS_BATCH_UPDATE
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
Action Response
GOOGLESHEETS_CLEAR_VALUES
Clear values from a specified range in a spreadsheet.
Action Parameters
Action Response
GOOGLESHEETS_CREATE_GOOGLE_SHEET1
Create a new google sheet.
Action Parameters
Action Response
GOOGLESHEETS_CREATE_SPREADSHEET_COLUMN
Create a new column in a specific spreadsheet.
Action Parameters
Action Response
GOOGLESHEETS_CREATE_SPREADSHEET_ROW
Create a new row in a specific spreadsheet.
Action Parameters
Action Response
GOOGLESHEETS_FIND_WORKSHEET_BY_TITLE
Find a worksheet by title in a specific spreadsheet.
Action Parameters
Action Response
GOOGLESHEETS_FORMAT_CELL
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
Action Response
GOOGLESHEETS_GET_SHEET_NAMES
Get all the worksheet names in a spreadsheet. note: use this action to get valid sheet names before using any other action.
Action Parameters
Action Response
GOOGLESHEETS_GET_SPREADSHEET_INFO
Retrieve information about an existing google sheet.
Action Parameters
Action Response
GOOGLESHEETS_LOOKUP_SPREADSHEET_ROW
Lookup a row in a specific spreadsheet by a column and value.
Action Parameters
Action Response
GOOGLESHEETS_SHEET_FROM_JSON
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
Action Response