Google Sheets

Connect Google Sheets to analyze and maintain trackers, logs, and schedules.

What it can do

• Read spreadsheet structure and cell values.
• Write values and formulas.
• Insert rows or columns and change spreadsheet properties.

Setup and security

• You sign in with your own Google account. Assistant can reach only the spreadsheets that account can open, and can edit only those it can edit.
• Tools that change data ask for approval before they run. The Approval column under Supported tools shows each tool's setting.
• Until Google approves Nomic's app, signing in shows a Google MCP access requires whitelisting dialog. Email support@nomic.ai to have your account whitelisted for all Google MCP servers.

To connect, see Add an MCP server.

Example requests

• "Read the submittal tracker and list items that are more than two weeks overdue."
• "Check the door schedule sheet against the door hardware specification in this project."
• "Add a row to the RFI log for the question we just drafted."
• "Add a column that totals each trade's change order amounts."

Supported tools

Tool	Action	Approval
get_spreadsheet	Read spreadsheet metadata, sheets, and structure.	Not required
get_values	Read values from a cell range.	Not required
update_values	Write values to cells.	Required
update_formulas	Write or change formulas.	Required
update_spreadsheet	Change spreadsheet properties or structure.	Required
insert_dimension	Insert rows or columns.	Required