Add the ‘Create Column’ Tool step to your Tool

You can add the ‘Create Column’ Tool step to your Tool by:
  1. Creating a new Tool, then searching for the ‘Create Column’ Tool step
  2. Click ‘Expand’ to see the full Tool step
  3. Using the dropdown menu:
    • Select the account you would like to use.
    • Select the Drive you would like to use (defaults to “My Drive”).
    • Select the Spreadsheet you would like to create the column in.
    • Select the worksheet you would like to create the column in.
  4. Enter the letter of the column where you would like to create the column.
  5. Click ‘Run step’ to test out the Tool

Parameters

Drive
string
The Drive you want to use. By default, the tool uses “My Drive”.
Spreadsheet ID
string
required
The ID of the spreadsheet you want to create the column in.
Worksheet ID
string
required
The ID of the worksheet you want to create the column in.
Column Letter
string
The location of the new column you want to create. The new column will be inserted to the right of the column letter you provide.