I was curious if anyone had any ideas on how to make the following happen:
- A Zap (or set of Zaps) that runs daily at 9am. It looks within an Asana project section and gets all tasks in that section. For each one, it finds the email address (in the Asana task’s custom field).
- It then takes each email address and sends an email (either via Gmail or Zapier Email) at 9am to all of those email addresses (ideally separately, and not as a BCC).
- Each day, it checks the email fields in that section again, and re-sends the email. It does this for 5 days in a row (per Asana task that it found).
- On day 6 (or at the end of the Day 5 sequence) it moves it to a new section in the Asana project; and thus it will stop finding this task during the Zap.
But obviously for any new Asana tasks that may have been added to that section in the meantime, the Zap continues to run all the time, so any new tasks in that section will also be emailed 5 times.
It's like a Drip campaign.
Essentially: for each new task in that section , grab that email from the field, and email it for 5 days in a row (as long as its still in that Asana section).