Get Spreadsheet

External DocumentationTo learn more, visit the Google Sheets documentation.

Basic Parameters

Parameter	Description
Include Grid Data	Set to true to return grid data.
Ranges	Sets the ranges of a spreadsheet in the form of `sheetname`!startCell:endCell to be returned. For example, Sheet1!A1-E1 will return the first five cells in the first row of the sheet called “Sheet1”.
Spreadsheet ID	The spreadsheet to request.

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": "16iCeinKeUMxS7g1-A2hTTeLI8iEUcNX23SVJif0te0k",
	"properties": {
		"title": "Test1",
		"locale": "en_US",
		"autoRecalc": "ON_CHANGE",
		"timeZone": "Etc/GMT",
		"defaultFormat": {
			"backgroundColor": {
				"red": 1,
				"green": 1,
				"blue": 1
			},
			"padding": {
				"top": 2,
				"right": 3,
				"bottom": 2,
				"left": 3
			},
			"verticalAlignment": "BOTTOM",
			"wrapStrategy": "OVERFLOW_CELL",
			"textFormat": {
				"foregroundColor": {},
				"fontFamily": "arial,sans,sans-serif",
				"fontSize": 10,
				"bold": false,
				"italic": false,
				"strikethrough": false,
				"underline": false,
				"foregroundColorStyle": {
					"rgbColor": {}
				}
			},
			"backgroundColorStyle": {
				"rgbColor": {
					"red": 1,
					"green": 1,
					"blue": 1
				}
			}
		},
		"spreadsheetTheme": {
			"primaryFontFamily": "Arial",
			"themeColors": [
				{
					"colorType": "TEXT",
					"color": {
						"rgbColor": {}
					}
				},
				{
					"colorType": "BACKGROUND",
					"color": {
						"rgbColor": {
							"red": 1,
							"green": 1,
							"blue": 1
						}
					}
				},
				{
					"colorType": "ACCENT1",
					"color": {
						"rgbColor": {
							"red": 0.25882354,
							"green": 0.52156866,
							"blue": 0.95686275
						}
					}
				},
				{
					"colorType": "ACCENT2",
					"color": {
						"rgbColor": {
							"red": 0.91764706,
							"green": 0.2627451,
							"blue": 0.20784314
						}
					}
				},
				{
					"colorType": "LINK",
					"color": {
						"rgbColor": {
							"red": 0.06666667,
							"green": 0.33333334,
							"blue": 0.8
						}
					}
				}
			]
		}
	},
	"sheets": [
		{
			"properties": {
				"sheetId": 0,
				"title": "Sheet1",
				"index": 0,
				"sheetType": "GRID",
				"gridProperties": {
					"rowCount": 1000,
					"columnCount": 26
				}
			}
		}
	],
	"spreadsheetUrl": "https://docs.google.com/spreadsheets/d/16iCeinKeUMxS7g1-A2hTTeLI8iEUcNX23SVJif0te0k/edit?ouid=107292193942092280363"
}

Integrations

Basic Parameters

Advanced Parameters

Example Output

Workflow Library Example

​Basic Parameters

​Advanced Parameters

​Example Output

​Workflow Library Example

Basic Parameters

Advanced Parameters

Example Output

Workflow Library Example