Skip to main content
Go to the Studio
Spreadsheets

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 extra tab to create besides the default tab, giving the title of each. 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, each entry produces one additional tab in the spreadsheet, besides the default tab Google Sheets creates automatically.
  • If the creation fails on Google's side (for example, a response with no spreadsheet ID or URL), the robot stops with an error.