‎May 29, 2023 04:57 AM
Hi there,
My Goal (Image 1)
Context:
The Problem:
How can I fix this?
Many thanks
The problem:
When I parse the
‎May 29, 2023 05:36 AM
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.
‎May 29, 2023 11:30 AM
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.
‎May 29, 2023 11:33 AM
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.
‎May 29, 2023 01:34 PM
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!
‎May 29, 2023 01:35 PM