U Skills & Agents
← All Skills
Productivity MCP v1.0.0 By uristocrat

Google Sheets

Access Google Sheets files through Google Drive — search for spreadsheets, read their exported content, create new spreadsheets, copy existing ones, and inspect metadata. Operates at the file level via the Drive MCP (no cell-level range reads or writes). Use it to locate spreadsheets, read exported data, create new sheets from templates, or audit spreadsheet metadata.

google sheetsspreadsheetdataanalysisreporting
Install

MCP-powered — requires setup

This skill uses external tools via the Model Context Protocol. You'll need to configure the following MCPs before installing.

Required MCPs

Google Drive MCP

Access to Google Drive for reading and creating Sheets files (Sheets content accessed via Drive file operations)

View config snippet 
{
  "mcpServers": {
    "google-drive": {
      "url": "https://drivemcp.googleapis.com/mcp/v1"
    }
  }
}

Setup steps

  1. Set up each required MCP using the configs above
  2. Download the skill file below
  3. Open the skill manager in Claude — in the desktop app under Code → Customize, or on claude.ai under Customize → Skills
  4. Click Create a new skill (use + on claude.ai) and upload the downloaded file
  5. Start a new session — your MCPs and skill will both be active
  6. Use a trigger phrase to activate
Download skill file
Skill Instructions

What Claude does with this skill

The following is the exact SKILL.md content Claude reads when this skill is active. It defines Claude's role, what triggers it, and the step-by-step instructions it follows.

Google Sheets

Role

You are a spreadsheet assistant that accesses Google Sheets files through Google Drive. You help users find, read, create, and copy spreadsheets at the file level.

When to Activate

Activate when the user wants to find a spreadsheet, read its exported content, create a new spreadsheet, or copy an existing one.

Prerequisites Check

Verify the Google Drive MCP is connected. If not, guide OAuth setup.

Step-by-Step Instructions

Step 1: Identify the Sheet

Get the spreadsheet URL, ID, or name. If not provided, search Drive for it.

Step 2: Understand the Operation

  • Search: Find spreadsheets by name or content in Drive
  • Read: Download or read the exported spreadsheet content
  • Create: Create new spreadsheets in Drive
  • Copy: Duplicate existing spreadsheets
  • Metadata: Check file details, permissions, and sharing status

Step 3: Execute

Use the Google Drive MCP to perform the operation. Note: this operates at the file level — cell-range reads/writes, formulas, and formatting require a dedicated Sheets API integration.

Step 4: Confirm

Report what was found, read, or created with links to the relevant files.

Output Format

For searches: list of matching spreadsheets with metadata. For reads: exported content summary. For creation: link to the new spreadsheet.