Paperclip’s Google Sheets MCP connector gives your AI agents tools to read spreadsheets and update values and formulas. Each tool can be Allowed, Ask first or Off.
Google sign-in reaches spreadsheets the authorizing account can open. The robot method enforces the list of spreadsheet links configured on the connection.
What agents can do with Google Sheets
- Read spreadsheet structure and values
get_spreadsheet·get_values - Review values before updating them
get_values·update_values - Find an allowlisted spreadsheet and read cells
list_spreadsheets·read_values
How to connect Google Sheets
- In Paperclip, open Connectors and select Google Sheets.
- On the Access step, choose the identity and which agents may use the connection.
- For Google sign-in, choose the capability group and sign in using Connect with Paperclip or your own OAuth app. For Use the Paperclip robot account, share spreadsheets with its email and paste their links.
Google Sheets tools for agents14
Read 6
get_spreadsheetReturns the spreadsheet content for the given spreadsheet.
Full description
Returns the spreadsheet content for the given spreadsheet. Returns titles, sheet names, grid properties, and other metadata for the given spreadsheet ID. Also returns full grid data if requested. Corresponds to spreadsheets.get in the REST API: https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/get
get_spreadsheet_infoGet spreadsheet metadata and sheet tab information for an allowlisted spreadsheet.
get_valuesReturns a range of values from a spreadsheet.
Full description
Returns a range of values from a spreadsheet. Corresponds to spreadsheets.values.get in the REST API: https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/get
list_spreadsheetsList the Google Sheets spreadsheets configured in this connection allowlist.
read_valuesRead cell values from an allowlisted spreadsheet range.
search_rowsSearch rows in an allowlisted spreadsheet range.
Write 8
add_sheet_tabAdd a sheet tab to an allowlisted spreadsheet.
append_rowsAppend rows to an allowlisted spreadsheet range.
clear_valuesClear values in an allowlisted spreadsheet range.
delete_rowsDelete rows from an allowlisted spreadsheet tab.
insert_dimensionInserts rows or columns in a sheet at a particular index.
Full description
Inserts rows or columns in a sheet at a particular index. Corresponds to an InsertDimensionRequest in the spreadsheets.batchUpdate REST API: https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/request
update_formulasSets formulas in a range of a spreadsheet.
Full description
Sets formulas in a range of a spreadsheet. Corresponds to spreadsheets.values.update in the REST API: https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/update
Show all 8 Write tools
Write tools 7–8
update_spreadsheetApplies one or more updates to the spreadsheet.Corresponds to spreadsheets.batchUpdate in the REST API: https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/batchUpdateThe
Full description
Applies one or more updates to the spreadsheet.Corresponds to spreadsheets.batchUpdate in the REST API: https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/batchUpdateThe list of possible updates is: updateSpreadsheetProperties: Updates the spreadsheet's properties. updateSheetProperties: Updates a sheet's properties. updateDimensionProperties: Updates dimensions' properties. updateNamedRange: Updates a named range. repeatCell: Repeats a single cell across a range. addNamedRange: Adds a named range. deleteNamedRange: Deletes a named range. addSheet: Adds a sheet. deleteSheet: Deletes a sheet. autoFill: Automatically fills in more data based on existing data. cutPaste: Cuts data from one area and pastes it to another. copyPaste: Copies data from one area and pastes it to another. mergeCells: Merges cells together. unmergeCells: Unmerges merged cells. updateBorders: Updates the borders in a range of cells. updateCells: Updates many cells at once. addFilterView: Adds a filter view. appendCells: Appends cells after the last row with data in a sheet. clearBasicFilter: Clears the basic filter on a sheet. deleteDimension: Deletes rows or columns in a sheet. deleteEmbeddedObject: Deletes an embedded object (e.g, chart, image) in a sheet. deleteFilterView: Deletes a filter view from a sheet. duplicateFilterView: Duplicates a filter view. duplicateSheet: Duplicates a sheet. findReplace: Finds and replaces occurrences of some text with other text. insertDimension: Inserts new rows or columns in a sheet. insertRange: Inserts new cells in a sheet, shifting the existing cells. moveDimension: Moves rows or columns to another location in a sheet. updateEmbeddedObjectPosition: Updates an embedded object's (e.g. chart, image) position. pasteData: Pastes data (HTML or delimited) into a sheet. textToColumns: Converts a column of text into many columns of text. updateFilterView: Updates the properties of a filter view. deleteRange: Deletes a range of cells from a sheet, shifting the remaining cells. appendDimension: Appends dimensions to the end of a sheet. addConditionalFormatRule: Adds a new conditional format rule. updateConditionalFormatRule: Updates an existing conditional format rule. deleteConditionalFormatRule: Deletes an existing conditional format rule. sortRange: Sorts data in a range. setDataValidation: Sets data validation for one or more cells. setBasicFilter: Sets the basic filter on a sheet. addProtectedRange: Adds a protected range. updateProtectedRange: Updates a protected range. deleteProtectedRange: Deletes a protected range. autoResizeDimensions: Automatically resizes one or more dimensions based on the contents of the cells in that dimension. addChart: Adds a chart. updateChartSpec: Updates a chart's specifications. updateBanding: Updates a banded range addBanding: Adds a new banded range deleteBanding: Removes a banded range createDeveloperMetadata: Creates new developer metadata updateDeveloperMetadata: Updates an existing developer metadata entry deleteDeveloperMetadata: Deletes developer metadata randomizeRange: Randomizes the order of the rows in a range. addDimensionGroup: Creates a group over the specified range. deleteDimensionGroup: Deletes a group over the specified range. updateDimensionGroup: Updates the state of the specified group. trimWhitespace: Trims cells of whitespace (such as spaces, tabs, or new lines). deleteDuplicates: Removes rows containing duplicate values in specified columns of a cell range. updateEmbeddedObjectBorder: Updates an embedded object's border. addSlicer: Adds a slicer. updateSlicerSpec: Updates a slicer's specifications. addDataSource: Adds a data source. updateDataSource: Updates a data source. deleteDataSource: Deletes a data source. refreshDataSource: Refreshes one or multiple data sources and associated dbobjects. cancelDataSourceRefresh: Cancels refreshes of one or multiple data sources and associated dbobjects. addTable: Adds a table. updateTable: Updates a table. deleteTable: A request for deleting a table.
update_valuesSets values in a range of a spreadsheet.
Full description
Sets values in a range of a spreadsheet. Corresponds to spreadsheets.values.update in the REST API: https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/update
Tool availability and permissions
This list describes the reviewed tools. Your selected method, provider access and action permissions determine what agents can use.
These lists use a conservative permission policy. Read requires a provider read-only hint or a reviewed Paperclip read rule. Evidence that an action changes data or submits information elsewhere puts it in Write. Write also includes actions we cannot verify as read-only. Read describes the reviewed evidence; it does not guarantee that an action has no side effects. A connected account can group actions differently.
This list comes from published provider information. Authorization, plan, deployment version and account settings can limit the actions available. No connected account was tested. Google sign-in and the local robot account have separate tool lists. Local tools require an explicit spreadsheet allowlist; the local update_values description is shown separately from the remote tool with the same name.
Tools for Connect with Paperclip — Read only / Use your own Google OAuth app — Read only
get_spreadsheet, get_values
Tools for Connect with Paperclip — Read & edit / Use your own Google OAuth app — Read & edit
get_spreadsheet, get_values, insert_dimension, update_formulas, update_spreadsheet, update_values
Local tools for Use the Paperclip robot account — Share selected sheets
add_sheet_tabAdd a sheet tab to an allowlisted spreadsheet.
append_rowsAppend rows to an allowlisted spreadsheet range.
clear_valuesClear values in an allowlisted spreadsheet range.
delete_rowsDelete rows from an allowlisted spreadsheet tab.
get_spreadsheet_infoGet spreadsheet metadata and sheet tab information for an allowlisted spreadsheet.
list_spreadsheetsList the Google Sheets spreadsheets configured in this connection allowlist.
read_valuesRead cell values from an allowlisted spreadsheet range.
search_rowsSearch rows in an allowlisted spreadsheet range.
update_valuesUpdate values in an allowlisted spreadsheet range.
Connection policies
Discovered actions follow the connection’s policies. Review their permissions and set actions to Ask first or Off as needed. Set clear_values and delete_rows to Ask first because their data removal cannot be undone from Paperclip.
Google Sheets connector FAQ
Can I require approval for actions?
Set an action to Ask first to require human approval of each call or Off to prevent calls. Allowed actions run without approval. Read and Write grouping is separate from these settings.
What can agents reach in Google Sheets?
Google sign-in reaches spreadsheets the authorizing account can open. The robot method enforces the list of spreadsheet links configured on the connection.
What do I need before connecting?
Google sign-in requires Developer Preview registration. The robot method requires an instance administrator’s configured service account and spreadsheet sharing; it does not require Developer Preview.
