mcp-google-sheets

1. list_spreadsheets

Lists spreadsheets in the configured Drive folder (Service Account) or accessible by the user (OAuth).

2. create_spreadsheet

Creates a new spreadsheet with the specified title.

3. get_sheet_data

Reads data from a range in a sheet, optionally including formatting metadata.

4. get_sheet_formulas

Reads formulas from a range in a sheet.

5. update_cells

Writes data to a specific range, overwriting existing data.

6. batch_update_cells

Updates multiple ranges in one API call.

7. add_rows

Appends rows to the end of a sheet after the last row with data.

8. list_sheets

Lists all sheet names within a spreadsheet.

9. create_sheet

Adds a new sheet (tab) to a spreadsheet.

10. get_multiple_sheet_data

Fetches data from multiple ranges across potentially different spreadsheets in one call.

11. get_multiple_spreadsheet_summary

Gets titles, sheet names, headers, and first few rows for multiple spreadsheets.

12. share_spreadsheet

Shares a spreadsheet with specified users/emails and roles.

13. add_columns

Adds columns to a sheet.

14. copy_sheet

Duplicates a sheet within a spreadsheet.

15. rename_sheet

Renames an existing sheet.

{
  "mcpServers": {
    "google-sheets": {
      "command": "uvx",
      "args": ["mcp-google-sheets@latest"],
      "env": {
        "SERVICE_ACCOUNT_PATH": "/full/path/to/your/service-account-key.json",
        "DRIVE_FOLDER_ID": "your_shared_folder_id_here"
      }
    }
  }
}