Hi,
I’ve created a Gsheet with names, emails, dates and credits that expire.
The Gsheet will automatically calculate when the credits expire, but I want to send a monthly reminder to everyone who has active credits.
I have a column set up Y/N for whether the person should be emailed or not.
I built a zap that triggers with the calendar. Works.
I then do a lookup in Gsheets to find a row with ‘Y’ for mailing. Works.
I sent out an email via gmail. Works.
But, it will only send the first one. I want it to go through the whole sheet and send emails to all the ‘Y’ indicated people (but not the ‘N’s)
Please help