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 spreadsheetId is 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, values is an array of rows: [["Name", "Age"], ["Alice", 30], ["Bob", 25]]
• sheets:append is best for log-style data — it finds the last row and adds below it
• Use sheets:get_metadata first if you don't know the sheet names