Google Sheets MCP connector
Updated
Google Sheets is Google's collaborative online spreadsheet editor for organizing and analyzing data in real time. The Google Sheets MCP connector allows AI agents to create spreadsheets and rows, and read or update values within specific sheet ranges. It also supports appending and clearing data, retrieving spreadsheet metadata, and working across multiple ranges at once.
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:
- Track project tasks and deadlines across shared team spreadsheets
- Log customer orders automatically into a running spreadsheet ledger
- Consolidate sales figures from multiple sources into one spreadsheet
- Generate expense reports by pulling data from linked spreadsheets
- Build inventory trackers that update in real time for teams
- Automate weekly status reports without manual copy-pasting
- Sync form submissions directly into structured spreadsheet rows
- Create budget templates instantly for new projects or departments
Example prompts
Use the following example prompts to invoke Google Sheets MCP connector tools from your AI assistant or Boomi Connect workflow:
Add a new row to my Google Sheets budget tracker for this month's expenses.Create a new Google Sheets spreadsheet for tracking Q3 marketing campaigns.Show me the values in the sales tab of my Google Sheets spreadsheet.Update the inventory numbers in my Google Sheets warehouse spreadsheet.Append today's sales totals to my Google Sheets revenue tracker.Clear out last month's data from my Google Sheets expense report.Pull data from both the sales and expenses tabs in Google Sheets.Update multiple sections of my project plan in Google Sheets at once.What's the current metadata for my Google Sheets team roster spreadsheet?Make several formatting changes to my Google Sheets budget spreadsheet in one go.
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 | Add a new row to an existing Google Spreadsheet |
| googlesheets_googlesheetscreatespreadsheet_invoke | Create a new Google Spreadsheet with specified title and content |
| createSpreadsheet | Create a new spreadsheet |
| getSpreadsheet | Get spreadsheet metadata |
| getSheetValues | Get values from a sheet range |
| updateSheetValues | Update values in a sheet range |
| appendSheetValues | Append values to a sheet |
| clearSheetValues | Clear values from a sheet range |
| batchGetSheetValues | Get multiple ranges of values |
| batchUpdateSheetValues | Update multiple ranges of values |
| batchUpdateSpreadsheet | Apply batch updates to a spreadsheet |
