Google Sheets is a web-based spreadsheet program that is part of the Google Drive office suite.
Lookup a row in a specific spreadsheet by a column and value.
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
Perform a batch get on a specific spreadsheet. note: if ranges aren’t provided, data from the first sheet will be returned.
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.
Clear values from a specified range in a spreadsheet.
Get all the worksheet names in a spreadsheet. note: use this action to get valid sheet names before using any other action.
Create a new google sheet.
Retrieve information about an existing google sheet.
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.