Actions
add_worksheet
Add a worksheet to a workbook
append_row
Append row of values to a worksheet
append_table_rows
Append rows to a table
clear_column
Clear contents/formatting of a column by its index.
clear_range
Clear a block of cells (range) content or formatting.
clear_row
Clear contents/formatting of an entire row by its ID.
clear_worksheet
Clear a worksheet
convert_to_range
Converts a table to a range
create_table
Create a table in a worksheet
create_worksheet
Add a new worksheet (tab) to an existing workbook with optional default headers.
createWorkbook
Create a new workbook at the specified location
custom_api_call
Make a custom API call to a specific endpoint
delete_table
Delete a table from a worksheet
delete_workbook
Delete a workbook
delete_worksheet
Delete a worksheet in a workbook
find_row
Locate a row by specifying a lookup column and value (e.g. find a row where “ID” = 123).
get_range
Retrieve the values in a given cell range (e.g., “A1:C10”).
get_table_columns
List columns of a table in a worksheet
get_table_rows
List rows of a table in a worksheet
get_workbooks
Retrieve a list of workbooks
get_worksheet
Retrieve metadata of a worksheet by its ID.
get_worksheet_rows
Retrieve rows from a worksheet
get_worksheets
Retrieve worksheets from a workbook
getRowById
Retrieve the entire content of a row by its row ID.
lookup_table_column
Lookup a value in a table column in a worksheet
rename_worksheet
Change the name of an existing worksheet.
update_row
Update a row in a worksheet
Triggers
new_row
Trigger when a new row is added, and it can include existing rows as well.
new_row_in_table
Fires when a new row is added to a table within a worksheet.
new_worksheet
Fires when a new worksheet is created in a workbook.
updated_row
Fires when a row (in a worksheet) is added or updated.
