Read Data - Markifact

Reads data from Google Sheets with support for specific ranges, formatting, and data types


App	Google Sheets
Operation ID	`sheets_read_data`
Type	Action
Connection	`drive` (optional)
Credits per run	1
Agent / MCP tool	Yes

Inputs

Field	Type	Required	Default	Description
`spreadsheet`	string	Yes	-	Google Spreadsheet URL or ID, you must ask the user for it if not provided.
`sheet`	string or SelectItem	Yes	-	The sheet to read data from. You can provide this in several ways: 1. If user provides just a sheet name, fill the object like this {‘label’: ‘Sheet1’, ‘value’: ‘Sheet1’} 2. If user provides only a sheet ID: Format as {‘label’: ‘123456’, ‘value’: ‘123456’} 3. If user provides dynamic values: Use the template syntax (e.g., ‘{{nodeId_data_sheet}}’) 4. If user selects from dropdown: they will ge this format {‘label’: ‘Sheet1’, ‘value’: ‘123456’} If user doesn’t provide sheet information, ask them to specify the sheet name or select from available sheets using the dropdown menu.
`load_all_data`	boolean	No	`True`	Whether to load all data from the sheet, default is True
`selection_type`	string or SelectableOption	No	-	Type of selection (range or cell) when not loading all data, ‘load_all_data’ must be False. Available options: ‘range’ : this is the default ‘cell’ : this is used when you want to read a single cell from the sheet.
`range`	string	No	-	Range to read when using range selection (e.g., ‘A1:D10’, ‘A:A’, ‘A:C’)
`cell`	string	No	-	Single cell to read when using cell selection (e.g., ‘A1’)
`value_render_option`	string or SelectableOption	No	-	Value render option for reading data from sheet. Available options: ‘UNFORMATTED_VALUE’ : this is the default, this returns the raw value of the cell. ‘FORMATTED_VALUE’ : this returns the formatted value of the cell. ‘FORMULA’ : this returns the formula of the cell if it exists.
`filters`	array of Condition	No	-	Optional filters to apply to the data read from the sheet

Condition

Field	Type	Required	Default	Description
`expression`	string	Yes	-	Field name e.g ‘age’, must match the key names in the data
`operator`	string	Yes	-	The condition operator, must be one of the available operators
`value`	string	Yes	-	The value to compare against
`joiner`	string	No	-	Optional joiner for multiple conditions (e.g., ‘AND’, ‘OR’). Joiner should be added from second condition onwards. Don’t add to the first condition.

SelectItem

Field	Type	Required	Default	Description
`value`	string	Yes	-	The value of the selectable item.
`label`	string	Yes	-	The label of the selectable item, used for display purposes. If not provided, defaults to the value.

SelectableOption

Field	Type	Required	Default	Description
`value`	string	Yes	-
`label`	string	Yes	-

Output

Type: any | List[Dict] Returns single value for cell selection, or list of dicts (rows with headers as keys) for range/all data. Fields: dynamic (depend on the inputs)