Send batch html email to contacts matching conditions

You could probably do all of that with Airtable’s built-in automations if you want to send the emails directly from your own Gmail or Outlook account, but if you’re going to be sending a ton of bulk email messages, you might hit against the restrictions & sending limits of Gmail and Outlook.

In that case, it would be much better to use a 3rd-party “transactional email” service like SendGrid, although I strongly recommend against using SendGrid. (See below for some other recommendations from me, because I would definitely avoid SendGrid!)

As you mentioned in your message above, if you’re going to use a 3rd-party “transactional email” service, then you would need to automate that by turning to Make’s advanced automations & integrations.

Although, I should add that even if you are sending from your own Gmail or Outlook account, I would still recommend using Make — because it is so much more powerful and so much more customizable than Airtable’s automations. (You would just use Make’s Gmail integrations or Make’s Outlook integrations.)

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable. 

As I mentioned above, I would strongly recommend looking for an alternative to SendGrid. SendGrid is one of the most difficult & frustrating platforms that I have worked with, and their tech support is very poor as well.

My current favorite email sending platform is MailGun. It is easy to setup, easy to configure, and their tech support is very responsive.

However, there are several other email sending apps to choose from as well, such as MailerSend, Postmark, Brevo, and more. (You could even use Mailchimp’s Transactional Email Service, although I don’t like Mailchimp’s support either.)

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Yeah having a Campaigns table makes sense.  With reference to your example it’d be where you select the Project and Country for that campaign and I’ve set up something here for you to check out

Airtable comes with their native ‘Send Email’ action as well as the ability for you to send emails via a Gmail or Outlook account, so you could just handle it all on Airtable really (unless you’re planning on sending out like hundreds of emails a day or something)

Assuming your data looks something like this:

Then your Campaign table would look something like this:

And your automation would look something like this where you’d have a ‘Find Record’ action to look for all the Contacts with that Country selected:

And you’d use the results of that Find Record action to compile all of those contact emails to use in a Send Email action

Thanks you, I’ve made some progress and I am learning a lot, about make.com notably. I’m trying to figure out what is the best for my needs. I will have a look at the possibilities with the send email automation within airtable. What if I want to design an email outside of airtable as a draft in my gmail account and then have that email automatically sent to a list of contact stored in airtable (maybe with some personnalisation as well)? Maybe there’s better way to do this : I’m also ok with learning about different workflow that does this in better ways.

Anyway, I’m learning fast and I appreciate your help.

Be

​@Benef 

You can’t do that with Gmail, but you can do that with MailGun and Make’s MailGun integrations.

You would just create all of your “templates” in MailGun, using variables for the parts of your email templates where you want to personalize the message.

Then, you would use Make to send your emails based on the template of your choice, and you would personalize each email by mapping your variables from each Airtable record to the template.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

What if I want to design an email outside of airtable as a draft in my gmail account and then have that email automatically sent to a list of contact stored in airtable (maybe with some personnalisation as well)?

Hmm, depends on how involved the email design is, really.  Airtable’s Send Email, Gmail, Outlook actions trip up when trying to send out really complex HTML, and that’s your main limiting factor

Definitely try to send it out just with Airtable’s stuff and see how it looks first though, in most cases it works fine

My workflow for this is to create formula fields that incorporate the HTML and personalizations and then use those formula fields in the Send Gmail / Outlook actions.  Works fine!