Skip to main content
Go to the Studio
Columns

Add column

Add column

Adds a new column to a table.


Options​

Google Sheets connection​

Select the Connection action set up in the flow.

Spreadsheet ID​

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

Table name​

Enter the name of the table the new column will be added to, for example Clientes. Use the List tables action to discover the names of the existing tables.

New column name​

Enter the name the new column will have.

Advanced options​

Position (default: last column)​

Optional. Enter the position the new column should be inserted at in the table. When not given, the column is added at the end of the table.

Returns​

Javascript code​

js
actions["action-id"].name // Name of the newly added column (Text)
actions["action-id"].index // Position of the newly added column (Number)

Field selection​

  • name — Name of the newly added column (Text)
  • index — Position of the newly added column (Number)

Rules and Conditions​

  • The Google Sheets connection, Spreadsheet ID, Table name and New column name fields are required.
  • If the table given in Table name is not found, the robot stops with an error.
  • Position is optional. When not given, or when given a value greater than the current number of columns plus one, the new column is added at the end of the table.
  • The table is resized automatically to include the new column.