SendGrid Block Custom HTML based on Linked Record

[Sean_Christense]

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!!

[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:

Integromat

SendGrid Integrations

Start automating your email in minutes with SendGrid and Integromat. Connect SendGrid to Google Contacts, Google Sheets, Typeform, Wufoo, Cognito Forms and many other apps to streamline your workflows.

Integromat

Email Integrations

Integromat gives you the ability to integrate Email with many other services.

Integromat

Gmail Integrations

Gmail integrations for you: Slack, Telegram Bot, ClickUp, Google Drive, Airtable and more. Connect your favorite apps to Gmail to automate workflows, processes and actions. It''s easy with Integromat!

Integromat

Mailchimp Integrations

Integromat gives you the ability to integrate Mailchimp with many other services.

Integromat

Mailgun Integrations

Integromat gives you the ability to integrate Mailgun with many other services.

Integromat

Mandrill Integrations

Raise your transactional email game by connecting Integromat to Mandrill. Automatically add emails to blacklists and whitelists, send messages and set up split testing for your campaigns.

[Sean_Christense]

Thanks Scott! I appreciate you taking the time to answer