Summary

This PR adds Google Sheets support to the MCP server, enabling full read, write, and management capabilities for Google Spreadsheets alongside the existing Google Docs and Google Drive functionality.

New Features

📊 Google Sheets Support

Introduces 8 new spreadsheet tools:

• readSpreadsheet
  Read data from spreadsheet ranges using A1 notation (e.g. A1:B10, Sheet1!A1:B10)

• writeSpreadsheet
  Write data to spreadsheet ranges (overwrites existing data)

• appendSpreadsheetRows
  Append rows to existing sheets

• clearSpreadsheetRange
  Clear cell values from specified ranges

• getSpreadsheetInfo
  Retrieve spreadsheet metadata and list all sheets/tabs

• createSpreadsheet
  Create new spreadsheets with optional initial data

• addSpreadsheetSheet
  Add new sheets/tabs to existing spreadsheets

• listGoogleSheets
  List and search spreadsheets from Google Drive

Technical Changes

New Files

• src/googleSheetsApiHelpers.ts
  Helper utilities for Google Sheets operations, including:

  • A1 notation parsing and conversion
  • Range read/write helpers
  • Spreadsheet metadata retrieval
  • Sheet/tab management utilities
  • Cell formatting helpers (including hex color conversion)

Modified Files

src/auth.ts

• Added https://www.googleapis.com/auth/spreadsheets scope to authentication

src/server.ts

• Initialized Google Sheets API client (sheets_v4.Sheets)
• Added getSheetsClient() helper
• Updated initializeGoogleClient() to include Sheets client
• Updated server name to "Ultimate Google Docs & Sheets MCP Server"
• Registered 8 new MCP tools for spreadsheet operations

README.md

• Updated title and introduction to include Google Sheets
• Added Google Sheets Support section
• Updated setup instructions to include Google Sheets API enablement
• Added Sheets scope to OAuth configuration steps
• Added comprehensive Google Sheets usage examples
• Introduced a new Google Sheets Usage section with A1 notation guidance
• Updated troubleshooting section

Setup Requirements

For New Users

• Enable Google Sheets API in Google Cloud Console (in addition to Docs and Drive APIs)

• Add the following scope during OAuth consent screen configuration:

  https://www.googleapis.com/auth/spreadsheets
  

Screenshots