Google Sheets MCP Server - Barndoor Documentation
Google Sheets
SecureBarndoor ManagedGoogle Workspace
Summary: Custom built connector to read, write, and analyze spreadsheet data via AI tools.
How Teams Use It: The Barndoor-managed Google Sheets MCP server enables agents to read and write spreadsheet data, append rows, and execute batch updates — making it efficient for automating data entry, reporting, and spreadsheet-driven workflows.
Tools
| Tool Name | Tool Description | Tool Type |
|---|---|---|
| Append_Cell_Values | Appends new rows of data to the end of a sheet range. | Create |
| Batch_Clear_Cell_Values | Clears cell values from multiple ranges in a single request. | Delete |
| Batch_Clear_Cell_Values_by_Filter | Clears cell values from ranges specified by data filters. | Delete |
| Batch_Get_Cell_Values | Retrieves cell values from multiple ranges in a single request. | Read |
| Batch_Get_Cell_Values_by_Filter | Retrieves cell values from multiple ranges using data filters. | Read |
| Batch_Update_Cell_Values | Updates cell values in multiple ranges in a single request. | Update |
| Batch_Update_Cell_Values_by_Filter | Updates cell values in ranges specified by data filters. | Update |
| Batch_Update_Spreadsheet | Executes multiple updates to a spreadsheet (modify cells, sheets, formatting, or structure). | Update |
| Clear_Cell_Values | Clears cell values from a specified range without removing formatting. | Delete |
| Copy_Sheet_to_Spreadsheet | Copies a sheet to another spreadsheet. Returns the copied sheet ID. | Create |
| Create_Spreadsheet | Creates a new Google Sheets spreadsheet. Returns the spreadsheet ID. | Create |
| Get_Cell_Values | Retrieves cell values from a specified range in a sheet. | Read |
| Get_Developer_Metadata | Retrieves developer metadata entries associated with a spreadsheet. | Read |
| Get_Spreadsheet_by_Data_Filter | Retrieves spreadsheet data matching specified filters (ranges, developer metadata, etc.). | Read |
| Get_Spreadsheet_Metadata | Retrieves spreadsheet metadata including sheets, properties, and named ranges. | Read |
| Search_Developer_Metadata | Searches for developer metadata entries matching specified criteria. | Read |
| Update_Cell_Values | Updates cell values in a specified range. Overwrites existing data. | Update |