Creates a spreadsheet, returning the newly created spreadsheet.
Arguments
| Parameters | |
|---|---|
body |
Required. |
Raised exceptions
| Exceptions | |
|---|---|
ConnectionError |
In case of a network problem (such as DNS failure or refused connection). |
HttpError |
If the response status is >= 400 (excluding 429 and 503). |
TimeoutError |
If a long-running operation takes longer to finish than the specified timeout limit. |
TypeError |
If an operation or function receives an argument of the wrong type. |
ValueError |
If an operation or function receives an argument of the right type but an inappropriate value. For example, a negative timeout. |
Response
If successful, the response contains an instance of Spreadsheet.
Subworkflow snippet
Some fields might be optional or required. To identify required fields, refer to the API documentation.
YAML
- create: call: googleapis.sheets.v4.spreadsheets.create args: body: dataSources: ... developerMetadata: ... namedRanges: ... properties: autoRecalc: ... defaultFormat: backgroundColor: alpha: ... blue: ... green: ... red: ... backgroundColorStyle: rgbColor: ... themeColor: ... borders: bottom: color: ... colorStyle: ... style: ... width: ... left: ... right: ... top: ... horizontalAlignment: ... hyperlinkDisplayType: ... numberFormat: pattern: ... type: ... padding: bottom: ... left: ... right: ... top: ... textDirection: ... textFormat: bold: ... fontFamily: ... fontSize: ... foregroundColor: ... foregroundColorStyle: ... italic: ... link: uri: ... strikethrough: ... underline: ... textRotation: angle: ... vertical: ... verticalAlignment: ... wrapStrategy: ... iterativeCalculationSettings: convergenceThreshold: ... maxIterations: ... locale: ... spreadsheetTheme: primaryFontFamily: ... themeColors: ... timeZone: ... title: ... sheets: ... spreadsheetId: ... spreadsheetUrl: ... result: createResult
JSON
[ { "create": { "call": "googleapis.sheets.v4.spreadsheets.create", "args": { "body": { "dataSources": "...", "developerMetadata": "...", "namedRanges": "...", "properties": { "autoRecalc": "...", "defaultFormat": { "backgroundColor": { "alpha": "...", "blue": "...", "green": "...", "red": "..." }, "backgroundColorStyle": { "rgbColor": "...", "themeColor": "..." }, "borders": { "bottom": { "color": "...", "colorStyle": "...", "style": "...", "width": "..." }, "left": "...", "right": "...", "top": "..." }, "horizontalAlignment": "...", "hyperlinkDisplayType": "...", "numberFormat": { "pattern": "...", "type": "..." }, "padding": { "bottom": "...", "left": "...", "right": "...", "top": "..." }, "textDirection": "...", "textFormat": { "bold": "...", "fontFamily": "...", "fontSize": "...", "foregroundColor": "...", "foregroundColorStyle": "...", "italic": "...", "link": { "uri": "..." }, "strikethrough": "...", "underline": "..." }, "textRotation": { "angle": "...", "vertical": "..." }, "verticalAlignment": "...", "wrapStrategy": "..." }, "iterativeCalculationSettings": { "convergenceThreshold": "...", "maxIterations": "..." }, "locale": "...", "spreadsheetTheme": { "primaryFontFamily": "...", "themeColors": "..." }, "timeZone": "...", "title": "..." }, "sheets": "...", "spreadsheetId": "...", "spreadsheetUrl": "..." } }, "result": "createResult" } } ]