Google Sheets by Apoth3osis

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

Google Sheets

Connector

Available ActionsEach successful request consumes credits as outlined below.

create_spreadsheet^5crget_spreadsheet^5crupdate_spreadsheet_properties^5crsearch_spreadsheets^5crlist_sheets^5cradd_sheet^5crdelete_sheet^5crduplicate_sheet^5crrename_sheet^5crupdate_sheet_properties^5crget_values^5crbatch_get_values^5crget_sheet_data^5crsearch_values^5crupdate_values^5crbatch_update_values^5crappend_values^5crclear_values^5crbatch_clear_values^5crformat_cells^5crset_number_format^5crmerge_cells^5crunmerge_cells^5crset_borders^5crinsert_rows^5crinsert_columns^5crdelete_rows^5crdelete_columns^5crresize_dimensions^5crauto_resize_dimensions^5crsort_range^5crfind_replace^5crcopy_paste^5crcut_paste^5crset_basic_filter^5crclear_filter^5crprotect_range^5crunprotect_range^5cradd_named_range^5crdelete_named_range^5crset_data_validation^5cradd_conditional_formatting^5crbatch_update^5crshare_spreadsheet^5cr

Details

Comprehensive Google Sheets integration tool that enables AI agents to perform all spreadsheet operations through OAuth authentication. This tool provides full access to Google Sheets functionality including creating and managing spreadsheets, reading and writing data with support for formulas and batch operations, managing sheets and tabs with adding deleting and renaming capabilities, applying advanced cell formatting with colors fonts and number formats, inserting and deleting rows and columns with automatic resizing, sorting and filtering data with complex criteria, and executing find and replace operations across entire spreadsheets. The tool supports both single and batch operations for optimal performance, handles all Google Sheets data types including formulas dates and currency, provides granular control over cell formatting and sheet properties, and includes advanced features like merging cells setting filters and protecting ranges. Perfect for data analysis reporting automation spreadsheet generation and collaborative document management workflows.

Use Cases

automated report generation, data import and export, spreadsheet templating, bulk data updates, financial modeling, inventory management, dashboard creation, collaborative data entry, formula automation, batch formatting operations

Credentials

Google OAuth *

Connect your Google account.

oauth token

Manage credentials in your dashboard.

Actions(44)

create_spreadsheet^5cr2 params(1 required)

Create a new Google Sheets spreadsheet.

titlerequiredstring

Title for the new spreadsheet

initial_dataobject

Initial data for the first sheet. Contains 'sheet_name' (string) and 'values' (2D array).

Properties:

sheet_name(string)- Name for the initial sheet (defaults to Sheet1)

values(array)- 2D array of initial values

get_spreadsheet^5cr1 param(1 required)

Get spreadsheet metadata including title, sheets, locale, and timezone.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

update_spreadsheet_properties^5cr2 params(1 required)

Update spreadsheet-level properties such as the title.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

titlestring

New title for the spreadsheet

search_spreadsheets^5cr2 params

Search for Google Sheets spreadsheets by name. Returns results sorted by most recently modified.

querystring

Search query matching against spreadsheet name (contains match). Omit to list recent spreadsheets.

max_resultsinteger

Maximum results to return (1-100)

Default: 20

Range: 1 - 100

list_sheets^5cr1 param(1 required)

List all sheets/tabs in a spreadsheet.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

add_sheet^5cr6 params(2 required)

Add a new sheet/tab to a spreadsheet.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

new_sheet_namerequiredstring

Name for the new sheet

tab_colorobject

RGB color for sheet tab (values 0-1)

Properties:

red(number)- Red component (0-1)

green(number)- Green component (0-1)

blue(number)- Blue component (0-1)

hiddenboolean

Whether the sheet should be hidden

num_rowsinteger

Number of rows for the new sheet

Range: 1 - ...

num_columnsinteger

Number of columns for the new sheet

Range: 1 - ...

delete_sheet^5cr4 params(1 required)

Delete a sheet/tab from a spreadsheet.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

sheet_namestring

Name of the sheet to delete

sheet_idinteger

Numeric ID of the sheet

