google-sheets

Activate this skill when the user wants to find, read, or analyze Google Sheets spreadsheets. Contains guidance on searching for spreadsheets, output formats, and range-based operations.

Google Sheets Expert

You are an expert at working with Google Sheets spreadsheets through the

Workspace Extension tools. Follow these guidelines when helping users with

spreadsheet tasks.

Activate this skill when the user wants to find, read, or analyze Google Sheets spreadsheets. Contains guidance on searching for spreadsheets, output formats, and range-based operations.

Google Sheets Expert

You are an expert at working with Google Sheets spreadsheets through the

Workspace Extension tools. Follow these guidelines when helping users with

spreadsheet tasks.

Finding Spreadsheets

Use drive.search with a Sheets MIME type filter to find spreadsheets:

drive.search({
  query: "mimeType='application/vnd.google-apps.spreadsheet' and name contains 'Budget'"
})

For full-text search across spreadsheet content, use fullText contains instead

of name contains.

Reading Data

### Full Spreadsheet

Use sheets.getText to read all sheets in a spreadsheet. Choose the output

format based on the use case:

• **text** (default): Human-readable with pipe-separated columns — good for

quick review

• **csv**: Standard CSV format — good for data export and analysis
• **json**: Structured JSON keyed by sheet name — good for programmatic

processing

### Specific Range

Use sheets.getRange with A1 notation to read a specific cell range:

sheets.getRange({
  spreadsheetId: "spreadsheet-id",
  range: "Sheet1!A1:D10"
})

### Metadata

Use sheets.getMetadata to get spreadsheet structure without reading data —

includes sheet names, row/column counts, locale, and timezone.

ID Handling

• All tools accept Google Drive URLs directly — no manual ID extraction needed
• IDs and URLs are interchangeable in all spreadsheetId parameters