Skip to main content
Docs
Go to the Studio
Roberty Studio
RPASpreadsheets

Create spreadsheet

Create spreadsheet

Creates a new Google Sheets spreadsheet.


Options​

Google Sheets connection​

Select the Connection action set up in the flow.

Spreadsheet title​

Enter the title the new spreadsheet will have, for example Minha planilha.

Advanced options​

Extra tabs to create​

Optional. Add one entry for each tab to create, giving the title of each. When there is at least one entry, the spreadsheet is created with only these tabs (Google does not create the default tab). Leave it empty to create the spreadsheet with a single default tab.

Returns​

Javascript code​

js
actions["action-id"].spreadsheetId // ID of the newly created spreadsheet (Text)
actions["action-id"].spreadsheetUrl // URL of the newly created spreadsheet (Text)
actions["action-id"].title // Title of the newly created spreadsheet (Text)

Field selection​

  • spreadsheetId — ID of the newly created spreadsheet (Text)
  • spreadsheetUrl — URL of the newly created spreadsheet (Text)
  • title — Title of the newly created spreadsheet (Text)

Rules and Conditions​

  • The Google Sheets connection and Spreadsheet title fields are required.
  • The Extra tabs to create are optional. When given, the spreadsheet has exactly these tabs, in the order given; Google Sheets' default tab is not created.
  • If the creation fails on Google's side (for example, a response with no spreadsheet ID or URL), the robot stops with an error.