Google Sheets MCP connector

Google Sheets is Google's collaborative online spreadsheet editor for creating and managing data in tabular format. The Google Sheets MCP connector allows AI agents to create and modify spreadsheets, read and write cell values across single or multiple ranges, and retrieve spreadsheet metadata. It also supports appending data to sheets, clearing specific ranges, and managing the structure of spreadsheet workbooks.

Authentication type

• OAuth 2.0 Authorization Code - Requires a one-time user login to authorize the agent to access the service on their behalf.

Uses

Use the Google Sheets MCP connector to perform the following actions:

• Capture customer feedback and survey responses directly into Google Sheets
• Sync sales pipeline data from multiple sources into a single spreadsheet
• Automate monthly financial reconciliation by updating budget tracking sheets
• Consolidate employee timesheet submissions into one central Google Sheets workbook
• Publish real-time inventory levels to Google Sheets for warehouse visibility
• Build dynamic reporting dashboards by appending new metrics to tracking sheets
• Archive completed project data while maintaining historical records in spreadsheets

Example prompts

Use the following example prompts to invoke Google Sheets MCP connector tools from your AI assistant or Boomi Connect workflow:

• Add all new customer signups from this week to our Google Sheets tracker.
• Show me the total sales by region in Google Sheets for the current quarter.
• Update our Google Sheets budget with the latest expense reports.
• Pull yesterday's support ticket data into a new Google Sheets report.
• Create a Google Sheets template for our marketing campaign performance.
• Append this month's payroll records to our employee database in Google Sheets.
• Clear out the old test data from our Google Sheets inventory list.
• Give me a summary of all open action items from our Google Sheets project tracker.
• Sync our product pricing from the system into Google Sheets.
• Create a new Google Sheets file with this quarter's financial summary.

Google Sheets MCP connector tools

The Google Sheets MCP connector provides the following tools. Each tool maps to a specific action you can invoke from your AI agent or automation.

Tool	Description
googlesheets_googlesheetscreaterow_invoke	Adds a new row with data to an existing spreadsheet.
googlesheets_googlesheetscreatespreadsheet_invoke	Creates a new spreadsheet with a specified title.
createSpreadsheet	Creates a new spreadsheet with the provided name and configuration.
getSpreadsheet	Retrieves metadata and structural information about a spreadsheet.
getSheetValues	Retrieves data from a specified range within a sheet.
updateSheetValues	Modifies existing data in a specified range within a sheet.
appendSheetValues	Adds new rows of data to the end of a sheet.
clearSheetValues	Removes all data from a specified range within a sheet.
batchGetSheetValues	Retrieves data from multiple ranges across one or more sheets.
batchUpdateSheetValues	Modifies data in multiple ranges across one or more sheets.
batchUpdateSpreadsheet	Applies multiple structural changes to a spreadsheet in one operation.