Skip to main content
Go to the Studio
Tables

Create table

Create table

Creates a table (named range) in a tab, from a header row.


Options​

Google Sheets connection​

Select the Connection action set up in the flow.

Spreadsheet ID​

Enter the ID of the spreadsheet. The ID can be found in the spreadsheet URL: docs.google.com/spreadsheets/d/{spreadsheetId}/edit.

Tab name or ID​

Enter the tab name (e.g. Página1) or, using the number type, the numeric ID of the tab.

Table name​

Used to reference this table in the next actions, for example Clientes.

Column headers​

Optional. Leave it empty to use whatever is already written in the range's first row as the header. Use the Add header button to include one entry for each column of the table.

Advanced options​

Start row (default: 1)​

Optional. Enter the number of the row, in the tab, where the table header starts.

Start column (default: 1)​

Optional. Enter the number of the column, in the tab, where the table starts.

Returns​

Javascript code​

js
actions["action-id"].namedRangeId // ID of the newly created table (named range) (Text)
actions["action-id"].name // Name of the newly created table (Text)
actions["action-id"].startRow // First row of the table (Number)
actions["action-id"].endRow // Last row of the table (Number)
actions["action-id"].startColumn // First column of the table (Number)
actions["action-id"].endColumn // Last column of the table (Number)
actions["action-id"].headers // List with the table's column headers (List)

Field selection​

  • namedRangeId — ID of the newly created table (named range) (Text)
  • name — Name of the newly created table (Text)
  • startRow — First row of the table (Number)
  • endRow — Last row of the table (Number)
  • startColumn — First column of the table (Number)
  • endColumn — Last column of the table (Number)
  • headers — List with the table's column headers (List)

Rules and Conditions​

  • The Google Sheets connection, Spreadsheet ID, Tab name or ID and Table name fields are required.
  • If Column headers is not given, the robot uses whatever is already written in the range's first row (counting the start row and column) as the table header. If that row is empty, the run stops with an error.
  • If Column headers is given, those values are written to the header row before the table is created, overwriting whatever is already there.
  • The table's width is set by the number of headers. Its height is adjusted automatically to include any data already present right below the header, with a minimum of one row.
  • Start row and Start column are optional and take the value 1 (the tab's first row/column) when not given.
  • If the creation fails on Google's side (for example, a response with no table identifier), the robot stops with an error.