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:
- Watching a specific column and only triggering the scenario when that column is finished (preferred solution) or
- 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!