Google Sheets

Name: Google Sheets
Brand: Apoth3osis
SKU: 696302894cf4309309cac7b2
Price: 0.05 USD
Availability: InStock

Connector

Available ActionsEach successful request consumes credits as outlined below.

create^5crsearch^5crlist_sheets^5crread^5crget_headers^5crget_data_range^5crappend_rows^5crappend_column^5crupdate_row^5crexport_sheet^5crshare^5cradd_sheet^5crdelete_sheet^5crrename_sheet^5crsort^5crfind_replace^5crformat_cells^5crprotect_range^5crunprotect_range^5cradd_named_range^5crdelete_named_range^5crset_data_validation^5cradd_conditional_formatting^5crcopy_paste^5crcut_paste^5cr

Details

Create, read, update, format, share, and export Google Sheets with agent-safe spreadsheet workflows. Append rows at the true table end, append columns after the last non-empty data column, update selected fields in matched rows, manage tabs, apply validation and formatting, and store CSV/PDF/XLSX exports in File Manager.

Workflows Using This Tool

2 / 12

Workflow

Saves ~45 min

Narrated Walkthrough to a Numbered SOP Document

Turns talking through a job out loud into a written, numbered standard operating procedure. Built for the people who actually know the equipment and have no time to write documentation: maintenance and facilities teams, field service, manufacturing, labs, franchise operations, and any owner trying to get a process out of their own head before handing it over. Walk the machine or the task and narrate it, saying the step number out loud as you go, and the workflow pulls the transcript of each new Plaud recording and turns it into a clean procedure document: a title, the equipment or process it covers, tools and safety notes gathered into their own sections, then numbered steps in the order you said them, with your asides and warnings kept attached to the step they belong to. Filler, false starts and interruptions are dropped; the technical content is left in your words rather than rewritten into corporate documentation voice. It lands as a Google Doc so it stays editable and exports to PDF or Word, and anything the narration left ambiguous is flagged at the end for you to fill in rather than being invented. Say each step number aloud and the transcript carries its own index, which makes pairing photos to steps afterwards mechanical instead of guesswork.

Use Cases

append spreadsheet rows safely, update CRM-style rows by key, export a sheet to CSV or PDF, create reporting spreadsheets, add data validation to templates, protect header ranges, share sheets with collaborators, copy or move spreadsheet ranges, format dashboards, manage sheet tabs

Dynamic MCP Setup

Connect once through AgentPMT Dynamic MCP, then use approved tools from the same agent connection.

30 Second Setup

STDIO connector for Claude Code, Codex, Cursor, Zed, and other LLMs that require STDIO or custom connections.

npm install -g @agentpmt/mcp-routeragentpmt-setup

Hosted Streamable HTTPS

MCP endpoint for browser-based apps like ChatGPT, Claude, Grok, or any time you want a streamable connection with no local install.

https://api.agentpmt.com/mcp

Config Example

Use the hosted endpoint directly in clients that support remote MCP. Store your Bearer token in the client config or secret field.

Full connection guide

{
  "mcpServers": {
    "agentpmt": {
      "type": "streamable-http",
      "url": "https://api.agentpmt.com/mcp",
      "headers": {
        "Authorization": "Bearer <AGENTPMT_BEARER_TOKEN>",
        "x-instance-metadata": "{\"client\":\"generic-mcp\",\"platform\":\"remote\"}"
      }
    }
  }
}

Need client videos, organization controls, audit details, and the full feature overview?

More About Dynamic MCP

Credentials

Google OAuth *

Connect your Google account.

oauth token

Manage credentials in your dashboard.

Actions(25)

create^5cr4 params(1 required)

Create a new spreadsheet, optionally with an initial tab, headers, and rows.

titlerequiredstring

Spreadsheet title.

initial_sheet_namestring

Optional first tab name.

initial_headersarray

Optional first header row.

Array of: string

rowsarray

Optional initial rows as arrays or objects keyed by headers.

Array of: object

search^5cr2 params

Search or list recent Google Sheets spreadsheets.

querystring

Optional search text matched against spreadsheet name/content.

max_resultsinteger

Maximum results to return, 1-100.

Range: 1 - 100

