"How to Edit Google Sheets" matching MCP tools:

• content.downloadA

  notebooklm-mcp

  Download or export generated NotebookLM content as audio, video, infographic, or export to Google Slides and Sheets.

  MIT

• sheets_get_metadataA

  mcp-gsheets

  Retrieve metadata from a Google Sheets spreadsheet, including sheet names, IDs, and properties, by providing the spreadsheet ID.

  MIT

• sheets_insert_dateA

  mcp-gsheets

  Insert dates into Google Sheets with locale-aware formatting and automatic format detection. Supports various date formats and relative dates.

  MIT

• sheets_append_valuesA

  mcp-gsheets

  Append rows of data to the end of a table in Google Sheets, either overwriting empty cells or inserting new rows.

  MIT

• sheets_batch_delete_sheetsB

  mcp-gsheets

  Delete multiple sheets from a Google spreadsheet in one operation. Specify spreadsheet ID and sheet IDs to remove unwanted sheets simultaneously.

  MIT

• sheets_delete_chartB

  mcp-gsheets

  Remove a chart from a Google Sheets document. Specify the spreadsheet ID and chart ID; locate chart IDs with sheets_get_metadata.

  MIT

• sheets_update_chartB

  mcp-gsheets

  Update an existing chart in a Google Sheets spreadsheet by modifying its title, type, series, axes, legend, position, colors, and accessibility settings.

  MIT

• sheets_duplicate_sheetB

  mcp-gsheets

  Duplicate a sheet in a Google Sheets spreadsheet. Specify the source sheet ID and optionally set a new name and insertion position.

  MIT

• sheets_clear_valuesB

  mcp-gsheets

  Clear cell values in a Google Sheets spreadsheet by specifying the range in A1 notation. Removes data while preserving formatting.

  MIT

• sheets_get_valuesB

  mcp-gsheets

  Retrieve cell values from a Google Sheets spreadsheet using spreadsheet ID and A1 notation range. Returns data in the requested dimension and format.

  MIT

• sheets_insert_linkB

  mcp-gsheets

  Add clickable hyperlinks to any cell range in Google Sheets with custom link text.

  MIT

• sheets_insert_sheetB

  mcp-gsheets

  Add a new sheet to a Google Sheets spreadsheet by providing spreadsheet ID and sheet title. Optionally set index, row count, and column count.

  MIT

• sheets_batch_get_valuesB

  mcp-gsheets

  Retrieve cell values from multiple ranges in a Google Sheets spreadsheet in a single operation.

  MIT

• sheets_copy_toB

  mcp-gsheets

  Copy a sheet from one Google Sheets spreadsheet to another by providing the source sheet ID and destination spreadsheet ID.

  MIT

• sheets_delete_sheetB

  mcp-gsheets

  Delete a specific sheet from a Google Sheets spreadsheet by providing the spreadsheet ID and sheet ID.

  MIT

• sheets_create_spreadsheetB

  mcp-gsheets

  Create a new Google Sheets spreadsheet with a specified title and optional sheets configuration including name, row count, and column count.

  MIT

• sheets_update_sheet_propertiesC

  mcp-gsheets

  Update a sheet's title, tab color, grid size, or frozen rows/columns in a Google Sheets spreadsheet.

  MIT

• get_drive_file_download_urlA

  Hardened Google Workspace MCP

  Generate secure download URLs for Google Drive files, converting Google Docs, Sheets, and Slides to PDF, DOCX, XLSX, CSV, or PPTX formats for safe access.

  MIT

• create_script_project_toolA

  Apps Script MCP

  Create new Google Apps Script projects, either standalone or bound to Google Docs, Sheets, Forms, or Slides for document-specific automation.

  MIT

• copy_drive_fileA

  Google Workspace MCP VE

  Duplicate a Google Drive file, including Google Docs, Sheets, or Slides. Preserves formatting and content; optionally rename or place in a different folder.

  MIT