List Sheets Metadata - BlinkOps Documentation

Retrieve the metadata of the sheets available for a specific spreadsheet.

External DocumentationTo learn more, visit the Google Sheets documentation.

Basic Parameters

Parameter	Description
Spreadsheet ID	The ID of the spreadsheet.

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

{
	"spreadsheetId": "<string>",
	"properties": {
		"title": "<string>",
		"locale": "<string>",
		"autoRecalc": "<string>",
		"timeZone": "<string>",
		"defaultFormat": {
			"backgroundColor": {
				"red": 853,
				"green": 549,
				"blue": 297
			},
			"padding": {
				"top": 994,
				"right": 281,
				"bottom": 205,
				"left": 832
			},
			"verticalAlignment": "<string>",
			"wrapStrategy": "<string>",
			"textFormat": {
				"foregroundColor": {},
				"fontFamily": "<string>",
				"fontSize": 368,
				"bold": false,
				"italic": false,
				"strikethrough": true,
				"underline": false,
				"foregroundColorStyle": {
					"rgbColor": {}
				}
			},
			"backgroundColorStyle": {
				"rgbColor": {
					"red": 692,
					"green": 351,
					"blue": 540
				}
			}
		},
		"spreadsheetTheme": {
			"primaryFontFamily": "<string>",
			"themeColors": [
				{
					"colorType": "<string>",
					"color": {
						"rgbColor": {}
					}
				}
			]
		}
	},
	"sheets": [
		{
			"properties": {
				"sheetId": 719,
				"title": "<string>",
				"index": 309,
				"sheetType": "<string>",
				"gridProperties": {
					"rowCount": 382,
					"columnCount": 949
				}
			}
		}
	],
	"spreadsheetUrl": "<string>"
}