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


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!


Both of your solutions would work in this case.

I would suggest implementing solution 1. Here you would use the “Watch Changes” module.
Screenshot 2023-11-03 at 3.28.28 PM

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

Finally edit the settings of your 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.


Awesome, thank you! I will give this a try :slight_smile: