For the past three years, I've been building my automated Airtable processes using Zapier. If you're unfamiliar with it, Zapier is a powerful tool that connects software on the internet using "If this, than that" logic.
A lot of our work here at GAP Consulting relies heavily on automation, so you can imagine my excitement when Airtable released their newest feature: Automations! Now, it's possible to build an automated procedure directly in your database.
While this feature is still early in its lifespan, it already boasts some really advanced functionality. At present, you can trigger automations to run scripts in your database, send email, and create or update Airtable records.
That said, there are some drawbacks to this automation approach. For one, Airtable doesn't connect directly to a slew of ancillary software (yet). Also, the emails that are sent via Airtable Automation come from an Airtable email address, not your personal email.