Agent skill · cursor
google-sheets
Build and edit Google Sheets with the google-sheets tools - values, formatting, charts, conditional formatting, structure, validation, named and protected ranges. Use when creating a spreadsheet or dashboard, formatting cells, adding or fixing charts, or reorganizing tabs and rows.
What it needs
About 2k tokens when loaded.
What this skill does
Google Sheets authoring Two coordinate systems, on purpose VALUE tools (readrange, writerange, appendrows, clearrange) address a TAB TITLE plus A1 cells: {sheet: "Data", cells: "A1:B4"}. STRUCTURE/FORMAT tools (formatcells, setborders, mergecells, addchart, addconditionalformatting, insertrowsorcolumns, deleterowsorcolumns, freezerowsorcolumns, sortrange, setdatavalidation, setbasicfilter, addbanding, setcolumnwidth, renamesheettab, deletesheettab) address the numeric sheetId. getspreadsheet 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 addsheettab's reply (replies[0].addSheet.properties.sheetId). Sequencing a styled sheet: values first, then format, chart last 1. createspreadsheet (optionally with named tabs; it cannot target a folder - move it after with google-drive googledrivemoveorrename). 2. writerange the data with parseInput: true when values include numbers, dates, or formulas (default false stores everything as literal text - a top source of "chart is empty" bugs). 3. Format like a real dashboard, not a bare grid: formatcells bold header with a fill color and white text; number patterns on value columns ($#,##0, 0.0%). freezerowsorcolumns the header row. setbasicfilter over the table range - filter dropdowns are what make it read as a data table. setborders (outer heavier than inner) or addbanding for alternating row colors; setcolumnwidth so nothing clips. addconditionalformatting for thresholds worth seeing at a glance. 4. addchart LAST, after the data exists. Charts In addchart, the FIRST range is the domain (x axis / pie labels) and later ranges are the series, one column each; anchoring a chart to the wrong or reversed ranges is the most common chart bug. All ranges live on the same tab as the chart. headerCount: 1 uses the first cells as series labels - include the header row in each range when you set it. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills cursor/google-sheets