list_sheets^5cr1 param(1 required)

List the tabs in a spreadsheet with sheet ids and dimensions.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

read^5cr5 params(1 required)

Read values from a tab or A1 range. If sheet_name is omitted, resolves the real first tab.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

sheet_namestring

Optional tab name.

sheet_idinteger

Optional numeric sheet id.

rangestring

Optional A1 range. Bare ranges are qualified with sheet_name.

value_render_optionstring

FORMATTED_VALUE, UNFORMATTED_VALUE, or FORMULA.

get_headers^5cr3 params(1 required)

Read the header row and return header-to-column mappings plus duplicate diagnostics.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

sheet_namestring

Optional tab name.

header_rowinteger

One-based header row, default 1.

Range: 1 - ...

get_data_range^5cr3 params(1 required)

Find the last non-empty row/column and recommended append start for a tab.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

sheet_namestring

Optional tab name.

rangestring

Optional A1 range to inspect.

append_rows^5cr5 params(2 required)

Append rows at the true table end. Object rows are mapped by sheet headers.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

rowsrequiredarray

Rows as arrays or objects keyed by headers.

Array of: object

sheet_namestring

Optional tab name.

header_rowinteger

One-based header row, default 1.

Range: 1 - ...

value_input_optionstring

USER_ENTERED or RAW.

append_column^5cr4 params(3 required)

Append one new column immediately after the last non-empty data column and write its header and values.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

column_namerequiredstring

New column header.

column_valuesrequiredarray

Values to write below the header at the data table edge.

Array of: string

sheet_namestring

Optional tab name.

update_row^5cr7 params(2 required)

Update selected columns in a matched row using header names. Touches only requested cells.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

updatesrequiredobject

Column patch keyed by header names.

sheet_namestring

Optional tab name.

row_numberinteger

Optional one-based row number.

Range: 1 - ...

key_columnstring

Header used to find the row when row_number is omitted.

key_valuestring

Value to match in key_column.

multiboolean

Allow all matching rows to update.

export_sheet^5cr7 params(2 required)

Export a specific sheet or whole spreadsheet to File Manager as CSV, TSV, PDF, XLSX, ODS, HTML, or ZIP.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

formatrequiredstring

csv, tsv, pdf, xlsx, ods, html, or zip.

sheet_namestring

Optional tab name for specific-sheet export.

sheet_idinteger

Optional numeric sheet id.

rangestring

Optional range for CSV/TSV exports.

filenamestring

Optional stored filename.

expiration_daysinteger

File Manager expiration, 1-7 days.

Range: 1 - 7

share^5cr5 params(1 required)

Share a spreadsheet with a user, group, domain, or anyone.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

emailstring

Email for user/group shares.

domainstring

Domain for domain shares.

rolestring

reader, commenter, writer, organizer, fileOrganizer, or owner.

permission_typestring

user, group, domain, or anyone.

add_sheet^5cr2 params(2 required)

Add a new tab to a spreadsheet.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

new_sheet_namerequiredstring

New tab name.

delete_sheet^5cr4 params(1 required)

Delete a tab by name, id, or index.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

sheet_namestring

Tab name.

sheet_idinteger

Numeric sheet id.

sheet_indexinteger

Zero-based tab index.

rename_sheet^5cr5 params(2 required)

Rename a tab by name, id, or index.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

new_sheet_namerequiredstring

New tab name.

sheet_namestring

Current tab name.

sheet_idinteger

Numeric sheet id.

sheet_indexinteger

Zero-based tab index.

sort^5cr4 params(3 required)

Sort a range, preferably by header name.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

rangerequiredstring

A1 range to sort.

sort_specsrequiredarray

Sort specs with header/column_name or dimensionIndex and order/sortOrder.

Array of: object

sheet_namestring

Optional tab name when range is bare A1 notation.

find_replace^5cr7 params(3 required)

Find and replace text across the spreadsheet or one sheet.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

findrequiredstring

Text or regex to find.

replacementrequiredstring

Replacement text.

sheet_namestring

Optional tab limit.

match_caseboolean

Case-sensitive match.

match_entire_cellboolean

Match entire cell contents only.

