HTML Emails with SendGrid Block

[climesumer]

Hi there, 

My Goal (Image 1)

• I am trying to automate an email newsletter to send job postings stored in an Airtable base using the SendGrid extension. 

Context:

• In a Jobs table I auto generate the HTML for this list item in a field. (Image 2)
• In a Newsletter table, I lookup the HTML list items, of the jobs that are included in the issue and put it into an unordered list (UL). (Image 3)

The Problem: 

• When I parse the UL {listings} into the Sendgrid extension, it only displays the raw HTML. (Image 4+5)
• When I paste the raw HTML directly into the SendGrid extension, it renders it correctly. (Image 6+7)
• The same is true when I use this in conjunction with an HTML template from SendGrid. 

How can I fix this?
Many thanks


The problem: 
When I parse the 

[ScottWorld]

Sorry that I don’t have the answer for you. Maybe others will have some advice for you.

It’s possible that this is a flaw or a limitation in the SendGrid extension. Personally, I would try this using Make’s SendGrid module, and see if it works properly there. If so, then it seems like it’s a problem with the SendGrid extension. If not, then it is possibly a SendGrid issue.

If it’s an issue with the extension, you can email support@airtable.com to report the problem. 

p.s. There can be a bit of a learning curve with Make, which is why I created this basic navigation video for Make, along with providing the link to Make’s free training courses.

[climesumer]

Hi Scott, thanks for the tips. I tried the make / SendGrid integration but didn't understand how to handle bcc fields and send emails to multiple emails (based on an email lookup field). Additionally, I think the direct integration is sleeker.

Your make video is nice indeed. 

[ScottWorld]

@climesumer 

There are many different ways to handle lookup fields when using Airtable's API (which is what Make uses), but possibly the easiest way is to simply create a formula field in Airtable that looks like this:

{Your Lookup Field} & ""

That will convert your lookup field from "an array of Record ID's" into a "string of text" that you can immediately use elsewhere, such as Make. Be sure to refresh your Airtable module(s) in Make to see the new fields that you just added.

[climesumer]

Hi Scott, I tried it again with Make but no luck. 
I converted all my emails into a string as you suggested but I still get an error and don't see how I can use BCC in the "send an email" block. 
I never used the API (or any API really). Could you point me somewhere? I couldn't find good tutorials on how to send emails from Airtable with Make and SendGrid. 
Thanks for the support!