# 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    |