[Database integration]

Trigger postal mail from Airtable records

Use Airtable as the record-of-truth for notices, permit tasks, campaigns, and operations queues, then attach outbound mail status, forwarded documents, and inbound mail photos back to the same row.

Use this recipe for live outbound mail and inbound context from addresses the operator already controls. New real mailing and package addresses with street address + mailbox number: Not live yet · Launch ETA: mid/late September. Route requests to the reservation list; reservations do not assign or activate an address today.

recommended shape
source app trigger
agent or code drafts
mailbox.bot dry run
approval gate
delivery webhook
address requests reserve spot
Best for
Lightweight CRMs and ops trackers.
Permit, property, vendor, or stakeholder lists that need physical mail and a visible proof trail.
Approval tables where status changes should create postal mail and later collect returned artifacts.
Triggers
Record status changes to Ready to Mail.
A view contains approved recipients.
A formula identifies a deadline or failed digital follow-up.
[Workflow]
1

Airtable automation, script, Zapier, n8n, or agent reads the record.

2

Letter/PDF is generated from fields and attachments.

3

mailbox.bot dry run validates recipient, mail class, and cost.

4

Approval field gates the live send.

5

Webhook writes tracking, delivery proof, forwarded documents, and mail-photo attachments back to Airtable.

Technical pattern
Use Airtable record IDs in metadata.
Use a single attachment field for the generated document or a template renderer upstream.
Store mailbox.bot mail_id, status, tracking, proof URL, and inbound artifact attachment fields back on the record.
Metadata to preserve
source=airtable
base_id
table_id
record_id
view_id
workflow
POST/api/v1/maildry_run=true
curl -X POST https://mailbox.bot/api/v1/mail \
  -H "Authorization: Bearer sk_agent_test_..." \
  -H "X-Mailbox-MD-Version: 3" \
  -H "X-Max-Cost-Cents: 1500" \
  -F "document=@notice.pdf" \
  -F "recipient_name=Recipient Name" \
  -F "recipient_line1=123 Main Street" \
  -F "recipient_city=San Francisco" \
  -F "recipient_state=CA" \
  -F "recipient_zip=94105" \
  -F "mail_class=certified" \
  -F "dry_run=true" \
  -F 'metadata[source]=airtable'
Agent prompts
"When an Airtable record enters Ready to Mail, use mailbox.bot to create a dry run and update the record with the estimate."
"Build an Airtable approval flow for certified notices with mailbox.bot delivery proof written back to the table."