Google Sheets
GOOGLESHEETS_EXECUTE_SQL
Execute SQL queries against Google Sheets tables. Supports SELECT, INSERT, UPDATE, and DELETE operations with familiar SQL syntax. Tables are automatically detected and mapped from the spreadsheet structure.
Remote googlesheets
Other tools also called GOOGLESHEETS_EXECUTE_SQL?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"sql": {
"type": "string",
"description": "SQL query to execute. Supports SELECT, INSERT, UPDATE, DELETE operations.\nExamples:\n \"SELECT * FROM \\\"Sales_Data\\\" LIMIT 10\"\n \"INSERT INTO \\\"Customers\\\" (name, email) VALUES ('John Doe', '[email protected]')\"\n \"UPDATE \\\"Inventory\\\" SET quantity = quantity - 10 WHERE sku = 'ABC123'\"\n \"DELETE FROM \\\"Old_Data\\\" WHERE date < '2023-01-01'\""
},
"dry_run": {
"type": "boolean",
"default": false,
"description": "Preview changes without applying them (for write operations)"
},
"delete_method": {
"enum": [
"clear",
"remove_rows"
],
"type": "string",
"default": "clear",
"description": "For DELETE operations: 'clear' preserves row structure, 'remove_rows' shifts data up"
},
"spreadsheet_id": {
"type": "string",
"description": "Google Sheets ID\nExample: \"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms\""
}
}
}