Skip to main content
Add column in Google Sheets
Wrk Product avatar
Written by Wrk Product
Updated over a week ago

Adds a new column into a sheet of a Google Sheets spreadsheet. New column name will be added as a header in the first row.

Avoid using special characters ( ||,== ) in the 'Columns and data" input unless being used to separate assignment expressions )||) or for value assignments (==) (if values contain these characters they can only be passed into the input as a variable)

Common use cases

  • Data Manipulation

  • Data Management

  • Productivity Tools

Application

  • Google Sheets

Inputs (what you have)

NAME

DESCRIPTION

TYPE

REQUIRED

EXAMPLE

Spreadsheet link

The link to the spreadsheet

URL

Yes

https://docs.google.com/spreadsheets/d/1Y/edit

New column name

Specify the header name that the new column should have. This will be added to the first row of the column.

Text

Yes

Column_Name

Existing column location

Specify the header name, letter or number of the column next to which you want to add the new column

Text

Yes

Column_3

Sheet name

The name of the sheet that contains the data. First tab will be used by default. Sheet name is case sensitive

Text

No

Sheet_Name

Note: the value of inputs can either be a set value in the configuration of the Wrk Action within the Wrkflow, or a variable from the Data Library. These variables in the Data Library are the outputs of previous Wrk Actions in the Wrkflow.

Outputs (what you get)

  • N/A

Outcomes

NAME

DESCRIPTION

Success

This status is selected when the column is successfully added in the specified sheet of the Google Sheets spreadsheet.

Unsuccessful

This status is selected in the event of the following scenarios:

- The spreadsheet link was not provided or is invalid

- The spreadsheet is not accessible (no access allowed)

Requirements

  • The provided Link to the Sheet must have editing permissions.

  • All Drives and Sheets need to be shared with: googlewrkbots@wrk.com

Did this answer your question?