Skip to main content

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?

Hi @Ahmed Bisco 

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

https://zapier.com/apps/google-sheets/integrations#triggers-and-actions

https://zapier.com/apps/google-sheets/help

 

Steps

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