Send application follow-up reminders from Airtable via email and SMS

How it works

This workflow runs on a daily schedule and automatically sends follow-up reminders to candidates who have received an application link but have not yet applied. It checks Airtable for eligible records, calculates how much time has passed since outreach was sent, and decides whether to send a first reminder, second reminder, or no message.

All decision logic is handled in a single Code node, which outputs a simple routing value. This makes the workflow easy to understand and prevents fragile conditional logic.

Each reminder is sent only once. After a reminder is sent, the workflow updates Airtable with a corresponding “sent” flag so the same reminder cannot be sent again on future runs.

Setup steps

Connect your Airtable account and select the table containing candidate records.

Ensure Airtable includes a timestamp field indicating when outreach was sent.

Ensure checkbox fields exist for each reminder (for example, “Reminder 1 Sent” and “Reminder 2 Sent”).