Skip to content
aeropage-round-dark
Aeropage Documentation
Dynamic Email

Dynamic HTML in Airtable Automations

For Airtable Automations

In this example we will use an Airtable automation ‘Run a Script’ step to fetch the html for each record, and then send it in an email.

Important!

If you are sending your emails using Airtable (Send Email or Gmail) you must have the option below switched on, or your emails will appear broken.

megaphone
Because Airtable automations use markdown, an extra setting is required to remove it before sending.

Untitled.png

Create an automation with the ‘Run a script’ step before the ‘Send an Email’ step.

Untitled 1.png

Click the ‘use in Airtable’ button
In the Aeropage tools interface you can automatically generate the script you will need to pull your html into an automation. Once you see the script, click the copy to clipboard button.

Untitled 2.png

In your script, you will need to add an Input variable for the record id.

Untitled 3.png

Give it the name recordid and for the value, click the [+] and then choose Airtable record ID

Untitled 4.png


When you have done the steps above, click Test and you should see a succesful result like this …

Untitled 5.png

Sending the Email

If you have a paid Google Workspace account we recommend using the Gmail : Send Mail action to send your emails from Airtable Automations, rather than the normal Send Email step that sends using Airtable’s email account. There are numerous benefits.

See the emails in your sent items.
Allow people to reply to your emails.
Remove the ‘Sent by Airtable’ tag.
Show a proper ‘From’ name rather than the airtable generic one.

Untitled 6.png

Now you can add the output of the previous step (script) as the ‘Message’ in your email sending step of the automation.

Untitled 7.png

You can test your automation by sending an email to yourself, and if it all works switch the automation on to run automatically.

Untitled 8.png

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.