Claude-Written Owner Updates: Task Rollup → AI Email Body → Gmail Send with Retry Safety

Problem:

Owner update emails required someone to read through a property's maintenance history and write a personalized summary so updates went out sporadically and in wildly different quality.

Solution:

Built a webhook-triggered Make.com scenario that gets the Property from Airtable, searches its Maintenance Tasks, and text-aggregates them into a context block. That context feeds an Anthropic API call ('Create Email Body') where Claude writes the personalized owner update, which is then sent via Gmail and stamped back onto the Airtable property record. A dedicated error route catches failed AI calls, logs the failure state to Airtable, and triggers a Retry handler so no property silently misses its update.

Result:

Every triggered property now gets a professionally written, task-aware owner email in seconds, with failed runs auto-retried instead of lost