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.
Because Airtable automations use markdown, an extra setting is required to remove it before sending.
Create an automation with the ‘Run a script’ step before the ‘Send an Email’ step.
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.
In your script, you will need to add an Input variable for the record id.
Give it the name recordid and for the value, click the [+] and then choose Airtable record ID
When you have done the steps above, click Test and you should see a succesful result like this …
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.
Now you can add the output of the previous step (script) as the ‘Message’ in your email sending step of the automation.
You can test your automation by sending an email to yourself, and if it all works switch the automation on to run automatically.