Notify non-attendees in Airtable, send email via Mailchimp Transactional, and add/update subscriber in Mailchimp

Notify participants who missed an event by sending them a personalized email through Mailchimp Transactional, while adding or updating their status in Mailchimp. This boosts future registration and engagement.