Skip to main content

Create Spreadsheet

Creates a spreadsheet, returning the newly created spreadsheet.

External Documentation

To learn more, visit the Google Sheets documentation.

Basic Parameters

ParameterDescription
TitleThe title of the spreadsheet.

Advanced Parameters

ParameterDescription
Delegated User OverridePerform 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."