Search for spreadsheets based on a query.

​
Basic Parameters

ParameterDescription
QueryA query for filtering the file results.

See the Search for files & folders guide for supported syntax.

​
Advanced Parameters

ParameterDescription
Delegated User OverridePerform 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
Workflow LibraryPreview this Workflow on desktop