Quartz 4

Airtable Integration Hub

4 min read

Airtable Integration Hub

Airtable is the RERI dispo-side property database and CRM supplement. The RERI base (appvXPiQLllUQjiBk) is the authoritative source for dispo-ready deals: 90-field schema, 11 views, formula-based readiness checks, and write-back from the dispo pipeline (Short.io URLs, Drive IDs, BA website URLs). Read this hub before any dispo pipeline, Airtable sync, or webhook integration work.

Quick reference

FieldValue
VendorAirtable
URLhttps://airtable.com
KB docAPI
KB doc 2RERI-DISPO-SYSTEM
Auth methodPAT (Personal Access Token)
Auth credentialop://Aurora/airtable/pat
Cred-proxy portn/a (until NemoClaw B1-B6 ratified)
Webhook portn/a (Airtable Automations UI — no inbound handler)
Webhook handlern/a
Webhook dedup tableprocessed_webhook_events (24h TTL)
Tunnel pathn/a
Outbound API basehttps://api.airtable.com/v0
Rate limits5 req/second per base; 429 → exponential backoff (3 retries)
Rate-limit action429 → exp backoff (3 retries), Discord ops alert
CostPaid plan (subscription); API included
Backup/recoveryAirtable-owned; no PITR; manual CSV export recommended weekly
Discord alert channelops
Drift cadenceon-API-change
Statusproduction

Bases

BaseIDPurpose
AI Command Centerapp8RwdwkzQZBYcvgInternal ops tracking
RERI Dispo SystemappvXPiQLllUQjiBkProduction dispo — 90 fields, 11 views

Components

  • workspace/knowledge-base/airtable/API.md — REST API reference, PAT auth, field types, filtering, pagination, webhooks
  • workspace/knowledge-base/airtable/RERI-DISPO-SYSTEM.md — RERI base schema: 90 fields, formula dependencies, dispo-critical fields, write-back fields
  • workspace/knowledge-base/airtable/examples/ — Code examples directory
  • dispo-blast — Consumes Airtable “Properties To Send Out” view (viw4CHylckOCd1E71) as blast trigger
  • betterfiles-dispo-emails — Reads Airtable records for TC email generation
  • _summary — Primary agent reading Airtable dispo views

How it’s used

  • Trigger: Dispo pipeline checks “2.) Properties To Send Out” view (viw4CHylckOCd1E71) for records where Record Ready formula = true
  • Workflow: Dispo blast reads Airtable → syncs to HubSpot dispo pipeline → triggers SMS blast via salesmsg and twilio
  • Write-back: Pipeline writes DOWNLOAD PICTURES (Short.io URL), Google Drive File ID, Better Acquisitions Property Link back to each Airtable record
  • Sync: HubSpot deal ID stored in Hubspot Record ID field (fldqPYzsNxChcBSFR) — bidirectional link
  • Agents involved: dispo reads; betterfiles reads; no agent has write-all-records permission
  • Failure mode: PAT expiry → all dispo reads return 401; rotate via 1Password and redeploy
  • Success criteria: Record Ready formula returns true; DOWNLOAD PICTURES field populated; HubSpot deal stage advances

Dispo-critical field map

FieldIDRole
Record ReadyfldxvDbpEv3l39PpVReadiness gate — formula validates all required fields
SMS Template HS SyncfldQv9w2NCLdpG2lIKey dispo field — SMS template text
DOWNLOAD PICTURESfldag4wLizz8cCEG0Short.io photo link — written by dispo pipeline
Google Drive File IDfldoZB4DvEQNjv6QVWritten by dispo pipeline
Hubspot Record IDfldqPYzsNxChcBSFRHubSpot deal ID — bidirectional sync anchor
STATUSfldueSp7qblmbvOZUSEND OUT / SENT OUT controls blast eligibility

Agents that touch this

  • _summary — primary consumer of RERI dispo base; reads “Properties To Send Out” view
  • _summary — TC agent; reads records for email generation and checklist
  • _summary — reporting; reads across views for deal pipeline summaries

Skills that invoke this

Plans that govern this

Feedback rules

KB / source docs

  • API — REST API reference (last verified 2026-02-27)
  • RERI-DISPO-SYSTEM — RERI base schema (last verified 2026-03-23)

System maps

All credentials stored in 1Password vault Aurora. See 1password for op:// CLI access pattern. Airtable PAT: op://Aurora/airtable/pat. The AI Command Center base PAT (patGWMN7sqhIuZwtZ...) and RERI Dispo PAT (pat8hiR6aayY2Xnzg...) are SEPARATE tokens — do not cross-use.

Airtable uses outbound Automations (UI-configured) rather than an inbound webhook handler. No Tailscale Funnel path required. If inbound events are needed in future, register handler in cloudflare FUNNEL-REGISTRY.md first. See cloudflare for tunnel governance.

  • hubspot — Airtable Hubspot Record ID field syncs to HubSpot deal ID; dispo pipeline dual-writes
  • supabase — Supabase processed_webhook_events used for dedup on any Airtable automation events; RERI website property UUIDs stored in Property ID (Website) field

Open issues / TODOs

  • Confirm current PAT scopes in 1Password match required scopes (data.records:read, data.records:write, schema.bases:read, schema.bases:write)
  • Add dedup logic if Airtable Automation webhooks are wired in future — use processed_webhook_events + webhook_audit_log
  • Verify RERI Dispo base (appvXPiQLllUQjiBk) PAT is separate from AI Command Center PAT and both stored correctly in 1Password
  • Rate limit: 5 req/s per base — batch operations (max 10 records per request) required for any bulk sync; implement if dispo pipeline grows to >50 records/run

Recent activity

  • 2026-05-04: hub created (W3-S5, Wave 3)
  • 2026-03-23: RERI-DISPO-SYSTEM.md last verified (90 fields documented)
  • 2026-02-27: API.md last verified (PAT auth, webhooks, rate limits)

Graph View

Backlinks