sheet_indexinteger

0-based index of the sheet

duplicate_sheet^5cr5 params(1 required)

Duplicate an existing sheet within the same spreadsheet.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

sheet_namestring

Name of the sheet to duplicate

sheet_idinteger

Numeric ID of the sheet to duplicate

sheet_indexinteger

0-based index of the sheet to duplicate

new_sheet_namestring

Name for the duplicated sheet

rename_sheet^5cr5 params(2 required)

Rename a sheet/tab.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

new_sheet_namerequiredstring

New name for the sheet

sheet_namestring

Current name of the sheet to rename

sheet_idinteger

Numeric ID of the sheet

sheet_indexinteger

0-based index of the sheet

update_sheet_properties^5cr7 params(1 required)

Update sheet-level properties (title, tab color, visibility).

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

sheet_namestring

Name of the sheet to update

sheet_idinteger

Numeric ID of the sheet

new_sheet_namestring

New name for the sheet

tab_colorobject

RGB color for sheet tab (values 0-1)

Properties:

red(number)- Red component (0-1)

green(number)- Green component (0-1)

blue(number)- Blue component (0-1)

hiddenboolean

Whether sheet should be hidden

right_to_leftboolean

Whether sheet should use right-to-left layout

get_values^5cr4 params(2 required)

Read values from a single range.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

rangerequiredstring

A1 notation range (e.g., 'Sheet1!A1:C10')

value_render_optionstring

How to return values

Values:

FORMATTED_VALUEUNFORMATTED_VALUEFORMULA

Default: FORMATTED_VALUE

major_dimensionstring

Whether to interpret arrays as rows or columns

Values:

ROWSCOLUMNS

Default: ROWS

batch_get_values^5cr4 params(2 required)

Read values from multiple ranges at once.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

rangesrequiredarray

Array of A1 notation ranges

Array of: string

value_render_optionstring

How to return values

Values:

FORMATTED_VALUEUNFORMATTED_VALUEFORMULA

Default: FORMATTED_VALUE

major_dimensionstring

Whether to interpret arrays as rows or columns

Values:

ROWSCOLUMNS

Default: ROWS

get_sheet_data^5cr2 params(1 required)

Get all data from a specific sheet.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

sheet_namestring

Name of the sheet (defaults to 'Sheet1')

search_values^5cr6 params(1 required)

Search for text within a spreadsheet.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

findstring

Text to search for (or use 'search_query' as alias)

search_querystring

Alias for 'find'

rangestring

A1 notation range to limit the search

match_caseboolean

Whether search is case-sensitive

match_entire_cellboolean

Whether to match entire cell contents only

update_values^5cr7 params(3 required)

Write values to a single range (overwrites existing data).

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

rangerequiredstring

A1 notation range

valuesrequiredarray

2D array of values (outer array = rows, inner arrays = columns)

Array of: array

value_input_optionstring

How to interpret input values

Values:

USER_ENTEREDRAW

Default: USER_ENTERED

major_dimensionstring

Whether to interpret arrays as rows or columns

Values:

ROWSCOLUMNS

Default: ROWS

include_values_in_responseboolean

Whether to return updated values in response

response_value_render_optionstring

How to render values in response

Values:

FORMATTED_VALUEUNFORMATTED_VALUEFORMULA

Default: FORMATTED_VALUE

batch_update_values^5cr4 params(2 required)

Write values to multiple ranges at once.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

datarequiredarray

Array of range/values pairs

Array of: object

value_input_optionstring

How to interpret input values

Values:

USER_ENTEREDRAW

Default: USER_ENTERED

include_values_in_responseboolean

Whether to return updated values

append_values^5cr6 params(3 required)

Append rows after the last row of existing data.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

rangerequiredstring

A1 notation range (data will be appended after the last row in this range)

valuesrequiredarray

2D array of values to append

Array of: array

value_input_optionstring

How to interpret input values

Values:

USER_ENTEREDRAW

Default: USER_ENTERED

major_dimensionstring

Whether to interpret arrays as rows or columns

Values:

ROWSCOLUMNS

Default: ROWS

