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?
Question
How can I automatically insert a new row in Sheet 2 whenever a new column is updated in Sheet 1?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
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
- Trigger: GSheets - New/Updated Row
- Action: Filter
- For the desired column
- Action: GSheets - Add Row
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.