PlugsightDocs

Google Sheets tools

The Google Sheets tools in the developer API, with every argument: read a spreadsheet's tabs, named ranges and values.

Needs: A Google Sheets connection. 2 tools, all read-only.

Google is still reviewing the permission this connector needs. Until it approves it, Plugsight offers Google Sheets to Plugsight admins only, so for most people it isn't in the Connector catalog yet and these tools don't appear. See Google Sheets.

These tools appear in GET /v1/tools only when the API key's MCP server includes a connection of this kind. Call each one with POST /v1/tools/\<name>, sending its arguments as a JSON object. See Calling tools for the request and response format.

Open a spreadsheet by its link or id. The optional account argument takes a Google Sheets connection id from list_accounts; leave it out when the MCP server has only one.

Tool What it does Kind
sheets_get_info Spreadsheet details Read
sheets_read Read a spreadsheet Read

Every tool here only reads: none of them changes anything in Google Sheets, so none needs confirm.

The example requests fill in only the required arguments, with placeholder values.

sheets_get_info

Spreadsheet details · Read

A Google Sheets spreadsheet's title, tabs (with their size) and named ranges. Call it before sheets_read to pick a tab.

Argument Type Required What it is
spreadsheet string Yes The spreadsheet's link (from the browser's address bar) or its id
account string No Google Sheets connection id from list_accounts (optional when there's only one)

Example request:

curl -X POST https://app.plugsight.app/v1/tools/sheets_get_info \
  -H "Authorization: Bearer $PLUGSIGHT_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"spreadsheet": "…"}'

sheets_read

Read a spreadsheet · Read

Reads values as shown in Google Sheets from a tab or range, e.g. "Sales", "Sales!A1:F200" or a named range. With header true, the first row becomes the column names.

Argument Type Required What it is
spreadsheet string Yes The spreadsheet's link (from the browser's address bar) or its id
range string No Tab name or A1 range, e.g. "Sales" or "Sales!A1:F200". Default: the first tab
header boolean No Treat the first row as column names. Default true.
max_rows integer No Most rows to return. From 1 to 5,000. Default 500.
account string No Google Sheets connection id from list_accounts (optional when there's only one)

Example request:

curl -X POST https://app.plugsight.app/v1/tools/sheets_read \
  -H "Authorization: Bearer $PLUGSIGHT_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"spreadsheet": "…"}'