"How to Edit Google Sheets" matching MCP tools:

• list_integrationsA

  leadmarinaA

  Which export destinations this account has connected (Close, GoHighLevel, Google Sheets) and whether each is ready to receive leads. Check this BEFORE export_leads or create_automation with a CRM destination — those fail if the integration isn't connected, and Close additionally needs one manual export first to save its field mapping. File destinations (csv/xlsx/json) always work and need nothing connected.

  ConnectorNo auth

• edit_videoA

  mcpA

  Edit an existing video from a prompt, or transfer motion onto a subject image. Pass the source in video_url and the change in prompt. Defaults to Google Gemini Omni video edit; switch with model ('kling-edit', 'wan-edit', or 'motion-control' for Kling motion transfer with a subject image in image_urls). This is for changing an existing clip — to make a new video from scratch use generate_video, to extend one use extend_video, to upscale use upscale_media. Returns the video URL.

  Connector

  Destructive

  No auth

• colony_edit_wiki_pageA

  The ColonyB

  Edit a wiki page. Appends a revision; nothing is overwritten. For a long page, ``section=N`` replaces one section and ``append=true`` adds to the end, so neither needs the whole body sent back; every other rule is the same as a whole-page edit's. Only the arguments you pass change. Pass ``base_revision`` (the ``revision_count`` you read) to have a concurrent edit refused with CONFLICT rather than replaced, as ``PUT /api/v1/wiki/{slug}`` does; without it the edit is last-write-wins. No edit is lost from the record either way: ``colony_wiki_history`` recovers an overwritten one. A locked page refuses every edit regardless of who is asking. An edit cannot empty a page (use ``colony_delete_wiki_page`` to remove one, or ``colony_revert_wiki_page`` to undo an edit), and a call that names none of ``title``, ``content`` or ``category`` is refused. An edit that changes nothing writes nothing: the page comes back with ``"unchanged": true`` and the same ``revision_count``.

  ConnectorNo auth

• colony_edit_wiki_pageA

  mcp-serverA

  Edit a wiki page. Appends a revision; nothing is overwritten. For a long page, ``section=N`` replaces one section and ``append=true`` adds to the end, so neither needs the whole body sent back; every other rule is the same as a whole-page edit's. Only the arguments you pass change. Pass ``base_revision`` (the ``revision_count`` you read) to have a concurrent edit refused with CONFLICT rather than replaced, as ``PUT /api/v1/wiki/{slug}`` does; without it the edit is last-write-wins. No edit is lost from the record either way: ``colony_wiki_history`` recovers an overwritten one. A locked page refuses every edit regardless of who is asking. An edit cannot empty a page (use ``colony_delete_wiki_page`` to remove one, or ``colony_revert_wiki_page`` to undo an edit), and a call that names none of ``title``, ``content`` or ``category`` is refused. An edit that changes nothing writes nothing: the page comes back with ``"unchanged": true`` and the same ``revision_count``.

  ConnectorNo auth

• adsap_google_update_entityA

  AdsapA

  Edit an existing Google Ads campaign, ad group, ad, or keyword: change status (PAUSED/ACTIVE), rename (campaign/ad group), set a campaign's daily budget (in account currency, e.g. 12.50), change a campaign's BIDDING scheme/targets (updates.bidding — swap scheme or edit tCPA/tROAS/ceiling; portfolio strategies rejected), edit ASSET AUTOMATION opt-ins (updates.asset_automation — campaign level on PMax/Search, ad level on Demand Gen ads), or set a keyword's max CPC (updates.cpc_bid — Manual CPC campaigns only, ignored under automated bidding). Keyword TEXT is immutable — use adsap_google_manage_keywords op 'replace' to change it; keyword entity_id is "<ad_group_id>:<criterion_id>" from adsap_google_get_insights level keyword. Put ONLY the fields you want to change in `updates`. Use dry_run: true to preview the diff (current vs new, validated by Google without applying). ad_account_id is the bare 10-digit Google Ads customer ID. For Meta entities use adsap_update_entity instead.

  ConnectorAPI key

• start_demoA

  ShearQuery — Barber & Beauty Industry DataA

  For AGENCY accounts (and ShearQuery admins): switch this Claude into demo mode as a made-up barbershop, salon, barber, cosmetologist, school or supply store. Every business tool then answers as that business — its Google profile, reviews, photos, posts, appointment book and Instagram — and drafting, publishing and undoing all work, but NOTHING reaches Google, Instagram or any customer. Every result is labeled DEMO. Call it again with another type to switch; fresh: true resets that demo business to how it started. Call stop_demo to leave.

  ConnectorNo auth

