Skip to main content
Add column in Google Sheets

Automate adding columns in Google Sheets

Mohannad El-Barachi avatar
Written by Mohannad El-Barachi
Updated over a week ago

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.

Automate adding columns in Google Sheets with the Wrk Automation platform at <a href="http://www.wrk.com" target="_blank" rel="nofollow noopener noreferrer">www.wrk.com</a>

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

  1. Drag & drop the Wrk Action in your wrkflow designer to the canvas

  2. Click on the Wrk Action to open the configuration panel

  3. Fill in the required fields

Delivery Method

This Wrk Action is delivered through an API bot.

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

The Google Sheet must be shared with googlewrkbots@wrk.com and be granted edit permissions.

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

This Wrk Action does not produce an output.

Outcomes

Success: Status returned when the Column has been added successfully

Failed: Status returned when there is an error

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.

Did this answer your question?