> ## 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.

# List Sheets Metadata

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

<Note>
  External Documentation

  To learn more, visit the [Google Sheets documentation](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/create#http-request).
</Note>

## Basic Parameters

<div className="integrations-table">
  | Parameter      | Description                |
  | -------------- | -------------------------- |
  | Spreadsheet ID | The ID of the spreadsheet. |
</div>

## Advanced Parameters

<div className="integrations-table">
  | Parameter               | Description                                                                                                                                                                                                                                                                                                                  |
  | ----------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
  | Delegated User Override | Perform the action on behalf of another user, overriding the delegated user defined in the connection.<br /><br />If not specified, the delegated user is the one provided in the connection.<br /><br />Has no effect when using an OAuth connection.<br /><br />NOTE: the connection details are not edited by this input. |
</div>

## Example Output

```json theme={"dark"}
{
	"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](https://library.blinkops.com/workflows/list-sheets-metadata-with-google-sheets-and-send-results-via-email)

<div className="iframe-wrapper">
  <div className="iframe-media">
    <img src="https://mintcdn.com/blinkops-2/ojHYuDeYX5FWuN8a/img/Icons/play-box.svg?fit=max&auto=format&n=ojHYuDeYX5FWuN8a&q=85&s=b8af968e71438a9499c3223c9bd29fb2" alt="Workflow Library" width="16" height="16" data-path="img/Icons/play-box.svg" />

    Preview this Workflow on desktop
  </div>

  <iframe className="iframe" src="https://library.blinkops.com/workflows/list-sheets-metadata-with-google-sheets-and-send-results-via-email/canvas" />
</div>