google-sheets
Installation
SKILL.md
Google Sheets authoring
Two coordinate systems, on purpose
- VALUE tools (
read_range,write_range,append_rows,clear_range) address a TAB TITLE plus A1 cells:{sheet: "Data", cells: "A1:B4"}. - STRUCTURE/FORMAT tools (
format_cells,set_borders,merge_cells,add_chart,add_conditional_formatting,insert_rows_or_columns,delete_rows_or_columns,freeze_rows_or_columns,sort_range,set_data_validation,set_basic_filter,add_banding,set_column_width,rename_sheet_tab,delete_sheet_tab) address the numericsheetId.
get_spreadsheet returns both (each tab's title AND sheetId) with no cell
data - call it first and keep the mapping. A new tab's sheetId is in
add_sheet_tab's reply (replies[0].addSheet.properties.sheetId).