Googlesheets
Google Sheets is a web-based spreadsheet program that is part of the Google Drive office suite.
Lookup Spreadsheet Row
Lookup Spreadsheet Row
Lookup a row in a specific spreadsheet by a column and value.
Sheet From Json
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
Batch Get Spreadsheet
Batch Get Spreadsheet
Perform a batch get on a specific spreadsheet. note: if ranges aren’t provided, data from the first sheet will be returned.
Batch Update Spreadsheet
Batch Update Spreadsheet
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 Spreadsheet Values
Clear Spreadsheet Values
Clear values from a specified range in a spreadsheet.
Get Sheet Names
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.
Create Google Sheet
Create Google Sheet
Create a new google sheet.
Get Spreadsheet Info
Get Spreadsheet Info
Retrieve information about an existing google sheet.
Format Cell
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.