google-sheets-mcp

Add records (rows) into a table in Google Sheets at the end. This tool adds new records into a table at the end using InsertRangeRequest, UpdateCellsRequest, and UpdateTableRequest operations. Each record must match the table's column structure. Records are automatically formatted according to column types. Args: spreadsheet_name: Name of the spreadsheet sheet_name: Name of the sheet containing the table table_name: Name of the table to add records into records: List of records, where each record is a list of values matching table columns Returns: JSON string with success status and operation details

{ "properties": { "records": { "description": "List of records to add into the table.\n \n Each record must be a list of values matching the table's column structure.\n Values can be strings, numbers, booleans, or None.\n \n EXAMPLE: [\n ['John Doe', 30, 'HR', 50000],\n ['Jane Smith', 25, 'Engineering', 60000],\n ['Bob Johnson', 35, 'Marketing', 55000]\n ]\n ", "items": { "items": { "anyOf": [ { "type": "string" }, { "type": "integer" }, { "type": "number" }, { "type": "boolean" }, { "type": "null" } ] }, "type": "array" }, "title": "Records", "type": "array" }, "sheet_name": { "description": "The name of the sheet containing the table", "title": "Sheet Name", "type": "string" }, "spreadsheet_name": { "description": "The name of the Google Spreadsheet", "title": "Spreadsheet Name", "type": "string" }, "table_name": { "description": "Name of the table to add records into", "title": "Table Name", "type": "string" } }, "required": [ "spreadsheet_name", "sheet_name", "table_name", "records" ], "title": "add_table_records_toolArguments", "type": "object" }