Skip to main content

This is not a new topic and I’ve read through all other topics on adding images to email automations using the <img>

 

I use Airtable formula:
 IF(Attachments, REGEX_EXTRACT(Attachments, "(?:[^(]*\\()([^)]*)"))
to create the url. The image file name has no underscores in it.

 

I’ve done the img src=”formula url”/ and doesn’t work.

I’ve done the Expiring Download trick and doesn’t work.
I’ve created a long text field and added the whole image tag in it then pointed to the long text field in the email body and still didn’t work.

I get the broken images. Results all attempts I’ve made below in image.

 

Any insights where something is going wrong, I feel I’m almost there.

There is no way to use a formula to get a valid URL from an attachment field.

That is outdated information from many years ago, but unfortunately, this community’s search engine returns the oldest posts first in the search results, so everybody sees outdated information first instead of current information.

You would either need to use Airtable’s automations to get the expiring URL, or you would need to use an API automation tool like Make’s advanced automations & integrations to get the expiring URL.

However, the expiring URL will stop working 2 hours after it is viewed for the first time, so that is not a valid option for embedding into emails.

Your best bet is to publicly host your images on a cloud drive somewhere, such as Google Drive.

Then, use the public URL of your publicly hosted image to use in the body of your email.

If you need to automate this process of moving your attachments from Airtable to a cloud drive, you can do it using Make. You can check out my post here on how to move attachments from Airtable to Google Drive.

And if you’re already using Make, you can just send your automated emails from there as well.

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.

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

Hey ​@Michael-Zimmer,

For your specific use case, are attachments static or dynamic? Meaning, will you need to attach different images depending on the record? 

Mike, Consultant @ Automatic Nation 
YouTube Channel 

That’s a great question from ​@Mike_AutomaticN, because if you need to attach different images depending on the record, you could just insert the attachment field itself in the “attachments section” of the email action. Not sure if it would work in the body, but it might.

- ScottWorld, Expert Airtable Consultant

Terms & ConditionsAccessibility statement