How to trigger google sheets trigger 'Watch new rows' when a certain column has been filled?

[OptimAIzeLabs]

Hi,

I am currently struggling with a Google Sheets trigger.

I would like to trigger a scenario when a row is added to a sheet, but because I will be adding it manually I need it to trigger when a certain column has been filled (the email column). Right now it seems that it gets triggered immediately after I add one cell to it, but I need the email column for the automation to work.

Regarding the solution, I was thinking of 2 things:

1. Watching a specific column and only triggering the scenario when that column is finished (preferred solution) or
2. Waiting a bit after the row started being updated in order to make sure all information is in google sheet.

Could anyone help?

Thanks in advance!

[IOA_Harman]

Hey

Both of your solutions would work in this case.

I would suggest implementing solution 1. Here you would use the “Watch Changes” module.

Then you will need to install the Make.com add-on in google sheets:

Finally edit the settings of your Make.com add-on:

You can play with this and determine how you want it work, in your case you might only want to trigger it from the range of your email column, or you could let any update trigger it, and then filter in your make scenario.

[OptimAIzeLabs]

Awesome, thank you! I will give this a try