<< All versions
Skill v1.0.1
currentLLM-judged scan95/100freema/mcp-gsheets/spreadsheet-management
2 files
──Details
PublishedMay 21, 2026 at 12:35 AM
Content Hashsha256:d444d003faf99dff...
Git SHA2fe4cdccb6d5
Bump Typepatch
──Files
Files (1 file, 1.9 KB)
SKILL.md1.9 KBactive
SKILL.md · 66 lines · 1.9 KB
version: "1.0.1" name: spreadsheet-management description: This skill should be used when the user asks about Google Sheets, spreadsheets, cells, rows, columns, charts, or data tables. Activates for reading, writing, formatting, or analyzing spreadsheet data.
When the user asks about spreadsheets or data in Google Sheets, use the gsheets MCP tools.
When to Use This Skill
Activate when the user:
- Wants to read spreadsheet data ("Get data from sheet", "Read column A")
- Needs to write data ("Update cell A1", "Add a row", "Append data")
- Formats cells ("Make header bold", "Add borders", "Change colors")
- Creates charts ("Create a bar chart", "Add a pie chart")
- Manages sheets ("Create new sheet", "Delete sheet", "Copy sheet")
Tools Reference
| Task | Tool | |
|---|---|---|
| Read range | sheets_get_values | |
| Read multiple | sheets_batch_get_values | |
| Get info | sheets_get_metadata | |
| Write range | sheets_update_values | |
| Append rows | sheets_append_values | |
| Insert rows | sheets_insert_rows | |
| Format cells | sheets_format_cells | |
| Borders | sheets_update_borders | |
| Merge | sheets_merge_cells | |
| Create chart | sheets_create_chart | |
| New sheet | sheets_insert_sheet |
Spreadsheet ID
Found in the URL: https://docs.google.com/spreadsheets/d/{SPREADSHEET_ID}/edit
Range Notation
Sheet1!A1:D10 # Specific rangeSheet1!A:A # Entire columnSheet1!1:1 # Entire rowA1:D10 # First sheet, specific range'Sheet Name'!A1 # Sheet name with spaces
Example Workflows
Read and summarize:
sheets_get_metadata spreadsheetId="1Bxi..."sheets_get_values spreadsheetId="1Bxi..." range="Data!A1:F100"
Format header row:
sheets_format_cells spreadsheetId="1Bxi..." range="A1:Z1" bold=true backgroundColor="#4285f4"
Create chart:
sheets_create_chart spreadsheetId="1Bxi..." sheetId=0 chartType="BAR" dataRange="A1:B10"