Search query to filter spreadsheets. Behavior depends on the 'search_type' parameter. For advanced searches, use Google Drive query syntax with fields like 'name contains', 'fullText contains', or boolean filters like 'sharedWithMe = true'. DO NOT use spreadsheet IDs as search t…
order_bystring
Sort order (comma-separated list for multi-field sorting). Valid fields: createdTime, folder, modifiedByMeTime, modifiedTime, name, name_natural, quotaBytesUsed, recency, sharedWithMeTime, starred, viewedByMeTime. Append ' desc' for descending order (default is ascending). Examp…
page_tokenstring
Token for retrieving the next page of results. Use the 'next_page_token' value from a previous response to get subsequent pages. Leave empty to get the first page.
max_resultsinteger
Maximum number of spreadsheets to return (1-1000). Defaults to 10.
search_typestring
How to search: 'name' searches filenames only (prefix matching from the START of filenames), 'content' uses fullText search which searches file content, name, description, and metadata (Google Drive API limitation: cannot search content exclusively without also matching filename…
starred_onlyboolean
Whether to return only starred spreadsheets. Defaults to False.
created_afterstring
Return spreadsheets created after this date. Use RFC 3339 format like '2024-01-01T00:00:00Z'.
modified_afterstring
Return spreadsheets modified after this date. Use RFC 3339 format like '2024-01-01T00:00:00Z'.
shared_with_meboolean
Whether to return only spreadsheets shared with the current user. Defaults to False.
include_trashedboolean
Whether to include spreadsheets in trash. Defaults to False.
include_shared_drivesboolean
Whether to include spreadsheets from shared drives you have access to. Defaults to True.
Observable output
data
Required
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulboolean
Required
Whether or not the action execution was successful or not