📊 Google Sheets

What you can do

• Read a range as JSON for analysis
• Append rows from script output
• Update specific cells programmatically

Setup

agentio gsheets profile add

Command reference

• agentio gsheets list
  List recent spreadsheets
  --profile <name> --limit <n> --query <query>
• agentio gsheets get <spreadsheet-id-or-url> <range>
  Get values from a range
  --profile <name> --dimension <dim> --render <opt>
• agentio gsheets update <spreadsheet-id-or-url> <range> [values...]
  Update values in a range
  --profile <name> --values-json <json> --input <opt>
• agentio gsheets append <spreadsheet-id-or-url> <range> [values...]
  Append values to a range
  --profile <name> --values-json <json> --input <opt> --insert <opt>
• agentio gsheets clear <spreadsheet-id-or-url> <range>
  Clear values in a range
  --profile <name>
• agentio gsheets format <spreadsheet-id-or-url> <range>
  Apply cell formatting (colors, text style, alignment, borders, merge)
  --profile <name> --bold --italic --underline --font-size <n> --font-family <name> --text-color <hex> --background <hex> --align <pos> --valign <pos> --wrap <strategy> --number-format <pattern> --border <style> --merge --clear-format --raw <json>
• agentio gsheets resize <spreadsheet-id-or-url> <range>
  Resize columns or rows (explicit pixel size or auto-fit)
  --profile <name> --size <pixels> --auto
• agentio gsheets batch <spreadsheet-id-or-url>
  Execute raw spreadsheets.batchUpdate requests (escape hatch)
  --profile <name> --requests-json <json> --file <path>
• agentio gsheets metadata <spreadsheet-id-or-url>
  Get spreadsheet metadata
  --profile <name>
• agentio gsheets create <title>
  Create a new spreadsheet
  --profile <name> --sheets <names>
• agentio gsheets copy <spreadsheet-id-or-url> <title>
  Copy a spreadsheet
  --profile <name> --parent <folder-id>
• agentio gsheets export <spreadsheet-id-or-url>
  Export a spreadsheet to a file
  --profile <name> --output <path> --format <fmt>

MCP tools

• gsheets_list
  List recent spreadsheets
• gsheets_get
  Get values from a range
• gsheets_update
  Update values in a range
• gsheets_append
  Append values to a range
• gsheets_clear
  Clear values in a range
• gsheets_format
  Apply cell formatting (colors, text style, alignment, borders, merge)
• gsheets_resize
  Resize columns or rows (explicit pixel size or auto-fit)
• gsheets_batch
  Execute raw spreadsheets.batchUpdate requests (escape hatch)
• gsheets_metadata
  Get spreadsheet metadata
• gsheets_create
  Create a new spreadsheet
• gsheets_copy
  Copy a spreadsheet
• gsheets_export
  Export a spreadsheet to a file

Related changelog entries

• feat add LLM-friendly examples to all gsheets commands f18e883
• feat add resize and batch commands 6b0b167
• feat add format command for cell styling, alignment, borders, and merging 61cca06