search_by_regexboolean

Treat find as regex.

format_cells^5cr5 params(2 required)

Apply cell formatting or number format to a range.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

rangerequiredstring

A1 range to format.

sheet_namestring

Optional tab name.

cell_formatobject

Text/background/alignment/wrap formatting.

number_formatobject

Sheets numberFormat object.

protect_range^5cr6 params(2 required)

Protect a range, optionally warning-only or with explicit editor emails.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

rangerequiredstring

A1 range to protect.

sheet_namestring

Optional tab name.

descriptionstring

Protection description.

warning_onlyboolean

If true, warn instead of blocking edits.

editor_emailsarray

Users allowed to edit protected range.

Array of: string

unprotect_range^5cr2 params(2 required)

Remove protection by protected range id.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

protected_range_idrequiredinteger

Google protectedRangeId to delete.

add_named_range^5cr4 params(3 required)

Create a named range.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

rangerequiredstring

A1 range.

namerequiredstring

Named range name.

sheet_namestring

Optional tab name.

delete_named_range^5cr2 params(2 required)

Delete a named range by id.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

named_range_idrequiredstring

Google namedRangeId to delete.

set_data_validation^5cr4 params(3 required)

Set a Sheets data validation rule on a range.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

rangerequiredstring

A1 range.

validation_rulerequiredobject

Sheets DataValidationRule object.

sheet_namestring

Optional tab name.

add_conditional_formatting^5cr4 params(3 required)

Add a conditional formatting rule to a range.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

rangerequiredstring

A1 range for the rule.

rulerequiredobject

Sheets ConditionalFormatRule object; ranges can be omitted.

sheet_namestring

Optional tab name.

copy_paste^5cr6 params(3 required)

Copy a source range to a destination range.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

source_rangerequiredstring

A1 source range.

destination_rangerequiredstring

A1 destination range.

sheet_namestring

Optional tab name.

paste_typestring

Sheets pasteType such as PASTE_NORMAL or PASTE_VALUES.

paste_orientationstring

NORMAL or TRANSPOSE.

cut_paste^5cr5 params(3 required)

Move a source range to a destination start cell.

spreadsheet_idrequiredstring

Google spreadsheet id or URL.

source_rangerequiredstring

A1 source range.

destination_rangerequiredstring

A1 destination start cell.

sheet_namestring

Optional tab name.

paste_typestring

Sheets pasteType such as PASTE_NORMAL or PASTE_VALUES.

curl -X POST "https://api.agentpmt.com/products/purchase" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer ********" \
  -d '{
    "product_id": "696302894cf4309309cac7b2",
    "parameters": {
      "action": "create",
      "title": "example_title"
    }
  }'

import requests
import json

url = "https://api.agentpmt.com/products/purchase"

headers = {
    "Content-Type": "application/json",
    "Authorization": "Bearer ********"
}

data = {
    "product_id": "696302894cf4309309cac7b2",
    "parameters": {
        "action": "create",
        "title": "example_title"
    }
}

response = requests.post(url, headers=headers, json=data)
print(response.status_code)
print(response.json())

const url = "https://api.agentpmt.com/products/purchase";

const headers = {
  "Content-Type": "application/json",
  "Authorization": "Bearer ********"
};

const data = {
  product_id: "696302894cf4309309cac7b2",
  parameters: {
    "action": "create",
    "title": "example_title"
  }
};

fetch(url, {
  method: "POST",
  headers,
  body: JSON.stringify(data)
})
  .then(response => response.json())
  .then(data => console.log(data))
  .catch(error => console.error("Error:", error));

const axios = require('axios');

const url = "https://api.agentpmt.com/products/purchase";

const headers = {
  "Content-Type": "application/json",
  "Authorization": "Bearer ********"
};

const data = {
  product_id: "696302894cf4309309cac7b2",
  parameters: {
    "action": "create",
    "title": "example_title"
  }
};

axios.post(url, data, { headers })
  .then(response => {
    console.log(response.status);
    console.log(response.data);
  })
  .catch(error => {
    console.error("Error:", error.message);
  });

Login to view your API and budget keys. The example above uses placeholder values. Sign in to see personalized code with your bearer token.