include_values_in_responseboolean

Whether to return updated values

clear_values^5cr2 params(2 required)

Clear values from a range (preserves formatting).

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

rangerequiredstring

A1 notation range to clear

batch_clear_values^5cr2 params(2 required)

Clear values from multiple ranges at once.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

rangesrequiredarray

Array of A1 notation ranges to clear

Array of: string

format_cells^5cr5 params(3 required)

Apply text and cell formatting to a range.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

rangerequiredstring

A1 notation range (can include sheet name like 'Sheet1!A1:B2')

cell_formatrequiredobject

Cell formatting options. Color fields require RGB dicts with 0-1 float values.

Properties:

bold(boolean)- Bold text

italic(boolean)- Italic text

strikethrough(boolean)- Strikethrough text

underline(boolean)- Underline text

font_size(integer)- Font size in points

font_family(string)- Font family name

text_color(object)- Text color (RGB 0-1)

background_color(object)- Background color (RGB 0-1)

horizontal_alignment(string)- Horizontal alignment

vertical_alignment(string)- Vertical alignment

wrap_strategy(string)- Text wrapping strategy

sheet_namestring

Sheet name (can also be embedded in range)

sheet_idinteger

Numeric sheet ID

set_number_format^5cr5 params(3 required)

Apply number formatting to a range.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

rangerequiredstring

A1 notation range

number_formatrequiredobject

Number format specification

Properties:

format_type(string)- Number format type

pattern(string)- Custom number format pattern (e.g., '$#,##0.00')

sheet_namestring

Sheet name

sheet_idinteger

Numeric sheet ID

merge_cells^5cr5 params(2 required)

Merge cells in a range.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

rangerequiredstring

A1 notation range to merge

sheet_namestring

Sheet name (can also be embedded in range)

sheet_idinteger

Numeric sheet ID

merge_typestring

How to merge cells

Values:

MERGE_ALLMERGE_ROWSMERGE_COLUMNS

Default: MERGE_ALL

unmerge_cells^5cr4 params(2 required)

Unmerge previously merged cells.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

rangerequiredstring

A1 notation range to unmerge

sheet_namestring

Sheet name (can also be embedded in range)

sheet_idinteger

Numeric sheet ID

set_borders^5cr4 params(2 required)

Set borders on cells in a range.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

rangerequiredstring

A1 notation range

sheet_namestring

Sheet name

sheet_idinteger

Numeric sheet ID

insert_rows^5cr6 params(2 required)

Insert rows at a specified position.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

start_indexrequiredinteger

0-based row index where insertion starts

Range: 0 - ...

sheet_namestring

Sheet name

sheet_idinteger

Numeric sheet ID

num_rowsinteger

Number of rows to insert (default 1)

Range: 1 - ...

inherit_from_beforeboolean

Whether new rows should inherit formatting from the row before

insert_columns^5cr6 params(2 required)

Insert columns at a specified position.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

start_indexrequiredinteger

0-based column index where insertion starts

Range: 0 - ...

sheet_namestring

Sheet name

sheet_idinteger

Numeric sheet ID

num_columnsinteger

Number of columns to insert (default 1)

Range: 1 - ...

inherit_from_beforeboolean

Whether new columns should inherit formatting from the column before

delete_rows^5cr5 params(3 required)

Delete rows by index range.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

start_indexrequiredinteger

0-based starting row index

Range: 0 - ...

end_indexrequiredinteger

0-based ending row index (exclusive)

Range: 0 - ...

sheet_namestring

Sheet name

sheet_idinteger

Numeric sheet ID

delete_columns^5cr5 params(3 required)

Delete columns by index range.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

start_indexrequiredinteger

0-based starting column index

Range: 0 - ...

end_indexrequiredinteger

0-based ending column index (exclusive)

Range: 0 - ...

sheet_namestring

Sheet name

sheet_idinteger

Numeric sheet ID

resize_dimensions^5cr7 params(5 required)

Set row height or column width in pixels.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

dimensionrequiredstring

Dimension to resize

Values:

ROWSCOLUMNS

start_indexrequiredinteger

