This week idea come from indiehacker forum as well, someone would like to build up automated follow-up email, the email will keep sending for a few times unless user viewing that email.

The idea is quite straight forward, but I do a few tweaks for more accessible to demo.

  • Instead of daily sending follow up email, I make it trigger every 15 minutes, there is a counter for it, once the count check reaches 0 no more email will send.
  • The original idea is the email will stop if the user views the email. Most of the time we track the email open with placing an image to check if the image has been load, but now a day this is pretty easy to block by the email client or browser plugin, so I change the condition to unless the user clicks on the link in the email.

I use Airtable to hold the data, Integromat to glue up the process ( my Zapier has been running out of usage, and I would like to give Integromat some testing ) and I use Mailgun for sending email and tracking the email click.

Airtable: Organize anything you can imagine
Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.
Integromat
Integromat is an easy to use, powerful tool with unique features for automating manual processes. Connect your favorite apps, services and devices with each other without having any programming skills.
Mailgun Technologies
Powerful Transactional Email APIs that enable you to send, receive, and track emails, built with developers in mind. Learn more today!

Give it a try and feedback are welcome.

Submit your email to the form - https://airtable.com/shrKooKsXWZ97ZBzH?prefill_count=3&prefill_Read=0, and you should be getting emails within 15 minutes. If you ignore it, and there will be emails keep coming until the count hit zero or you visit the link within the email. Check out the actual data we structure on Airtable https://airtable.com/shr6aAhfY3UxnG8XE/tblLZ4oGyLwyMTYVS?blocks=hide