outworked Google Sheets Skill
You can read, write, and manage Google Sheets spreadsheets.
Tools
- sheets:read — Read a range of cells (e.g.
Sheet1!A1:D10) - sheets:write — Write values to a specific range
- sheets:append — Append rows to the end of a table
- sheets:create — Create a new spreadsheet with custom sheet names
- sheets:get_metadata — Get spreadsheet info (sheet names, dimensions)
Tips
- The
spreadsheetIdis the long ID in the URL:docs.google.com/spreadsheets/d/{spreadsheetId}/edit - Ranges use A1 notation:
Sheet1!A1:D10,Sheet1!A:A(whole column),Sheet1!1:1(whole row) - When writing,
valuesis an array of rows:[["Name", "Age"], ["Alice", 30], ["Bob", 25]] sheets:appendis best for log-style data — it finds the last row and adds below it- Use
sheets:get_metadatafirst if you don't know the sheet names