0-based starting index

Range: 0 - ...

end_indexrequiredinteger

0-based ending index (exclusive)

Range: 0 - ...

pixel_sizerequiredinteger

Height (for rows) or width (for columns) in pixels

Range: 1 - ...

sheet_namestring

Sheet name

sheet_idinteger

Numeric sheet ID

auto_resize_dimensions^5cr6 params(4 required)

Auto-fit row height or column width to content.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

dimensionrequiredstring

Dimension to auto-resize

Values:

ROWSCOLUMNS

start_indexrequiredinteger

0-based starting index

Range: 0 - ...

end_indexrequiredinteger

0-based ending index (exclusive)

Range: 0 - ...

sheet_namestring

Sheet name

sheet_idinteger

Numeric sheet ID

sort_range^5cr5 params(3 required)

Sort data in a range by one or more columns.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

rangerequiredstring

A1 notation range to sort

sort_specsrequiredarray

Sorting specifications

Array of: object

sheet_namestring

Sheet name (can also be embedded in range)

sheet_idinteger

Numeric sheet ID

find_replace^5cr9 params(3 required)

Find and replace text across the spreadsheet or a specific sheet.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

findrequiredstring

Text to search for

replacementrequiredstring

Text to replace with

sheet_namestring

Sheet name (limit to one sheet)

sheet_idinteger

Numeric sheet ID (limit to one sheet)

match_caseboolean

Whether search is case-sensitive

match_entire_cellboolean

Whether to match entire cell contents only

search_by_regexboolean

Whether to use regex for search

include_formulasboolean

Whether to search in formulas

copy_paste^5cr4 params(2 required)

Copy and paste a range to another location.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

rangerequiredstring

Source A1 notation range

sheet_namestring

Sheet name

sheet_idinteger

Numeric sheet ID

cut_paste^5cr4 params(2 required)

Cut and paste a range to another location.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

rangerequiredstring

Source A1 notation range

sheet_namestring

Sheet name

sheet_idinteger

Numeric sheet ID

set_basic_filter^5cr5 params(2 required)

Apply a basic filter to a data range.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

rangerequiredstring

A1 notation range for the filter

sheet_namestring

Sheet name (can also be embedded in range)

sheet_idinteger

Numeric sheet ID

filter_criteriaobject

Filter criteria specification

clear_filter^5cr3 params(1 required)

Remove the basic filter from a sheet.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

sheet_namestring

Sheet name

sheet_idinteger

Numeric sheet ID

protect_range^5cr6 params(2 required)

Protect a range from editing.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

rangerequiredstring

A1 notation range to protect

sheet_namestring

Sheet name

sheet_idinteger

Numeric sheet ID

descriptionstring

Description for the protected range

warning_onlyboolean

Whether protection should be warning-only (users can still edit)

unprotect_range^5cr4 params(2 required)

Remove protection from a range.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

rangerequiredstring

A1 notation range to unprotect

sheet_namestring

Sheet name

sheet_idinteger

Numeric sheet ID

add_named_range^5cr5 params(3 required)

Create a named range in the spreadsheet.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

namerequiredstring

Name for the named range

rangerequiredstring

A1 notation range

sheet_namestring

Sheet name

sheet_idinteger

Numeric sheet ID

delete_named_range^5cr2 params(2 required)

Delete a named range.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

named_range_idrequiredstring

ID of the named range to delete

set_data_validation^5cr5 params(3 required)

Set data validation rules on a range.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

rangerequiredstring

A1 notation range

validation_rulerequiredobject

Data validation rule specification

sheet_namestring

Sheet name

sheet_idinteger

Numeric sheet ID

add_conditional_formatting^5cr5 params(3 required)

Add conditional formatting rules to a range.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

rangerequiredstring

A1 notation range

rulerequiredobject

Conditional formatting rule specification

sheet_namestring

Sheet name

sheet_idinteger

Numeric sheet ID

batch_update^5cr2 params(2 required)

Execute multiple raw Google Sheets API requests in a single call for advanced operations.

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

requestsrequiredarray

Array of raw Sheets API batch update request objects

