Google Sheets
GOOGLESHEETS_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 googlesheets
Other tools also called GOOGLESHEETS_QUERY_TABLE?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"sql": {
"type": "string",
"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.\nExamples:\n \"SELECT * FROM \\\"Sales_Data\\\" LIMIT 10\"\n \"SELECT project, totals FROM \\\"Sales_Data\\\" WHERE totals > 10.0 ORDER BY totals DESC\"\n \"SELECT name, email FROM \\\"Customers\\\" WHERE status = 'ACTIVE'\""
},
"spreadsheet_id": {
"type": "string",
"description": "Google Sheets ID\nExample: \"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms\""
},
"include_formulas": {
"type": "boolean",
"default": false,
"description": "Whether to return formula text instead of calculated values for formula columns"
}
}
}