How can I automatically insert a new row in Sheet 2 whenever a new column is updated in Sheet 1?

  • 8 February 2024
  • 1 reply

How can I create an automation to trigger the update or creation of data in the last column and then retrieve that data in a new row in another sheet on Google Sheets, effectively automating the process of transposing data?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @Ahmed Bisco 

Check out the available Zap app triggers/actions for GSheets:



  1. Trigger: GSheets - New/Updated Row
  2. Action: Filter
    1. For the desired column
  3. Action: GSheets - Add Row