Skill v1.0.1

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

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"