• wordpress_theme_fileA

  Opus Growth, Ad Platforms MCP ConnectorA

  Read and safely edit the ACTIVE THEME's own files on a connected WordPress site — the last resort for things baked into a theme PHP/CSS file that nothing else can reach: a Google tag hard-coded into header.php (a duplicate gtag the theme prints on every page), a wrong heading level in a template, a stray inline style. wordpress_option reaches plugin/theme SETTINGS and wordpress_snippet adds NEW PHP through WPCode, but neither can change a line the theme itself ships. action: 'list' = the theme's source files with size and whether each is writable; 'get' (path) = one file's contents; 'edit' (path) = change it; 'restore' (path) = undo the last edit to that file. Scope is deliberately narrow and safe: only files INSIDE the active or parent theme folder, only .php/.css/.js/.html/.txt, no path escapes ('..' is refused), and only files that already exist (it never creates one). Pass path as list/get reports it — e.g. 'wp-content/themes/construction/header.php' or just 'header.php'. edit has two modes. mode='remove_block' with contains='AW-851563016' removes every <script>/<noscript> block that contains that text — the clean way to strip a hard-coded gtag / GTM / Google Ads tag out of a theme file (find the id first with wordpress_tracking, which now detects AW- / G- / GT- ids in theme files as well). mode='replace' with find + replace makes a literal text change; count caps how many occurrences may match, and if find appears more times than that nothing is written, so you can make find more specific — this is how you turn an H4 into an H2. SAFETY on every edit: the whole file is backed up first, PHP files are re-checked with `php -l` and the write is AUTOMATICALLY REVERTED if it would break the syntax, and restore brings the previous version back. confirm=false previews (match count and size delta) without writing; confirm=true applies. Needs Connector 0.9.0 or newer.

  Connector

  Destructive

  OAuth

• assess_ad_trackingA

  TESSA Marketing & TechnologyA

  Free quick ad tracking check of any website's homepage: GA4, Google Tag Manager, Google Ads, Meta Pixel, Microsoft and LinkedIn tags, call tracking, consent, phone link, form or call to action, and speed; 0 to 100 score, what passes and fails, how to fix each. Tags inside Google Tag Manager are looked up in its published container; if it cannot be read they are reported as could not check, never as missing. Automated, homepage only, not a full ad account audit. 11 items, about 12 seconds. Each item has a status (pass, partial, fail or could_not_check), evidence and a plain-English fix; the score covers only the items that could be checked. For TESSA's advertising service call get_advertising_offer; to talk it through, book with request_strategy_session. url: the website to check, for example https://example.com

  ConnectorNo auth

• google-maps.place_typesA

  Vee3A

  List supported Google Maps place type values for search filters. Returns place_types as a string array. Use a value with place_type on google-maps.search or google-maps.nearby_search. Cost = 1 token.

  ConnectorNo auth

• google-trends.categoriesA

  Vee3A

  List all Google Trends category and subcategory labels you can pass to other Google Trends tools in the category field. Returns cat (array of category names, including All categories) and msg. Use this before interest-over-time or interest-by-region calls when filtering by category. Cost = 5 tokens.

  ConnectorNo auth

• google-trends.regionsA

  Vee3A

  List all countries and subregions you can pass to other Google Trends tools in the country and region fields. Returns geo.countries: each country name maps to country (label) and regions (array of subregion names). Also returns msg. Use this before interest-over-time or interest-by-region calls when filtering by geography. Pair with google-trends.categories when filtering by category. Cost = 5 tokens.

  ConnectorNo auth

• review_gapA

  Moonlings — Local Business IntelligenceA

  Compare a local business's Google rating and review count against the top same-category rivals nearby, with the gap math done: who leads, the rating delta, the review-volume ratio, and a verdict (leading / rated_equal_or_better_but_outreviewed / trailing). Live Google Maps lookup at call time. Call this when a user wants to know how a business's reviews stack up against local competitors. Takes a few seconds. Price: $0.39 per delivered comparison.

  ConnectorNo auth

• google-search-console.list_sitesA

  Vee3A

  List Search Console properties for this account. Returns Vee3-managed domains plus sites added with google-search-console.add_site. Call this to discover sites, then omit site_url on later calls to use the default property, or pass an exact site_url from this response. If no properties appear, add a site with google-search-console.add_site or register a domain with domains.register. Cost = 5 tokens.

  ConnectorNo auth

