Thanks for the offer, @Sho. I've pasted some of the code below. My script reads the email body text out of Airtable just fine. It's just that it doesn't populate the values of the fields from the People table. I suspect it may be because the email template is in a different table than the fields themselves, but I don't know how to solve that as a noob.
let sourceTable = base.getTable('People');
// Airtable table containing email templates
let emailTemplateTable = base.getTable('Email Templates');
// Find the UID of the email template you want to use and put it in this variable
let emailTemplateRecordID = 'rec0eEyUzNcGYvD9L'
// Find the email template based on its record ID
let queryResult = await emailTemplateTable.selectRecordAsync(emailTemplateRecordID);
// Find the text of the email template within the template record
let emailBodyText = queryResult.getCellValueAsString("Body Text");
console.log(emailBodyText);
let record = await input.recordAsync('Pick a record', sourceTable);
if (record) {
// get the name, email and message values from the record
let name = record.getCellValue('Name, First')
let emailRecipient = record.getCellValue('Email, Primary')
console.log(name, emailRecipient, emailBodyText)
// now set some of the values in the data object with the record values
let data = {
'personalizations': [
{
'to': [
{
'email': emailRecipient
}
]
}
],
'from': {
'email': SendGridFrom
},
'subject': '👋 Hi ' + name,
'content': [
{
'type': 'text/html',
'value': emailBodyText
}
]
}
let options = {
method: 'POST',
headers: {
'Content-Type': 'application/json',
'Authorization': 'Bearer ' + SendGrid_API
},
body: JSON.stringify(data)
}
let response = await remoteFetchAsync(SendGrid_URL, options)
console.log(response)
}