Autonomous agents can access this tool through AgentAddress credit balances or direct x402 payments. Use the Autonomous Agent API reference for endpoint shapes after choosing the access pattern below.

Recommended

Credit-Based Access Using AgentAddress

AgentAddress is preferred when an autonomous agent needs persistent file access, stored platform state, or maximum tool use ability across repeated calls.

Open Credit-Based Access Using AgentAddress

Direct x402 Payment

Use direct x402 for independent one-off tool calls that do not require shared files or stored platform state.

Accepted public payments

Stablecoin: USDC
Chains: Base, Arbitrum, Optimism, Polygon, and Avalanche

Direct x402 payments are not enabled for this product; use AgentAddress credit access instead.

Product Skill Package

This product has a published Agent Skill package. Install it when an autonomous agent needs product-specific operating instructions in its local skill registry.

Download SKILL.md View package source OpenClaw listing

OpenClaw install

skills.sh install

Usage Instructions

Usage guidance provided directly by the developer for this product.

Google Sheets

Use short action names. Prefer read, append_rows, append_column, update_row, and export_sheet for common workflows.

Safety rules:

Do not guess a tab is named Sheet1; omit sheet_name or call list_sheets.
Do not calculate append row or column positions; use append_rows or append_column.
append_rows appends at the true table end. append_column writes after the last non-empty data column, not at a blank default grid edge.
Do not overwrite full rows when only selected fields changed; use update_row with updates.
Use export_sheet for CSV/TSV/PDF/XLSX/ODS/HTML/ZIP exports. Specific-sheet rendered exports use an official temporary-spreadsheet flow.

Examples:

{"action":"read","spreadsheet_id":"1abc...","sheet_name":"Leads","range":"A1:D20"}

{"action":"append_rows","spreadsheet_id":"1abc...","sheet_name":"Leads","rows":[{"Name":"Ada","Status":"New"}]}

{"action":"append_column","spreadsheet_id":"1abc...","sheet_name":"Leads","column_name":"Owner","column_values":["Sam","Riley"]}

{"action":"update_row","spreadsheet_id":"1abc...","sheet_name":"Leads","key_column":"Email","key_value":"ada@example.com","updates":{"Status":"Qualified","Owner":"Sam"}}

{"action":"export_sheet","spreadsheet_id":"1abc...","sheet_name":"Leads","format":"pdf","filename":"leads.pdf"}

Frequently Asked Questions

How do I connect this tool to an external agent?

You can install the local MCP server by opening a terminal and running:

Install commands

npm install -g @agentpmt/mcp-router
agentpmt-setup

This will connect you to local agents like Claude Code, Windsurf, Grok Build, Cursor, etc.

Alternatively you can connect to the hosted version with this config block, no installation required:

Hosted MCP config

{
  "mcpServers": {
    "agentpmt": {
      "type": "streamable-http",
      "url": "https://api.agentpmt.com/mcp",
      "headers": {
        "Authorization": "Bearer <AGENTPMT_BEARER_TOKEN>",
        "x-instance-metadata": "{\"client\":\"generic-mcp\",\"platform\":\"remote\"}"
      }
    }
  }
}

View MCP Connection Instructions for more details.

How does an external agent use this tool?

After the external agent is connected to an Agent Group that can use this tool, paste this prompt into the agent:

Agent prompt

Use the AgentPMT-Tool-Search-and-Execution tool. First call action 'get_instructions' so you know how to use the tool search interface. Then call action 'get_schema' with tool_id 696302894cf4309309cac7b2 ("Google Sheets"). After reading the schema and any returned instructions, tell me what this tool can do, we are going to be using it

The agent should fetch the tool schema first, collect the required parameters for your request, and then call the tool through AgentPMT.

Google Sheets

Available ActionsEach successful request consumes credits as outlined below.

Details

Workflows Using This Tool

Narrated Walkthrough to a Numbered SOP Document

Use Cases

Dynamic MCP Setup

30 Second Setup

Hosted Streamable HTTPS

Config Example

Frequently Asked Questions

How do I connect this tool to an external agent?

How does an external agent use this tool?

Looking for help integrating AI into your business? Set up a free consultation.