Search Spreadsheets

Search for spreadsheets based on a query.

Basic Parameters

Parameter	Description
Query	A query for filtering the file results.See the Search for files & folders guide for supported syntax.

Advanced Parameters

Parameter	Description
Delegated User Override	Perform the action on behalf of another user, overriding the delegated user defined in the connection.If not specified, the delegated user is the one provided in the connection.Has no effect when using an OAuth connection.NOTE: the connection details are not edited by this input.

Example Output

{
    "kind": "drive#fileList",
    "incompleteSearch": false,
    "files": [
        {
            "kind": "drive#file",
            "mimeType": "application/vnd.google-apps.spreadsheet",
            "id": "231049-fsdf-324-sdfsd-f-234asdasdasd",
            "name": "test1"
        },
        {
            "kind": "drive#file",
            "mimeType": "application/vnd.google-apps.spreadsheet",
            "id": "231049-fsdf-324-sdfsd-f-234",
            "name": "test2"
        }
    ]
}

Workflow Library Example

Search Spreadsheets with Google Sheets and Send Results Via Email

Preview this Workflow on desktop