Need Help Copy data from one google sheet to another sheet

[Naveensurya]

Hello everyone
Iam working 2 automations
google form -> master google sheet ( when every any one fills form based on user inputs master sheet will add some data) This automation working fine
master google sheet -> copy of master google sheet ( when every a new row added on master google sheet need copy that row to copy of master google sheet

This is not working

when ever any one fills my google form my automation will trigger and based on user form inputs i will do add some data and store in master sheet ( My aim it keep this data safe don't change any thing on this data
to performs some operations on this data i have created new sheet with name copy of master data and copy this data and their will do my operations but second automation not working

here is my second work flow link

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[ArshilAhmad]

Hi @Naveensurya,

The way you have currently setup your workflow whenever a new row is added to 'Master Lead Database' it will automatically be added to 'LMS-0.1V'. This workflow appears to be working correctly.

Could you please make a short screen recording elaborating a bit more on your exact concern?

 

[Naveensurya]

Hi @Naveensurya,

The way you have currently setup your workflow whenever a new row is added to 'Master Lead Database' it will automatically be added to 'LMS-0.1V'. This workflow appears to be working correctly.

Could you please make a short screen recording elaborating a bit more on your exact concern?

Thank you for your prompt response i have test data added but i there is daly after 1 hour data added to LMS-0.1V
Could you please help to change execution time my automation setup to Instant only and in master lead database sheet i have enabled Send on event

 

[ArshilAhmad]

Although not immediate, you can use App script to reduce the waiting time to 1 minute. To assist you in sending new rows every minute, I have included a link to the relevant thread.

Google Sheets (1 Minute Trigger) Send New rows in every 1 minute.

In this tutorial, we will see how can you set up Google sheets trigger "New or Updated Spreadsheet Row" in Google Sheet so that you can capture data every minute. Please note: We also offer a Pabbly Connect Webhooks addon for Google Sheets. The current limitations of the Google Sheets trigger...

forum.pabbly.com