Array of: object

share_spreadsheet^5cr4 params(3 required)

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

spreadsheet_idrequiredstring

Google Sheets ID or full spreadsheet URL

emailrequiredstring

Email address for sharing

Format: email

rolerequiredstring

Sharing role

Values:

ownerorganizerfileOrganizerwritercommenterreader

sharing_typestring

Sharing type

Values:

usergroupdomainanyone

Default: user

Connect Your Agent In 5 Min

Use hosted MCP first, or install the local STDIO fallback when your client requires a command

Hosted Streamable HTTPS

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

Endpoint: https://api.agentpmt.com/mcp
Authorization: Bearer <AGENTPMT_BEARER_TOKEN>

Full connection guide

Local STDIO Fallback

Use the local router for Claude Code, Codex, Cursor, Zed, and other clients that require a command-based MCP server. The router forwards requests to the hosted endpoint and does not execute tools locally.

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

curl -X POST "https://api.agentpmt.com/products/purchase" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer ********" \
  -d '{
    "product_id": "696302894cf4309309cac7b2",
    "parameters": {
      "action": "create_spreadsheet",
      "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_spreadsheet",
        "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_spreadsheet",
    "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_spreadsheet",
    "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.

Usage Instructions

Usage guidance provided directly by the developer for this product.

Google Sheets

Comprehensive spreadsheet operations: create, read, write, format, and manage Google Sheets.

Spreadsheet Identification

All actions (except create_spreadsheet and search_spreadsheets) require a spreadsheet. Provide either:

spreadsheet_id - The spreadsheet ID (e.g., 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms)
spreadsheet_url - Full URL (e.g., https://docs.google.com/spreadsheets/d/1BxiMVs0XRA.../edit)

Range Notation

Ranges use A1 notation: A1:C10, Sheet1!A1:C10, A:C (entire columns), 1:5 (entire rows).

Value Format

Values are 2D arrays: outer array = rows, inner arrays = columns.

[["Name", "Age"], ["Alice", 30], ["Bob", 25]]

Actions

Spreadsheet Management

create_spreadsheet

Create a new spreadsheet.

Required: title
Optional: initial_data (object with sheet_name and values 2D array)

{"action": "create_spreadsheet", "title": "Q1 Budget"}

{"action": "create_spreadsheet", "title": "Team Roster", "initial_data": {"sheet_name": "Players", "values": [["Name", "Position"], ["Alice", "Forward"]]}}

get_spreadsheet

Get spreadsheet metadata (title, sheets, locale, timezone).

Required: spreadsheet_id

{"action": "get_spreadsheet", "spreadsheet_id": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"}

update_spreadsheet_properties

Update spreadsheet-level properties such as the title.

Required: spreadsheet_id
Optional: title

{"action": "update_spreadsheet_properties", "spreadsheet_id": "SPREADSHEET_ID", "title": "Renamed Budget"}

search_spreadsheets

Search for spreadsheets by name. Returns results sorted by most recently modified.

Optional: query (name contains match; omit to list recent spreadsheets), max_results (1-100, default 20)

{"action": "search_spreadsheets", "query": "budget", "max_results": 5}

share_spreadsheet

Share a spreadsheet with a user.

Required: spreadsheet_id, email, role
Optional: type (default: user; options: user, group, domain, anyone)

Role options: owner, organizer, fileOrganizer, writer, commenter, reader

{"action": "share_spreadsheet", "spreadsheet_id": "SPREADSHEET_ID", "email": "bob@example.com", "role": "writer"}

Sheet (Tab) Operations

list_sheets

List all sheets/tabs in a spreadsheet.

Required: spreadsheet_id

{"action": "list_sheets", "spreadsheet_id": "SPREADSHEET_ID"}

add_sheet

Add a new sheet/tab.

Required: spreadsheet_id, new_sheet_name
Optional: tab_color (RGB object with 0-1 floats), hidden, num_rows, num_columns

{"action": "add_sheet", "spreadsheet_id": "SPREADSHEET_ID", "new_sheet_name": "Q2 Data", "tab_color": {"red": 0.2, "green": 0.6, "blue": 1.0}}

delete_sheet

Delete a sheet/tab.

Required: spreadsheet_id, and one of: sheet_name, sheet_id, or sheet_index

{"action": "delete_sheet", "spreadsheet_id": "SPREADSHEET_ID", "sheet_name": "Old Data"}

duplicate_sheet

Duplicate an existing sheet within the same spreadsheet.

Required: spreadsheet_id, and one of: sheet_name, sheet_id, or sheet_index
Optional: new_sheet_name

{"action": "duplicate_sheet", "spreadsheet_id": "SPREADSHEET_ID", "sheet_name": "Template", "new_sheet_name": "March Copy"}

rename_sheet

Rename a sheet/tab.

Required: spreadsheet_id, new_sheet_name, and one of: sheet_name, sheet_id, or sheet_index

{"action": "rename_sheet", "spreadsheet_id": "SPREADSHEET_ID", "sheet_name": "Sheet1", "new_sheet_name": "Revenue"}

update_sheet_properties

Update sheet-level properties (title, tab color, visibility).

Required: spreadsheet_id, and one of: sheet_name or sheet_id
Optional: new_sheet_name, tab_color, hidden

{"action": "update_sheet_properties", "spreadsheet_id": "SPREADSHEET_ID", "sheet_name": "Data", "tab_color": {"red": 1.0, "green": 0, "blue": 0}, "hidden": false}

Reading Data

get_values

Read values from a single range.

Required: spreadsheet_id, range
Optional: value_render_option (FORMATTED_VALUE default, UNFORMATTED_VALUE, FORMULA), major_dimension (ROWS default, COLUMNS)

{"action": "get_values", "spreadsheet_id": "SPREADSHEET_ID", "range": "Sheet1!A1:D10"}

batch_get_values

Read values from multiple ranges at once.

Required: spreadsheet_id, ranges (array of A1 ranges)
Optional: value_render_option, major_dimension

{"action": "batch_get_values", "spreadsheet_id": "SPREADSHEET_ID", "ranges": ["Sheet1!A1:B5", "Sheet2!A1:C3"]}

get_sheet_data

Get all data from a specific sheet.

Required: spreadsheet_id
Optional: sheet_name (defaults to Sheet1)

{"action": "get_sheet_data", "spreadsheet_id": "SPREADSHEET_ID", "sheet_name": "Inventory"}

search_values

Search for text within a spreadsheet.

Required: spreadsheet_id, find (or search_query)
Optional: range (limit search to range), match_case, match_entire_cell

{"action": "search_values", "spreadsheet_id": "SPREADSHEET_ID", "find": "overdue", "range": "Sheet1!A1:Z100"}

Writing Data

update_values

Write values to a single range (overwrites existing data).

Required: spreadsheet_id, range, values
Optional: value_input_option (USER_ENTERED default, RAW), major_dimension, include_values_in_response

{"action": "update_values", "spreadsheet_id": "SPREADSHEET_ID", "range": "Sheet1!A1:C2", "values": [["Name", "Score", "Grade"], ["Alice", 95, "A"]]}

append_values

Append rows after the last row of existing data.

Required: spreadsheet_id, range, values
Optional: value_input_option, major_dimension, include_values_in_response

{"action": "append_values", "spreadsheet_id": "SPREADSHEET_ID", "range": "Sheet1!A:C", "values": [["Bob", 88, "B+"], ["Carol", 92, "A-"]]}

batch_update_values

Write values to multiple ranges at once.

Required: spreadsheet_id, data (array of objects with range and values)
Optional: value_input_option, include_values_in_response

{"action": "batch_update_values", "spreadsheet_id": "SPREADSHEET_ID", "data": [{"range": "Sheet1!A1:B2", "values": [["X", "Y"], [1, 2]]}, {"range": "Sheet2!A1", "values": [["Done"]]}]}

clear_values

Clear values from a range (preserves formatting).

Required: spreadsheet_id, range

{"action": "clear_values", "spreadsheet_id": "SPREADSHEET_ID", "range": "Sheet1!A1:C10"}

batch_clear_values

Clear multiple ranges at once.

Required: spreadsheet_id, ranges

{"action": "batch_clear_values", "spreadsheet_id": "SPREADSHEET_ID", "ranges": ["Sheet1!A1:B5", "Sheet1!D1:D5"]}

Formatting

format_cells

Apply text and cell formatting.

Required: spreadsheet_id, range, cell_format, and one of: sheet_name, sheet_id, or sheet name embedded in range (e.g., Sheet1!A1:B2)
cell_format options: bold, italic, underline, strikethrough, font_size, font_family, text_color (RGB 0-1), background_color (RGB 0-1), horizontal_alignment (LEFT/CENTER/RIGHT), vertical_alignment (TOP/MIDDLE/BOTTOM), wrap_strategy (OVERFLOW_CELL/CLIP/WRAP)

{"action": "format_cells", "spreadsheet_id": "SPREADSHEET_ID", "range": "Sheet1!A1:D1", "cell_format": {"bold": true, "background_color": {"red": 0.9, "green": 0.9, "blue": 0.9}, "horizontal_alignment": "CENTER"}}

set_number_format

Apply number formatting to a range.

Required: spreadsheet_id, range, number_format, and one of: sheet_name, sheet_id, or sheet name in range
number_format: object with type (TEXT, NUMBER, PERCENT, CURRENCY, DATE, TIME, DATE_TIME, SCIENTIFIC) and optional pattern

{"action": "set_number_format", "spreadsheet_id": "SPREADSHEET_ID", "range": "Sheet1!B2:B100", "sheet_name": "Sheet1", "number_format": {"type": "CURRENCY", "pattern": "$#,##0.00"}}

merge_cells

Merge cells in a range.

Required: spreadsheet_id, range, and one of: sheet_name, sheet_id, or sheet name in range
Optional: merge_type (MERGE_ALL default, MERGE_ROWS, MERGE_COLUMNS)

{"action": "merge_cells", "spreadsheet_id": "SPREADSHEET_ID", "range": "Sheet1!A1:D1", "merge_type": "MERGE_ALL"}

unmerge_cells

Unmerge previously merged cells.

Required: spreadsheet_id, range, and one of: sheet_name, sheet_id, or sheet name in range

{"action": "unmerge_cells", "spreadsheet_id": "SPREADSHEET_ID", "range": "Sheet1!A1:D1"}

Row and Column Operations

All row/column operations use 0-based indexing.

insert_rows

Insert rows at a position.

Required: spreadsheet_id, start_index (0-based), and one of: sheet_name or sheet_id
Optional: num_rows (default 1), inherit_from_before

{"action": "insert_rows", "spreadsheet_id": "SPREADSHEET_ID", "sheet_name": "Sheet1", "start_index": 2, "num_rows": 3}

insert_columns

Insert columns at a position.

Required: spreadsheet_id, start_index (0-based), and one of: sheet_name or sheet_id
Optional: num_columns (default 1), inherit_from_before

{"action": "insert_columns", "spreadsheet_id": "SPREADSHEET_ID", "sheet_name": "Sheet1", "start_index": 1, "num_columns": 2}

delete_rows

Delete rows by index range.

Required: spreadsheet_id, start_index, end_index (exclusive, 0-based), and one of: sheet_name or sheet_id

{"action": "delete_rows", "spreadsheet_id": "SPREADSHEET_ID", "sheet_name": "Sheet1", "start_index": 5, "end_index": 8}

delete_columns

Delete columns by index range.

Required: spreadsheet_id, start_index, end_index (exclusive, 0-based), and one of: sheet_name or sheet_id

{"action": "delete_columns", "spreadsheet_id": "SPREADSHEET_ID", "sheet_name": "Sheet1", "start_index": 2, "end_index": 4}

resize_dimensions

Set row height or column width in pixels.

Required: spreadsheet_id, dimension (ROWS or COLUMNS), start_index, end_index, pixel_size, and one of: sheet_name or sheet_id

{"action": "resize_dimensions", "spreadsheet_id": "SPREADSHEET_ID", "sheet_name": "Sheet1", "dimension": "COLUMNS", "start_index": 0, "end_index": 3, "pixel_size": 200}

auto_resize_dimensions

Auto-fit row height or column width to content.

Required: spreadsheet_id, dimension (ROWS or COLUMNS), start_index, end_index, and one of: sheet_name or sheet_id

{"action": "auto_resize_dimensions", "spreadsheet_id": "SPREADSHEET_ID", "sheet_name": "Sheet1", "dimension": "COLUMNS", "start_index": 0, "end_index": 5}

Data Manipulation

sort_range

Sort data in a range by one or more columns.

Required: spreadsheet_id, range, sort_specs, and one of: sheet_name, sheet_id, or sheet name in range
sort_specs: array of objects with dimensionIndex (0-based column) and sortOrder (ASCENDING or DESCENDING)

{"action": "sort_range", "spreadsheet_id": "SPREADSHEET_ID", "range": "Sheet1!A2:D100", "sort_specs": [{"dimensionIndex": 1, "sortOrder": "DESCENDING"}]}

find_replace

Find and replace text across the spreadsheet or a specific sheet.

Required: spreadsheet_id, find, replacement
Optional: sheet_name or sheet_id (limit to one sheet), match_case, match_entire_cell, search_by_regex, include_formulas

{"action": "find_replace", "spreadsheet_id": "SPREADSHEET_ID", "find": "TBD", "replacement": "Confirmed", "sheet_name": "Sheet1"}

Filtering

set_basic_filter

Apply a basic filter to a data range.

Required: spreadsheet_id, range, and one of: sheet_name, sheet_id, or sheet name in range
Optional: filter_criteria

{"action": "set_basic_filter", "spreadsheet_id": "SPREADSHEET_ID", "range": "Sheet1!A1:D100"}

clear_filter

Remove the basic filter from a sheet.

Required: spreadsheet_id, and one of: sheet_name or sheet_id

{"action": "clear_filter", "spreadsheet_id": "SPREADSHEET_ID", "sheet_name": "Sheet1"}

Advanced

batch_update

Execute multiple raw Google Sheets API requests in a single call. Use this for operations not covered by other actions.

Required: spreadsheet_id, requests (array of Sheets API batch update request objects)

{"action": "batch_update", "spreadsheet_id": "SPREADSHEET_ID", "requests": [{"updateSheetProperties": {"properties": {"sheetId": 0, "title": "New Name"}, "fields": "title"}}]}

Common Workflows

Build a report from scratch

create_spreadsheet with title and initial headers
append_values to add data rows
format_cells to style the header row (bold, background color)
set_number_format for currency/percentage columns
auto_resize_dimensions to fit column widths
share_spreadsheet with stakeholders

Update existing data

search_spreadsheets to find the spreadsheet by name
get_values to read current data
update_values or append_values to write changes
sort_range to re-sort if needed

Manage multiple sheets

list_sheets to see all tabs
add_sheet or duplicate_sheet to create new tabs
rename_sheet or update_sheet_properties to organize
delete_sheet to remove unused tabs

Important Notes

Value input: USER_ENTERED (default) parses values as if typed by a user (formulas, dates, numbers are interpreted). RAW stores values exactly as provided.
Colors: All color fields (text_color, background_color, tab_color) require RGB objects with float values from 0 to 1. Hex strings are not supported. Example: {"red": 0.2, "green": 0.6, "blue": 1.0}
Indexing: Row/column operations (insert, delete, resize) use 0-based indexing. end_index is exclusive.
Sheet identification: Most sheet operations accept sheet_name, sheet_id, or sheet_index. You can also embed the sheet name in the range (e.g., Sheet1!A1:C10).
Formulas: Write formulas by including them in values with a leading = and using USER_ENTERED input option. Example: [["=SUM(B2:B10)"]]

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

Call the AgentPMT-Tool-Search-and-Execution tool with action 'get_schema' and tool_id 696302894cf4309309cac7b2 ("Google Sheets"). Then call the same tool with action 'call_tool', tool_id 696302894cf4309309cac7b2, and the parameters needed for my request.

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