Google Super
GOOGLESUPER_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 googlesuper
Other tools also called GOOGLESUPER_EXECUTE_SQL?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"sql": {
"type": "string",
"title": "Sql",
"examples": [
"SELECT * FROM \"Sales_Data\" LIMIT 10",
"INSERT INTO \"Customers\" (name, email) VALUES ('John Doe', '[email protected]')",
"UPDATE \"Inventory\" SET quantity = quantity - 10 WHERE sku = 'ABC123'",
"DELETE FROM \"Old_Data\" WHERE date < '2023-01-01'"
],
"description": "SQL query to execute. Supports SELECT, INSERT, UPDATE, DELETE operations."
},
"dry_run": {
"type": "boolean",
"title": "Dry Run",
"default": false,
"description": "Preview changes without applying them (for write operations)"
},
"delete_method": {
"enum": [
"clear",
"remove_rows"
],
"type": "string",
"title": "Delete Method",
"default": "clear",
"description": "For DELETE operations: 'clear' preserves row structure, 'remove_rows' shifts data up"
},
"spreadsheet_id": {
"type": "string",
"title": "Spreadsheet Id",
"examples": [
"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
],
"description": "Google Sheets ID"
}
}
}