Monthly email reminder to a list of people in a Google Sheets

  • 12 August 2023
  • 1 reply


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

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @DCBarnett 

Good question.

Try using the Looping app: