Sending mail to a list of people with specific field marked

  • 3 March 2022
  • 1 reply


I have a Google sheet with +/-3.000 lines containing a column named SendTo.

It can be 0, it can be 3 or even more people who are marked “Ok”

How can I ask my zap to go through the entire list everyday and send a mail to each people where the field SendTo is “Ok” ?

Thanks to all for the help,


Best Regards,




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 @DanBen00 

You ought to consider using a proper emailing platform where you can manage Contacts into lists.

Check out these email apps:


You’d be better served using an app such as Airtable instead of GSheets.

Airtable has Views:

Views have Filters (e.g. SendTo = OK):

Airtable has APIs:

APIs can be used to query for data in a View.

Advanced logic would have to be implemented to handle API pagination limits and looping.