u/Pagio94

I’m building a small automation that, every month, sends marketing emails in bulk to a list of addresses.

This list is very fluid and gets updated either with new addresses or by removing the ones that already answered me.
Right now I have the mail database on a Google Sheets document with fields telling me if there’s been an answer in the past and what type (negative, positive, contact again at later date, deactivated mail/full inbox) and I manually create the mails by putting 50 addresses in the bcn fields and sending it to myself. This is not desirable as it’s very slow and cumbersome, I’m changing my approach to sending automated single mails to single recipients.

I don’t want to send mails to people that already answered or with automatically returned mailer daemon responses, but I want to still send emails to people that did not give me an answer. Is there a way to automatically update the list based either on Google Sheets, or other type of documents?