airtable-participants
by austinmao
Browser & AutomationBrief
Read and query retreat participant data from the Ceremonia Airtable base.
Description
What This Skill Does
Queries retreat participant data from a Ceremonia Airtable base. Returns contact details, retreat status, tags, and donation info. Acts as the data source for email and SMS outreach skills, which call it to build recipient lists.
Centralizes participant data access so email and SMS skills always query one authoritative source rather than maintaining separate lists.
When to Use It
- Counting active participants before a newsletter send
- Pulling phone-verified contacts for an SMS campaign
- Filtering attendees by retreat tag like 'february-2026'
- Checking donation status across the participant list
- Getting the email list for a specific retreat cohort
Example Workflow
User asks: How many active participants do we have?
- 1
Queries Airtable with filterByFormula for retreat_status='active'
- 2
Paginates through all result pages using offset tokens until no offset is returned
- 3
Counts total records across all pages
Total count of active participants reported to the user
Requirements
- Airtable API key (generate at airtable.com/create/tokens)
- Airtable Base ID for the Ceremonia base (find in Airtable API docs or ask Austin)
- Confirmed participant table name (verify with Austin on first use)
Installation
clawhub install austinmao/airtable-participantsRun the CLI command, or paste the prompt into Claude Code, Cursor, Codex or whichever coding agent you use.