Google Super
GOOGLESUPER_QUERY_TABLE
This action is used to query a table in a Google Spreadsheet, call this action to query a table in a spreadsheet. Execute SQL-like SELECT queries against spreadsheet tables. Supports WHERE conditions, ORDER BY, LIMIT clauses. Call this action after calling the GET_TABLE_SCHEMA action to query a table in a spreadsheet.
Remote googlesuper
Other tools also called GOOGLESUPER_QUERY_TABLE?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"sql": {
"type": "string",
"title": "Sql",
"examples": [
"SELECT * FROM \"Sales_Data\" LIMIT 10",
"SELECT project, totals FROM \"Sales_Data\" WHERE totals > 10.0 ORDER BY totals DESC",
"SELECT name, email FROM \"Customers\" WHERE status = 'ACTIVE'"
],
"description": "SQL SELECT query. Supported: SELECT cols FROM table WHERE conditions ORDER BY col LIMIT n. Table names must be quoted if they contain spaces."
},
"spreadsheet_id": {
"type": "string",
"title": "Spreadsheet Id",
"examples": [
"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
],
"description": "Google Sheets ID"
},
"include_formulas": {
"type": "boolean",
"title": "Include Formulas",
"default": false,
"description": "Whether to return formula text instead of calculated values for formula columns"
}
}
}