Skip to main content

Hi!

I would like to create an CRM email system where I create two tables, one for People and another for Emails.


The people table has individuals who need to be sent different kinds of emails depending on their status (new lead, qualified lead, etc).


The Email table contains records for each type of email template, each with a field containing the HTML for the email, including bracketed information specific to an individual (ex: {First Name}, {Email}, {Last Name}, etc).


The system works by linking an email template to a particular user, generating a unique HTML code based on the template and some of the fields unique to the user.


The main problem is the SendGrid block seems to generate the HTML upon hitting “Preview”, not “Send”. That means it just pastes the HTML code as text, rather than generating the email as it should be. All I’m adding to the SendGrid block Body field is referencing the field that contains the HTML code in brackets. That means I can’t actually send different HTML emails using the same SendGrid block. I would rather avoid having to create 10+ send grid blocks for each email template…


Any help? Hopefully I was clear above. Thanks!!

2025 Update:

That is correct… you would have to create 10 different SendGrid extensions, one for each template. It might make it slightly easier by creating multiple different dashboards with descriptive names, so you could just quickly switch to the dashboard that contains the SendGrid extension that you want to use.

However, extensions can’t be automated in any way, so your much better bet of doing all of this is to use Make’s advanced automations & integrations.

Make can be integrated with any email service, and I would highly recommend using either MailerSend or MailGun as your mailing service of choice. I actually do NOT recommend SendGrid, because it is so difficult to use.

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. 

I also give live demonstrations of how to use Make in many of my Airtable podcast appearances. For example, in this video, I show how to work with Airtable arrays in Make.

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

That is correct… you would have to create 10 different SendGrid blocks, one for each template. It might make it slightly easier by creating multiple different dashboards with descriptive names, so you could just quickly switch to the dashboard that contains the SendGrid block that you want to use.


Or you could just keep one SendGrid block, but you’d have to manually copy & paste the HTML that you want to use into the block every time (which would be a real pain).


I agree with you that this should be much better implemented in Airtable. Please be sure to email support@airtable.com to ask them to improve the functionality of the SendGrid block.


Alternatively, you could just automate the whole thing using Integromat’s SendGrid modules (or one of Integromat’s many other email modules). Here are a few of the email modules that Integromat offers:














Thanks Scott! I appreciate you taking the time to answer

Reply


Terms & Conditions