A client has a spreadsheet with multiple sheets. She adds prospects to different sheets and then has to add them to different lists in Brevo.
The current solution is to create a scenario for each sheet, but this means dozens of scenarios. Is there a way to monitor new rows in any sheet and then route them to the correct list in one single scenario?
That’s what the Watch Changes trigger in Google Sheets is for.
If you leave both fields empty, it sends all changes in all sheets.
For more information, see
3 Likes
Thank you for the quick reply.
I already saw this trigger but had a doubt. Every change to the worksheet triggers it. But every time the client inserts a row, she changes several cells. So how do I avoid running the scenario multiple times for every row?
The only option for me seems to do a check which cell is changed. But I can’t get the column letter from the Watch Changes trigger, right?