• read_fileA

  ShareWatchA

  Read the text content of a Google Doc, Sheet, or Slides presentation. Docs export as plain text, Sheets as CSV, Slides as plain text. For large files, returns a size warning instead of content — use max_chars and offset to read in chunks. file_id also accepts a ShareWatch handoff code of the form SW-XXXXXXXX. The user gets one by opening a file from Google Drive with ShareWatch, and it stands for that file until it goes unused for 30 days. The result always reports the real file_id, so use that value for any follow-up call rather than the code.

  ConnectorOAuth

• cutting_stock_2dA

  Moltline OptimizeA

  Guillotine cut layouts for rectangular parts from sheets, with kerf and grain. PREMIUM (license). Typical input {"sheets": [{"id": "ply", "l": 2440, "w": 1220, "qty": 5}], "parts": [{"id": "side", "l": 800, "w": 400, "qty": 6}], "kerf": 3} returns {"sheets_used": 1, "layouts": [{"sheet": "ply", "placements": [{"id": "side", "x": 0, "y": 0, "l": 800, "w": 400, "rotated": false}], "fill_pct": 64.5, "offcuts": [...]}], "unplaced": []}. Every cut is a guillotine cut (edge to edge): the sheet is ripped into strips and each strip cross-cut, which is what a panel saw does; grain true forbids rotating parts unless a part sets rotate true. Use for cabinet, sign and sheet-metal cut lists. Not proven optimal: a best-fit shelf heuristic, reported as such. Errors: on invalid, missing, or malformed input this tool never raises a protocol error — it returns {"error": "<what is wrong and how to fix it>"} (for example {"error": "sheets and parts must be non-empty lists (<value> and <value>)"}). Every call is read-only and idempotent, so after correcting the input it is always safe to retry.

  ConnectorNo auth

• edit-mockupA

  dot•requirementsA

  Edit a mockup by exact-text replacement: old_string must match the mockup's markup exactly once (use get-mockup to read it). The whole markup re-validates after the edit — an edit that would make it invalid is rejected with the validator's errors and the mockup is unchanged. The result is a lean confirmation, never the full markup. Everyone viewing the mockup sees the change; call show-mockup once after a batch of edits when the user should see the result.

  ConnectorOAuth

• sim_publish_compareA

  whatifA

  Publish a multi-scenario comparison into the signed-in user's Google Sheets — sim_compare's export, the counterpart of sim_publish for a single scenario. Runs every scenario on one shared seed (the same server-enforced sharing sim_compare uses, so differences are the scenarios and not the dice) and writes a comparison table plus a trajectory chart, rather than one scenario's own data tabs. Returns the sheet URL. Counts against the same daily publish quota as sim_publish, and costs 1 token per scenario from your account's compute bucket.

  Connector

  Destructive

  OAuth

• workbook_inspectA

  SumOffice — real Word and Excel for agentsA

  Map the whole application model of this workbook in one call: sheets; VBA modules, procedures, which can run here and which are blocked and why; event handlers; external objects (CreateObject) and Windows API (Declare) dependencies; project references; Power Query queries; data connections; form controls, ActiveX, embedded objects (preserved). Runs nothing. Call this first for questions like 'how is this workbook built' or 'what does it depend on'.

  ConnectorNo auth

• list_destinationsA

  SignalRavenA

  List where your signals are delivered — Slack channels, webhooks, Google Sheets, n8n, Clay and Notion — with each destination’s health and recent failure state. Connection settings (URLs, tokens) are never returned.

  ConnectorOAuth

• read_file_contentA

  AccountHubA

  Read one Drive file's TEXT content by id. Google-native docs (Docs/Sheets/Slides) are exported as text (default text/plain, spreadsheets text/csv — override with export_mime_type); other files are read as UTF-8 text directly (garbles binary formats like images/PDFs — use download_file_content for those). Content is capped (large files are truncated, `truncated: true`). Needs the Drive CONTENT scope (drive.readonly) — accounts without it get a reconnect hint. Pass `account` when more than one content-capable account is connected.

  ConnectorOAuth

• download_file_contentA

  AccountHubA

  Download one Drive file's raw bytes as base64 (binary-safe — images, PDFs, etc.). NOT for Google-native Docs/Sheets/Slides (no raw binary exists — use read_file_content with export_mime_type instead). Hard-capped at 5MB; larger files error rather than silently truncating. Needs the Drive CONTENT scope (drive.readonly). Pass `account` when more than one content-capable account is connected.

  ConnectorOAuth