Correct cells in a Google Sheet by writing values to an exact range, overwriting existing data. Read back the sheet to verify the intended values are now in place.
MIT
Destructive
677,876 tools. Updated 2026-10-19 16:50
"How to read and write data in Zoho Sheet" matching MCP tools:
- Read cell values from a Google Sheet to reveal the header row and data boundaries before writing, so values can be placed in the correct columns and next free row.MIT
- Read data from an Excel range or retrieve a sheet summary. Optionally fetch detailed cell information, formulas, and formatting, or read all sheets in one call.MIT
- Fetch a character sheet by ID, preserving unknown fields and game-system-specific data. Use character_list to find IDs, then retrieve the full sheet for CoC or DND.MIT
- Write a 2D list of values to an Excel sheet starting at a given cell, automatically extending the sheet's used range.MIT
- Compute Pearson correlation matrix for numeric columns in an Excel sheet. Optionally select columns or write results to an output sheet or file.MIT
Matching MCP Servers
- AlicenseNot gradedqualityBmaintenanceLandlord and rental-property calculators as MCP tools: cash flow, cap rate, DSCR, Airbnb break-even occupancy, rent late fees, lease notice dates, and IRS mileage. Offline and deterministic, with no dependencies.MIT
- AlicenseNot gradedqualityCmaintenanceEnables AI agents to build and edit real HTML/CSS designs on a live canvas through 35 MCP tools, letting them inspect screenshots, computed styles and layout, then export production-ready React or Tailwind code. Humans can refine the same layers visually in a macOS editor.6,734 npmMIT
Matching MCP Connectors
Zoho MCP allows you to create your own MCP server to perform complex actions in a host of Zoho applications and 500+ third-party services
India Open Government Data (OGD) Platform MCP — data.gov.in
- Read cell values from a Google Sheets range, tab, or entire workbook. Choose formatted, raw, or formula output, and optionally write results to a YAML file.BSD 3-Clause
- Write and read structured data across pipeline phases to coordinate multi-step workflows.MIT
- Returns the structural schema of a sheet tab to reveal column names, data types, dropdown options, checkboxes, and formula-protected fields. Use before write operations to understand column constraints.MIT
- Retrieve data from any Zoho Books endpoint by specifying the API path. Use GET requests to access invoices, contacts, chart of accounts, and more.MIT
- Build a pivot table from specified columns in a source sheet, aggregate values with sum, mean, or custom functions, and optionally write the result to a new sheet or file.MIT
- Check which Zoho organization is connected, view granted scopes, and see remaining per-minute and daily API budget without spending Zoho API calls.MIT
- Identify write tools disabled by SPARDA's write-safety and learn how to enable them.Business Source 1.1
- Read spreadsheet data from .xlsx or .csv files. Retrieve headers and rows (up to 200) with optional sheet name and cell range for .xlsx.MIT
- Write data to a specified range in a Google Sheet as literal text to prevent formula injection.MIT
- Write a 2D array of data or a single-cell formula to Excel, starting from a specified cell.MITDestructive
- Read data from a Google Sheet range, returning rows as objects with header keys. Supports formatted, unformatted, or formula values.MIT
- Export a complete Zoho project to your local machine, generating project.json with all data and an images folder for attachments. Facilitates moving projects to other systems.MIT
- Extract data from a specific sheet in Excel files by specifying the sheet name. Reads the first sheet by default when no name is provided, returning structured JSON output.Apache 2.0
- Write, update, or clear cell values in a specific range of a Google Sheet using your Google account.MIT
- Write values, numbers, booleans, or formulas to any Excel cell by specifying file, sheet, and coordinate. Optionally create a backup before modifying.MIT