Add column in Google Sheets
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