You can now develop sophisticated and advanced spreadsheets or fully automate the creation of comprehensive spreadsheets like P&L statements with our Add Column in Google Sheets Wrk Action.
The Add Column in Google Sheets Wrk Action allows you to easily and dynamically add one or more columns to create fully customized Google sheets.
How to use it
How to use it
Drag & drop the Wrk Action in your wrkflow designer to the canvas
Click on the Wrk Action to open the configuration panel
Fill in the required fields
Delivery Method
Delivery Method
This Wrk Action is delivered through an API bot.
Configuration
Configuration
Required Fields
Spreadsheet link: The link to the Google Sheet
example: https://docs.google.com/spreadsheets/d/1lcZ1WxaNZAPDy5OWIRjnWpSkUY-8Ip5P7iII3iUAJHI
Must be the full Google Sheets URL including https
Column name: The name of the new column to add
example: Company Name
Character limit is 256
Existing column location: The vertical column location where the new column will be added by column letter (A, B, C, etc...) or number (1, 2, 3, etc...)
example: C (the new column will be added as Column C)
Optional Fields
Sheet name: The name of the sheet the column will be added to
example: active_clients
If not specific, the default will be the first sheet in the Google Sheet
Bot Access
Bot Access
The Google Sheet must be shared with googlewrkbots@wrk.com and be granted edit permissions.
Dynamic Values
Dynamic Values
Almost every configuration field in the Wrkflow designer can be given a dynamic value from a prior step. Simply click on the "Data Library" icon next to the field to pick one or type {{ with your keyboard to open it up.
Outputs
Outputs
This Wrk Action does not produce an output.
Outcomes
Outcomes
Success: Status returned when the Column has been added successfully
Failed: Status returned when there is an error
Example Use Cases
Example Use Cases
Sales tracking: Sales teams can use this Wrk Action to add new columns to their Google Sheets spreadsheet to track important metrics such as revenue, sales volume, and customer feedback.
Social media marketing: Marketing teams can use this Wrk Action to track social media metrics, such as engagement rates, click-through rates, and more.
Financial analysis: Finance teams can use this Wrk Action to add new columns to their financial spreadsheets, such as balance sheets and income statements, to track key financial metrics.
Project management: Project managers can use this Wrk Action to track project timelines, budget, and resource allocation by adding new columns to their project management spreadsheets.
Inventory management: Businesses that manage inventory can use this Wrk Action to add new columns to their inventory spreadsheets to track inventory levels, product quantities, and more.