"Tools and methods for analyzing Google Sheets data" matching MCP tools:

• search_exportersA

  Databar MCP Server

  Find the right data exporter for pushing data to external services like Google Sheets, HubSpot, or Salesforce. Search by query and get matching exporters with IDs and descriptions.

  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_create_chartB

  mcp-gsheets

  Create a chart in a Google Sheets spreadsheet with specified type, position, and data series. Customize with title, axes, legend, and more.

  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_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_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_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_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_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_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_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_delete_sheetB

  mcp-gsheets

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

  MIT

• sheets_batch_get_valuesB

  mcp-gsheets

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

  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

• 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