| 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. Use when this capability is needed. |
| metadata | {"author":"freema"} |
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 range
Sheet1!A:A # Entire column
Sheet1!1:1 # Entire row
A1: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"
Source: freema/mcp-gsheets — distributed by TomeVault.
