Method: Create a new spreadsheet #2
Description
The ability to create a new spreadsheet.
Method Details
| Property | Value |
|---|---|
| Service Object Name | SpreadSheet (See #3) |
| Service Object Method Name | Create |
| Service Object Method Description | Create a new spreadsheet |
| Execution type | Create |
| Input | Spreadsheet Name, Folder Id |
| Required Inputs | Spreadsheet Name |
| Output | SpreadSheetId |
Validation & Expectations:
- See Service Object: Spreadsheet #3 for the definition of the Service Object Properties
- If folder id is not provided, it should assume the 'root' of the mydrive.
- Spreadsheet Name should be used as the Title of the sheet
- This method will create a new spreadsheet with ONE sheet. The Sheet should be named the same as the Spreadsheet Name.
API to use: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/create