spreadsheet-management

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 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"