I would like to send a link in an email that, when clicked, changes the status of a specific record. Is this possible?
Not at this time. Airtable does have a webhook automation trigger, but Airtable webhooks must be called with a POST request. Clickable URLs pass data via a GET request.
Integromat’s webhook will work via a GET request, though. You could create an Integromat scenario that accepts specific data via a webhook, then uses that to update a specific record.