delete_table_records_tool
Remove specific rows (records) from a table in Google Sheets while maintaining table structure. Deletes rows in descending order to prevent index shifting issues. Requires spreadsheet, sheet, table names, and record numbers to delete.
Instructions
Delete specific records (rows) from a table.
This tool removes specific records from a table while preserving the table structure.
Record numbers are 1-based and exclude the header row. Records are deleted in descending order
(bigger numbers first) to avoid index shifting issues.
Args:
spreadsheet_name: Name of the spreadsheet
sheet_name: Name of the sheet containing the table
table_name: Name of the table to delete records from
record_numbers: List of record numbers to delete (1-based, excluding header)
Returns:
JSON string with success status and deletion details
Input Schema
Name | Required | Description | Default |
---|---|---|---|
record_numbers | Yes | List of record numbers to delete (1-based, excluding header) | |
sheet_name | Yes | The name of the sheet containing the table | |
spreadsheet_name | Yes | The name of the Google Spreadsheet | |
table_name | Yes | Name of the table to delete records from |
Input Schema (JSON Schema)
{
"properties": {
"record_numbers": {
"description": "List of record numbers to delete (1-based, excluding header)",
"items": {
"type": "integer"
},
"title": "Record Numbers",
"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 delete records from",
"title": "Table Name",
"type": "string"
}
},
"required": [
"spreadsheet_name",
"sheet_name",
"table_name",
"record_numbers"
],
"title": "delete_table_records_toolArguments",
"type": "object"
}