Create Spreadsheet
Creates a spreadsheet, returning the newly created spreadsheet.
External Documentation
To learn more, visit the Google Sheets documentation.
Basic Parameters
| Parameter | Description |
|---|---|
| Title | The title 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
{
"dataSourceSchedules": [
{
"dailySchedule": {
"startTime": {
"hours": 0,
"minutes": 0,
"nanos": 0,
"seconds": 0
}
},
"enabled": false,
"monthlySchedule": {
"daysOfMonth": [
0
],
"startTime": {
"hours": 0,
"minutes": 0,
"nanos": 0,
"seconds": 0
}
},
"nextRun": {
"endTime": "Optional. Exclusive end of the interval. If specified, a Timestamp matching this interval will have to be before the end.",
"startTime": "Optional. Inclusive start of the interval. If specified, a Timestamp matching this interval will have to be the same or after the start."
},
"refreshScope": "The scope of the refresh. Must be ALL_DATA_SOURCES.",
"weeklySchedule": {
"daysOfWeek": [
"string"
],
"startTime": {
"hours": 0,
"minutes": 0,
"nanos": 0,
"seconds": 0
}
}
}
],
"dataSources": [
{
"calculatedColumns": [
{
"formula": "The formula of the calculated column.",
"reference": {
"name": "The display name of the column. It should be unique within a data source."
}
}
],
"dataSourceId": "The spreadsheet-scoped unique ID that identifies the data source. Example: 1080547365.",
"sheetId": 0,
"spec": {
"bigQuery": {
"projectId": "The ID of a BigQuery enabled GCP project with a billing account attached. For any queries executed against the data source, the project is charged.",
"querySpec": {
"rawQuery": "The raw query string."
},
"tableSpec": {
"datasetId": "The BigQuery dataset id.",
"tableId": "The BigQuery table id.",
"tableProjectId": "The ID of a BigQuery project the table belongs to. If not specified, the project_id is assumed."
}
},
"parameters": [
{
"name": "Named parameter. Must be a legitimate identifier for the DataSource that supports it. For example, [BigQuery identifier](https://cloud.google.com/bigquery/docs/reference/standard-sql/lexical#identifiers).",
"namedRangeId": "ID of a NamedRange. Its size must be 1x1.",
"range": {
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
}
]
}
}
],
"developerMetadata": [
{
"location": {
"dimensionRange": {
"dimension": "The dimension of the span.",
"endIndex": 0,
"sheetId": 0,
"startIndex": 0
},
"locationType": "The type of location this object represents. This field is read-only.",
"sheetId": 0,
"spreadsheet": false
},
"metadataId": 0,
"metadataKey": "The metadata key. There may be multiple metadata in a spreadsheet with the same key. Developer metadata must always have a key specified.",
"metadataValue": "Data associated with the metadata's key.",
"visibility": "The metadata visibility. Developer metadata must always have a visibility specified."
}
],
"namedRanges": [
{
"name": "The name of the named range.",
"namedRangeId": "The ID of the named range.",
"range": {
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
}
],
"properties": {
"autoRecalc": "The amount of time to wait before volatile functions are recalculated.",
"defaultFormat": {
"backgroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"backgroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"borders": {
"bottom": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"style": "The style of the border.",
"width": 0
},
"left": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"style": "The style of the border.",
"width": 0
},
"right": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"style": "The style of the border.",
"width": 0
},
"top": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"style": "The style of the border.",
"width": 0
}
},
"horizontalAlignment": "The horizontal alignment of the value in the cell.",
"hyperlinkDisplayType": "If one exists, how a hyperlink should be displayed in the cell.",
"numberFormat": {
"pattern": "Pattern string used for formatting. If not set, a default pattern based on the user's locale will be used if necessary for the given type. See the [Date and Number Formats guide](/sheets/api/guides/formats) for more information about the supported patterns.",
"type": "The type of the number format. When writing, this field must be set."
},
"padding": {
"bottom": 0,
"left": 0,
"right": 0,
"top": 0
},
"textDirection": "The direction of the text in the cell.",
"textFormat": {
"bold": false,
"fontFamily": "The font family.",
"fontSize": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"italic": false,
"link": {
"uri": "The link identifier."
},
"strikethrough": false,
"underline": false
},
"textRotation": {
"angle": 0,
"vertical": false
},
"verticalAlignment": "The vertical alignment of the value in the cell.",
"wrapStrategy": "The wrap strategy for the value in the cell."
},
"iterativeCalculationSettings": {
"convergenceThreshold": 0,
"maxIterations": 0
},
"locale": "The locale of the spreadsheet in one of the following formats: * an ISO 639-1 language code such as `en` * an ISO 639-2 language code such as `fil`, if no 639-1 code exists * a combination of the ISO language code and country code, such as `en_US` Note: when updating this field, not all locales/languages are supported.",
"spreadsheetTheme": {
"primaryFontFamily": "Name of the primary font family.",
"themeColors": [
{
"color": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"colorType": "The type of the spreadsheet theme color."
}
]
},
"timeZone": "The time zone of the spreadsheet, in CLDR format such as `America/New_York`. If the time zone isn't recognized, this may be a custom time zone such as `GMT-07:00`.",
"title": "The title of the spreadsheet."
},
"sheets": [
{
"bandedRanges": [
{
"bandedRangeId": 0,
"columnProperties": {
"firstBandColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"firstBandColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"footerColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"footerColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"headerColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"headerColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"secondBandColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"secondBandColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
}
},
"range": {
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
},
"rowProperties": {
"firstBandColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"firstBandColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"footerColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"footerColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"headerColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"headerColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"secondBandColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"secondBandColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
}
}
}
],
"basicFilter": {
"criteria": {},
"filterSpecs": [
{
"columnIndex": 0,
"dataSourceColumnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"filterCriteria": {
"condition": {
"type": "The type of condition.",
"values": [
{
"relativeDate": "A relative date (based on the current date). Valid only if the type is DATE_BEFORE, DATE_AFTER, DATE_ON_OR_BEFORE or DATE_ON_OR_AFTER. Relative dates are not supported in data validation. They are supported only in conditional formatting and conditional filters.",
"userEnteredValue": "A value the condition is based on. The value is parsed as if the user typed into a cell. Formulas are supported (and must begin with an `=` or a '+')."
}
]
},
"hiddenValues": [
"string"
],
"visibleBackgroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"visibleBackgroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"visibleForegroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"visibleForegroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
}
}
}
],
"range": {
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
},
"sortSpecs": [
{
"backgroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"backgroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"dataSourceColumnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"dimensionIndex": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"sortOrder": "The order data should be sorted."
}
]
},
"charts": [
{
"border": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
}
},
"chartId": 0,
"position": {
"newSheet": false,
"overlayPosition": {
"anchorCell": {
"columnIndex": 0,
"rowIndex": 0,
"sheetId": 0
},
"heightPixels": 0,
"offsetXPixels": 0,
"offsetYPixels": 0,
"widthPixels": 0
},
"sheetId": 0
},
"spec": {
"altText": "The alternative text that describes the chart. This is often used for accessibility.",
"backgroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"backgroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"basicChart": {
"axis": [
{
"format": {
"bold": false,
"fontFamily": "The font family.",
"fontSize": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"italic": false,
"link": {
"uri": "The link identifier."
},
"strikethrough": false,
"underline": false
},
"position": "The position of this axis.",
"title": "The title of this axis. If set, this overrides any title inferred from headers of the data.",
"titleTextPosition": {
"horizontalAlignment": "Horizontal alignment setting for the piece of text."
},
"viewWindowOptions": {
"viewWindowMax": 0,
"viewWindowMin": 0,
"viewWindowMode": "The view window's mode."
}
}
],
"chartType": "The type of the chart.",
"compareMode": "The behavior of tooltips and data highlighting when hovering on data and chart area.",
"domains": [
{
"domain": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"reversed": false
}
],
"headerCount": 0,
"interpolateNulls": false,
"legendPosition": "The position of the chart legend.",
"lineSmoothing": false,
"series": [
{
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"dataLabel": {
"customLabelData": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"placement": "The placement of the data label relative to the labeled data.",
"textFormat": {
"bold": false,
"fontFamily": "The font family.",
"fontSize": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"italic": false,
"link": {
"uri": "The link identifier."
},
"strikethrough": false,
"underline": false
},
"type": "The type of the data label."
},
"lineStyle": {
"type": "The dash type of the line.",
"width": 0
},
"pointStyle": {
"shape": "The point shape. If empty or unspecified, a default shape is used.",
"size": 0
},
"series": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"styleOverrides": [
{
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"index": 0,
"pointStyle": {
"shape": "The point shape. If empty or unspecified, a default shape is used.",
"size": 0
}
}
],
"targetAxis": "The minor axis that will specify the range of values for this series. For example, if charting stocks over time, the \"Volume\" series may want to be pinned to the right with the prices pinned to the left, because the scale of trading volume is different than the scale of prices. It is an error to specify an axis that isn't a valid minor axis for the chart's type.",
"type": "The type of this series. Valid only if the chartType is COMBO. Different types will change the way the series is visualized. Only LINE, AREA, and COLUMN are supported."
}
],
"stackedType": "The stacked type for charts that support vertical stacking. Applies to Area, Bar, Column, Combo, and Stepped Area charts.",
"threeDimensional": false,
"totalDataLabel": {
"customLabelData": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"placement": "The placement of the data label relative to the labeled data.",
"textFormat": {
"bold": false,
"fontFamily": "The font family.",
"fontSize": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"italic": false,
"link": {
"uri": "The link identifier."
},
"strikethrough": false,
"underline": false
},
"type": "The type of the data label."
}
},
"bubbleChart": {
"bubbleBorderColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"bubbleBorderColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"bubbleLabels": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"bubbleMaxRadiusSize": 0,
"bubbleMinRadiusSize": 0,
"bubbleOpacity": 0,
"bubbleSizes": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"bubbleTextStyle": {
"bold": false,
"fontFamily": "The font family.",
"fontSize": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"italic": false,
"link": {
"uri": "The link identifier."
},
"strikethrough": false,
"underline": false
},
"domain": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"groupIds": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"legendPosition": "Where the legend of the chart should be drawn.",
"series": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
}
},
"candlestickChart": {
"data": [
{
"closeSeries": {
"data": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
}
},
"highSeries": {
"data": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
}
},
"lowSeries": {
"data": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
}
},
"openSeries": {
"data": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
}
}
}
],
"domain": {
"data": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"reversed": false
}
},
"dataSourceChartProperties": {
"dataExecutionStatus": {
"errorCode": "The error code.",
"errorMessage": "The error message, which may be empty.",
"lastRefreshTime": "Gets the time the data last successfully refreshed.",
"state": "The state of the data execution."
},
"dataSourceId": "ID of the data source that the chart is associated with."
},
"filterSpecs": [
{
"columnIndex": 0,
"dataSourceColumnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"filterCriteria": {
"condition": {
"type": "The type of condition.",
"values": [
{
"relativeDate": "A relative date (based on the current date). Valid only if the type is DATE_BEFORE, DATE_AFTER, DATE_ON_OR_BEFORE or DATE_ON_OR_AFTER. Relative dates are not supported in data validation. They are supported only in conditional formatting and conditional filters.",
"userEnteredValue": "A value the condition is based on. The value is parsed as if the user typed into a cell. Formulas are supported (and must begin with an `=` or a '+')."
}
]
},
"hiddenValues": [
"string"
],
"visibleBackgroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"visibleBackgroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"visibleForegroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"visibleForegroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
}
}
}
],
"fontName": "The name of the font to use by default for all chart text (e.g. title, axis labels, legend). If a font is specified for a specific part of the chart it will override this font name.",
"hiddenDimensionStrategy": "Determines how the charts will use hidden rows or columns.",
"histogramChart": {
"bucketSize": 0,
"legendPosition": "The position of the chart legend.",
"outlierPercentile": 0,
"series": [
{
"barColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"barColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"data": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
}
}
],
"showItemDividers": false
},
"maximized": false,
"orgChart": {
"labels": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"nodeColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"nodeColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"nodeSize": "The size of the org chart nodes.",
"parentLabels": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"selectedNodeColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"selectedNodeColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"tooltips": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
}
},
"pieChart": {
"domain": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"legendPosition": "Where the legend of the pie chart should be drawn.",
"pieHole": 0,
"series": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"threeDimensional": false
},
"scorecardChart": {
"aggregateType": "The aggregation type for key and baseline chart data in scorecard chart. This field is not supported for data source charts. Use the ChartData.aggregateType field of the key_value_data or baseline_value_data instead for data source charts. This field is optional.",
"baselineValueData": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"baselineValueFormat": {
"comparisonType": "The comparison type of key value with baseline value.",
"description": "Description which is appended after the baseline value. This field is optional.",
"negativeColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"negativeColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"position": {
"horizontalAlignment": "Horizontal alignment setting for the piece of text."
},
"positiveColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"positiveColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"textFormat": {
"bold": false,
"fontFamily": "The font family.",
"fontSize": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"italic": false,
"link": {
"uri": "The link identifier."
},
"strikethrough": false,
"underline": false
}
},
"customFormatOptions": {
"prefix": "Custom prefix to be prepended to the chart attribute. This field is optional.",
"suffix": "Custom suffix to be appended to the chart attribute. This field is optional."
},
"keyValueData": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"keyValueFormat": {
"position": {
"horizontalAlignment": "Horizontal alignment setting for the piece of text."
},
"textFormat": {
"bold": false,
"fontFamily": "The font family.",
"fontSize": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"italic": false,
"link": {
"uri": "The link identifier."
},
"strikethrough": false,
"underline": false
}
},
"numberFormatSource": "The number format source used in the scorecard chart. This field is optional.",
"scaleFactor": 0
},
"sortSpecs": [
{
"backgroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"backgroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"dataSourceColumnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"dimensionIndex": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"sortOrder": "The order data should be sorted."
}
],
"subtitle": "The subtitle of the chart.",
"subtitleTextFormat": {
"bold": false,
"fontFamily": "The font family.",
"fontSize": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"italic": false,
"link": {
"uri": "The link identifier."
},
"strikethrough": false,
"underline": false
},
"subtitleTextPosition": {
"horizontalAlignment": "Horizontal alignment setting for the piece of text."
},
"title": "The title of the chart.",
"titleTextFormat": {
"bold": false,
"fontFamily": "The font family.",
"fontSize": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"italic": false,
"link": {
"uri": "The link identifier."
},
"strikethrough": false,
"underline": false
},
"titleTextPosition": {
"horizontalAlignment": "Horizontal alignment setting for the piece of text."
},
"treemapChart": {
"colorData": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"colorScale": {
"maxValueColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"maxValueColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"midValueColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"midValueColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"minValueColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"minValueColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"noDataColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"noDataColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
}
},
"headerColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"headerColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"hideTooltips": false,
"hintedLevels": 0,
"labels": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"levels": 0,
"maxValue": 0,
"minValue": 0,
"parentLabels": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"sizeData": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"textFormat": {
"bold": false,
"fontFamily": "The font family.",
"fontSize": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"italic": false,
"link": {
"uri": "The link identifier."
},
"strikethrough": false,
"underline": false
}
},
"waterfallChart": {
"connectorLineStyle": {
"type": "The dash type of the line.",
"width": 0
},
"domain": {
"data": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"reversed": false
},
"firstValueIsTotal": false,
"hideConnectorLines": false,
"series": [
{
"customSubtotals": [
{
"dataIsSubtotal": false,
"label": "A label for the subtotal column.",
"subtotalIndex": 0
}
],
"data": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"dataLabel": {
"customLabelData": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"placement": "The placement of the data label relative to the labeled data.",
"textFormat": {
"bold": false,
"fontFamily": "The font family.",
"fontSize": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"italic": false,
"link": {
"uri": "The link identifier."
},
"strikethrough": false,
"underline": false
},
"type": "The type of the data label."
},
"hideTrailingSubtotal": false,
"negativeColumnsStyle": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"label": "The label of the column's legend."
},
"positiveColumnsStyle": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"label": "The label of the column's legend."
},
"subtotalColumnsStyle": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"label": "The label of the column's legend."
}
}
],
"stackedType": "The stacked type.",
"totalDataLabel": {
"customLabelData": {
"aggregateType": "The aggregation type for the series of a data source chart. Only supported for data source charts.",
"columnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"intervalSize": 0,
"maxValue": 0,
"minValue": 0
}
},
"sourceRange": {
"sources": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
},
"placement": "The placement of the data label relative to the labeled data.",
"textFormat": {
"bold": false,
"fontFamily": "The font family.",
"fontSize": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"italic": false,
"link": {
"uri": "The link identifier."
},
"strikethrough": false,
"underline": false
},
"type": "The type of the data label."
}
}
}
}
],
"columnGroups": [
{
"collapsed": false,
"depth": 0,
"range": {
"dimension": "The dimension of the span.",
"endIndex": 0,
"sheetId": 0,
"startIndex": 0
}
}
],
"conditionalFormats": [
{
"booleanRule": {
"condition": {
"type": "The type of condition.",
"values": [
{
"relativeDate": "A relative date (based on the current date). Valid only if the type is DATE_BEFORE, DATE_AFTER, DATE_ON_OR_BEFORE or DATE_ON_OR_AFTER. Relative dates are not supported in data validation. They are supported only in conditional formatting and conditional filters.",
"userEnteredValue": "A value the condition is based on. The value is parsed as if the user typed into a cell. Formulas are supported (and must begin with an `=` or a '+')."
}
]
},
"format": {
"backgroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"backgroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"borders": {
"bottom": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"style": "The style of the border.",
"width": 0
},
"left": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"style": "The style of the border.",
"width": 0
},
"right": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"style": "The style of the border.",
"width": 0
},
"top": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"style": "The style of the border.",
"width": 0
}
},
"horizontalAlignment": "The horizontal alignment of the value in the cell.",
"hyperlinkDisplayType": "If one exists, how a hyperlink should be displayed in the cell.",
"numberFormat": {
"pattern": "Pattern string used for formatting. If not set, a default pattern based on the user's locale will be used if necessary for the given type. See the [Date and Number Formats guide](/sheets/api/guides/formats) for more information about the supported patterns.",
"type": "The type of the number format. When writing, this field must be set."
},
"padding": {
"bottom": 0,
"left": 0,
"right": 0,
"top": 0
},
"textDirection": "The direction of the text in the cell.",
"textFormat": {
"bold": false,
"fontFamily": "The font family.",
"fontSize": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"italic": false,
"link": {
"uri": "The link identifier."
},
"strikethrough": false,
"underline": false
},
"textRotation": {
"angle": 0,
"vertical": false
},
"verticalAlignment": "The vertical alignment of the value in the cell.",
"wrapStrategy": "The wrap strategy for the value in the cell."
}
},
"gradientRule": {
"maxpoint": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"type": "How the value should be interpreted.",
"value": "The value this interpolation point uses. May be a formula. Unused if type is MIN or MAX."
},
"midpoint": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"type": "How the value should be interpreted.",
"value": "The value this interpolation point uses. May be a formula. Unused if type is MIN or MAX."
},
"minpoint": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"type": "How the value should be interpreted.",
"value": "The value this interpolation point uses. May be a formula. Unused if type is MIN or MAX."
}
},
"ranges": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
]
}
],
"data": [
{
"columnMetadata": [
{
"dataSourceColumnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"developerMetadata": [
{
"location": {
"dimensionRange": {
"dimension": "The dimension of the span.",
"endIndex": 0,
"sheetId": 0,
"startIndex": 0
},
"locationType": "The type of location this object represents. This field is read-only.",
"sheetId": 0,
"spreadsheet": false
},
"metadataId": 0,
"metadataKey": "The metadata key. There may be multiple metadata in a spreadsheet with the same key. Developer metadata must always have a key specified.",
"metadataValue": "Data associated with the metadata's key.",
"visibility": "The metadata visibility. Developer metadata must always have a visibility specified."
}
],
"hiddenByFilter": false,
"hiddenByUser": false,
"pixelSize": 0
}
],
"rowData": [
{
"values": [
{
"dataSourceFormula": {
"dataExecutionStatus": {
"errorCode": "The error code.",
"errorMessage": "The error message, which may be empty.",
"lastRefreshTime": "Gets the time the data last successfully refreshed.",
"state": "The state of the data execution."
},
"dataSourceId": "The ID of the data source the formula is associated with."
},
"dataSourceTable": {
"columnSelectionType": "The type to select columns for the data source table. Defaults to SELECTED.",
"columns": [
{
"name": "The display name of the column. It should be unique within a data source."
}
],
"dataExecutionStatus": {
"errorCode": "The error code.",
"errorMessage": "The error message, which may be empty.",
"lastRefreshTime": "Gets the time the data last successfully refreshed.",
"state": "The state of the data execution."
},
"dataSourceId": "The ID of the data source the data source table is associated with.",
"filterSpecs": [
{
"columnIndex": 0,
"dataSourceColumnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"filterCriteria": {
"condition": {
"type": "The type of condition.",
"values": [
{
"relativeDate": "A relative date (based on the current date). Valid only if the type is DATE_BEFORE, DATE_AFTER, DATE_ON_OR_BEFORE or DATE_ON_OR_AFTER. Relative dates are not supported in data validation. They are supported only in conditional formatting and conditional filters.",
"userEnteredValue": "A value the condition is based on. The value is parsed as if the user typed into a cell. Formulas are supported (and must begin with an `=` or a '+')."
}
]
},
"hiddenValues": [
"string"
],
"visibleBackgroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"visibleBackgroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"visibleForegroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"visibleForegroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
}
}
}
],
"rowLimit": 0,
"sortSpecs": [
{
"backgroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"backgroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"dataSourceColumnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"dimensionIndex": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"sortOrder": "The order data should be sorted."
}
]
},
"dataValidation": {
"condition": {
"type": "The type of condition.",
"values": [
{
"relativeDate": "A relative date (based on the current date). Valid only if the type is DATE_BEFORE, DATE_AFTER, DATE_ON_OR_BEFORE or DATE_ON_OR_AFTER. Relative dates are not supported in data validation. They are supported only in conditional formatting and conditional filters.",
"userEnteredValue": "A value the condition is based on. The value is parsed as if the user typed into a cell. Formulas are supported (and must begin with an `=` or a '+')."
}
]
},
"inputMessage": "A message to show the user when adding data to the cell.",
"showCustomUi": false,
"strict": false
},
"effectiveFormat": {
"backgroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"backgroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"borders": {
"bottom": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"style": "The style of the border.",
"width": 0
},
"left": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"style": "The style of the border.",
"width": 0
},
"right": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"style": "The style of the border.",
"width": 0
},
"top": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"style": "The style of the border.",
"width": 0
}
},
"horizontalAlignment": "The horizontal alignment of the value in the cell.",
"hyperlinkDisplayType": "If one exists, how a hyperlink should be displayed in the cell.",
"numberFormat": {
"pattern": "Pattern string used for formatting. If not set, a default pattern based on the user's locale will be used if necessary for the given type. See the [Date and Number Formats guide](/sheets/api/guides/formats) for more information about the supported patterns.",
"type": "The type of the number format. When writing, this field must be set."
},
"padding": {
"bottom": 0,
"left": 0,
"right": 0,
"top": 0
},
"textDirection": "The direction of the text in the cell.",
"textFormat": {
"bold": false,
"fontFamily": "The font family.",
"fontSize": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"italic": false,
"link": {
"uri": "The link identifier."
},
"strikethrough": false,
"underline": false
},
"textRotation": {
"angle": 0,
"vertical": false
},
"verticalAlignment": "The vertical alignment of the value in the cell.",
"wrapStrategy": "The wrap strategy for the value in the cell."
},
"effectiveValue": {
"boolValue": false,
"errorValue": {
"message": "A message with more information about the error (in the spreadsheet's locale).",
"type": "The type of error."
},
"formulaValue": "Represents a formula.",
"numberValue": 0,
"stringValue": "Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `\"123\"`."
},
"formattedValue": "The formatted value of the cell. This is the value as it's shown to the user. This field is read-only.",
"hyperlink": "A hyperlink this cell points to, if any. If the cell contains multiple hyperlinks, this field will be empty. This field is read-only. To set it, use a `=HYPERLINK` formula in the userEnteredValue.formulaValue field. A cell-level link can also be set from the userEnteredFormat.textFormat field. Alternatively, set a hyperlink in the textFormatRun.format.link field that spans the entire cell.",
"note": "Any note on the cell.",
"pivotTable": {
"columns": [
{
"dataSourceColumnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupLimit": {
"applyOrder": 0,
"countLimit": 0
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"end": 0,
"interval": 0,
"start": 0
},
"manualRule": {
"groups": [
{
"groupName": {
"boolValue": false,
"errorValue": {
"message": "A message with more information about the error (in the spreadsheet's locale).",
"type": "The type of error."
},
"formulaValue": "Represents a formula.",
"numberValue": 0,
"stringValue": "Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `\"123\"`."
},
"items": [
{
"boolValue": false,
"errorValue": {
"message": "A message with more information about the error (in the spreadsheet's locale).",
"type": "The type of error."
},
"formulaValue": "Represents a formula.",
"numberValue": 0,
"stringValue": "Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `\"123\"`."
}
]
}
]
}
},
"label": "The labels to use for the row/column groups which can be customized. For example, in the following pivot table, the row label is `Region` (which could be renamed to `State`) and the column label is `Product` (which could be renamed `Item`). Pivot tables created before December 2017 do not have header labels. If you'd like to add header labels to an existing pivot table, please delete the existing pivot table and then create a new pivot table with same parameters. +--------------+---------+-------+ | SUM of Units | Product | | | Region | Pen | Paper | +--------------+---------+-------+ | New York | 345 | 98 | | Oregon | 234 | 123 | | Tennessee | 531 | 415 | +--------------+---------+-------+ | Grand Total | 1110 | 636 | +--------------+---------+-------+",
"repeatHeadings": false,
"showTotals": false,
"sortOrder": "The order the values in this group should be sorted.",
"sourceColumnOffset": 0,
"valueBucket": {
"buckets": [
{
"boolValue": false,
"errorValue": {
"message": "A message with more information about the error (in the spreadsheet's locale).",
"type": "The type of error."
},
"formulaValue": "Represents a formula.",
"numberValue": 0,
"stringValue": "Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `\"123\"`."
}
],
"valuesIndex": 0
},
"valueMetadata": [
{
"collapsed": false,
"value": {
"boolValue": false,
"errorValue": {
"message": "A message with more information about the error (in the spreadsheet's locale).",
"type": "The type of error."
},
"formulaValue": "Represents a formula.",
"numberValue": 0,
"stringValue": "Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `\"123\"`."
}
}
]
}
],
"criteria": {},
"dataExecutionStatus": {
"errorCode": "The error code.",
"errorMessage": "The error message, which may be empty.",
"lastRefreshTime": "Gets the time the data last successfully refreshed.",
"state": "The state of the data execution."
},
"dataSourceId": "The ID of the data source the pivot table is reading data from.",
"filterSpecs": [
{
"columnOffsetIndex": 0,
"dataSourceColumnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"filterCriteria": {
"condition": {
"type": "The type of condition.",
"values": [
{
"relativeDate": "A relative date (based on the current date). Valid only if the type is DATE_BEFORE, DATE_AFTER, DATE_ON_OR_BEFORE or DATE_ON_OR_AFTER. Relative dates are not supported in data validation. They are supported only in conditional formatting and conditional filters.",
"userEnteredValue": "A value the condition is based on. The value is parsed as if the user typed into a cell. Formulas are supported (and must begin with an `=` or a '+')."
}
]
},
"visibleByDefault": false,
"visibleValues": [
"string"
]
}
}
],
"rows": [
{
"dataSourceColumnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"groupLimit": {
"applyOrder": 0,
"countLimit": 0
},
"groupRule": {
"dateTimeRule": {
"type": "The type of date-time grouping to apply."
},
"histogramRule": {
"end": 0,
"interval": 0,
"start": 0
},
"manualRule": {
"groups": [
{
"groupName": {
"boolValue": false,
"errorValue": {
"message": "A message with more information about the error (in the spreadsheet's locale).",
"type": "The type of error."
},
"formulaValue": "Represents a formula.",
"numberValue": 0,
"stringValue": "Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `\"123\"`."
},
"items": [
{
"boolValue": false,
"errorValue": {
"message": "A message with more information about the error (in the spreadsheet's locale).",
"type": "The type of error."
},
"formulaValue": "Represents a formula.",
"numberValue": 0,
"stringValue": "Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `\"123\"`."
}
]
}
]
}
},
"label": "The labels to use for the row/column groups which can be customized. For example, in the following pivot table, the row label is `Region` (which could be renamed to `State`) and the column label is `Product` (which could be renamed `Item`). Pivot tables created before December 2017 do not have header labels. If you'd like to add header labels to an existing pivot table, please delete the existing pivot table and then create a new pivot table with same parameters. +--------------+---------+-------+ | SUM of Units | Product | | | Region | Pen | Paper | +--------------+---------+-------+ | New York | 345 | 98 | | Oregon | 234 | 123 | | Tennessee | 531 | 415 | +--------------+---------+-------+ | Grand Total | 1110 | 636 | +--------------+---------+-------+",
"repeatHeadings": false,
"showTotals": false,
"sortOrder": "The order the values in this group should be sorted.",
"sourceColumnOffset": 0,
"valueBucket": {
"buckets": [
{
"boolValue": false,
"errorValue": {
"message": "A message with more information about the error (in the spreadsheet's locale).",
"type": "The type of error."
},
"formulaValue": "Represents a formula.",
"numberValue": 0,
"stringValue": "Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `\"123\"`."
}
],
"valuesIndex": 0
},
"valueMetadata": [
{
"collapsed": false,
"value": {
"boolValue": false,
"errorValue": {
"message": "A message with more information about the error (in the spreadsheet's locale).",
"type": "The type of error."
},
"formulaValue": "Represents a formula.",
"numberValue": 0,
"stringValue": "Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `\"123\"`."
}
}
]
}
],
"source": {
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
},
"valueLayout": "Whether values should be listed horizontally (as columns) or vertically (as rows).",
"values": [
{
"calculatedDisplayType": "If specified, indicates that pivot values should be displayed as the result of a calculation with another pivot value. For example, if calculated_display_type is specified as PERCENT_OF_GRAND_TOTAL, all the pivot values are displayed as the percentage of the grand total. In the Sheets editor, this is referred to as \"Show As\" in the value section of a pivot table.",
"dataSourceColumnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"formula": "A custom formula to calculate the value. The formula must start with an `=` character.",
"name": "A name to use for the value.",
"sourceColumnOffset": 0,
"summarizeFunction": "A function to summarize the value. If formula is set, the only supported values are SUM and CUSTOM. If sourceColumnOffset is set, then `CUSTOM` is not supported."
}
]
},
"textFormatRuns": [
{
"format": {
"bold": false,
"fontFamily": "The font family.",
"fontSize": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"italic": false,
"link": {
"uri": "The link identifier."
},
"strikethrough": false,
"underline": false
},
"startIndex": 0
}
],
"userEnteredFormat": {
"backgroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"backgroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"borders": {
"bottom": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"style": "The style of the border.",
"width": 0
},
"left": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"style": "The style of the border.",
"width": 0
},
"right": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"style": "The style of the border.",
"width": 0
},
"top": {
"color": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"colorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"style": "The style of the border.",
"width": 0
}
},
"horizontalAlignment": "The horizontal alignment of the value in the cell.",
"hyperlinkDisplayType": "If one exists, how a hyperlink should be displayed in the cell.",
"numberFormat": {
"pattern": "Pattern string used for formatting. If not set, a default pattern based on the user's locale will be used if necessary for the given type. See the [Date and Number Formats guide](/sheets/api/guides/formats) for more information about the supported patterns.",
"type": "The type of the number format. When writing, this field must be set."
},
"padding": {
"bottom": 0,
"left": 0,
"right": 0,
"top": 0
},
"textDirection": "The direction of the text in the cell.",
"textFormat": {
"bold": false,
"fontFamily": "The font family.",
"fontSize": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"italic": false,
"link": {
"uri": "The link identifier."
},
"strikethrough": false,
"underline": false
},
"textRotation": {
"angle": 0,
"vertical": false
},
"verticalAlignment": "The vertical alignment of the value in the cell.",
"wrapStrategy": "The wrap strategy for the value in the cell."
},
"userEnteredValue": {
"boolValue": false,
"errorValue": {
"message": "A message with more information about the error (in the spreadsheet's locale).",
"type": "The type of error."
},
"formulaValue": "Represents a formula.",
"numberValue": 0,
"stringValue": "Represents a string value. Leading single quotes are not included. For example, if the user typed `'123` into the UI, this would be represented as a `stringValue` of `\"123\"`."
}
}
]
}
],
"rowMetadata": [
{
"dataSourceColumnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"developerMetadata": [
{
"location": {
"dimensionRange": {
"dimension": "The dimension of the span.",
"endIndex": 0,
"sheetId": 0,
"startIndex": 0
},
"locationType": "The type of location this object represents. This field is read-only.",
"sheetId": 0,
"spreadsheet": false
},
"metadataId": 0,
"metadataKey": "The metadata key. There may be multiple metadata in a spreadsheet with the same key. Developer metadata must always have a key specified.",
"metadataValue": "Data associated with the metadata's key.",
"visibility": "The metadata visibility. Developer metadata must always have a visibility specified."
}
],
"hiddenByFilter": false,
"hiddenByUser": false,
"pixelSize": 0
}
],
"startColumn": 0,
"startRow": 0
}
],
"developerMetadata": [
{
"location": {
"dimensionRange": {
"dimension": "The dimension of the span.",
"endIndex": 0,
"sheetId": 0,
"startIndex": 0
},
"locationType": "The type of location this object represents. This field is read-only.",
"sheetId": 0,
"spreadsheet": false
},
"metadataId": 0,
"metadataKey": "The metadata key. There may be multiple metadata in a spreadsheet with the same key. Developer metadata must always have a key specified.",
"metadataValue": "Data associated with the metadata's key.",
"visibility": "The metadata visibility. Developer metadata must always have a visibility specified."
}
],
"filterViews": [
{
"criteria": {},
"filterSpecs": [
{
"columnIndex": 0,
"dataSourceColumnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"filterCriteria": {
"condition": {
"type": "The type of condition.",
"values": [
{
"relativeDate": "A relative date (based on the current date). Valid only if the type is DATE_BEFORE, DATE_AFTER, DATE_ON_OR_BEFORE or DATE_ON_OR_AFTER. Relative dates are not supported in data validation. They are supported only in conditional formatting and conditional filters.",
"userEnteredValue": "A value the condition is based on. The value is parsed as if the user typed into a cell. Formulas are supported (and must begin with an `=` or a '+')."
}
]
},
"hiddenValues": [
"string"
],
"visibleBackgroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"visibleBackgroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"visibleForegroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"visibleForegroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
}
}
}
],
"filterViewId": 0,
"namedRangeId": "The named range this filter view is backed by, if any. When writing, only one of range or named_range_id may be set.",
"range": {
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
},
"sortSpecs": [
{
"backgroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"backgroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"dataSourceColumnReference": {
"name": "The display name of the column. It should be unique within a data source."
},
"dimensionIndex": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"sortOrder": "The order data should be sorted."
}
],
"title": "The name of the filter view."
}
],
"merges": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
],
"properties": {
"dataSourceSheetProperties": {
"columns": [
{
"formula": "The formula of the calculated column.",
"reference": {
"name": "The display name of the column. It should be unique within a data source."
}
}
],
"dataExecutionStatus": {
"errorCode": "The error code.",
"errorMessage": "The error message, which may be empty.",
"lastRefreshTime": "Gets the time the data last successfully refreshed.",
"state": "The state of the data execution."
},
"dataSourceId": "ID of the DataSource the sheet is connected to."
},
"gridProperties": {
"columnCount": 0,
"columnGroupControlAfter": false,
"frozenColumnCount": 0,
"frozenRowCount": 0,
"hideGridlines": false,
"rowCount": 0,
"rowGroupControlAfter": false
},
"hidden": false,
"index": 0,
"rightToLeft": false,
"sheetId": 0,
"sheetType": "The type of sheet. Defaults to GRID. This field cannot be changed once set.",
"tabColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"tabColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"title": "The name of the sheet."
},
"protectedRanges": [
{
"description": "The description of this protected range.",
"editors": {
"domainUsersCanEdit": false,
"groups": [
"string"
],
"users": [
"string"
]
},
"namedRangeId": "The named range this protected range is backed by, if any. When writing, only one of range or named_range_id may be set.",
"protectedRangeId": 0,
"range": {
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
},
"requestingUserCanEdit": false,
"unprotectedRanges": [
{
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
}
],
"warningOnly": false
}
],
"rowGroups": [
{
"collapsed": false,
"depth": 0,
"range": {
"dimension": "The dimension of the span.",
"endIndex": 0,
"sheetId": 0,
"startIndex": 0
}
}
],
"slicers": [
{
"position": {
"newSheet": false,
"overlayPosition": {
"anchorCell": {
"columnIndex": 0,
"rowIndex": 0,
"sheetId": 0
},
"heightPixels": 0,
"offsetXPixels": 0,
"offsetYPixels": 0,
"widthPixels": 0
},
"sheetId": 0
},
"slicerId": 0,
"spec": {
"applyToPivotTables": false,
"backgroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"backgroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"columnIndex": 0,
"dataRange": {
"endColumnIndex": 0,
"endRowIndex": 0,
"sheetId": 0,
"startColumnIndex": 0,
"startRowIndex": 0
},
"filterCriteria": {
"condition": {
"type": "The type of condition.",
"values": [
{
"relativeDate": "A relative date (based on the current date). Valid only if the type is DATE_BEFORE, DATE_AFTER, DATE_ON_OR_BEFORE or DATE_ON_OR_AFTER. Relative dates are not supported in data validation. They are supported only in conditional formatting and conditional filters.",
"userEnteredValue": "A value the condition is based on. The value is parsed as if the user typed into a cell. Formulas are supported (and must begin with an `=` or a '+')."
}
]
},
"hiddenValues": [
"string"
],
"visibleBackgroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"visibleBackgroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"visibleForegroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"visibleForegroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
}
},
"horizontalAlignment": "The horizontal alignment of title in the slicer. If unspecified, defaults to `LEFT`",
"textFormat": {
"bold": false,
"fontFamily": "The font family.",
"fontSize": 0,
"foregroundColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"foregroundColorStyle": {
"rgbColor": {
"alpha": 0,
"blue": 0,
"green": 0,
"red": 0
},
"themeColor": "Theme color."
},
"italic": false,
"link": {
"uri": "The link identifier."
},
"strikethrough": false,
"underline": false
},
"title": "The title of the slicer."
}
}
]
}
],
"spreadsheetId": "The ID of the spreadsheet. This field is read-only.",
"spreadsheetUrl": "The url of the spreadsheet. This field is read-only."
}
Workflow Library Example
Create Spreadsheet with Google Sheets and Send Results Via Email
Preview this Workflow on desktop