Documentation Index
Fetch the complete documentation index at: https://docs.blinkops.com/llms.txt
Use this file to discover all available pages before exploring further.
Retrieve the metadata of the sheets available for a specific spreadsheet.
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>"
}
Workflow Library Example
List Sheets Metadata with Google Sheets and Send Results Via Email
