airtable-participants

What This Skill Does

The airtable-participants skill serves as the foundational data interface for the Ceremonia retreat ecosystem. By connecting directly to your Airtable base, it enables the OpenClaw agent to query, filter, and extract critical participant information. This skill functions as a read-only gateway, ensuring that your core contact list, retreat attendance status, donation history, and contact metadata remain organized and accessible. It is the designated authoritative source for cross-functional operations, meaning it supplies the necessary recipient lists for email newsletters, SMS outreach, and administrative reporting.

Installation

To integrate this skill into your environment, use the command: clawhub install openclaw/skills/skills/austinmao/airtable-participants. Once installed, you must configure your environment variables. Ensure the AIRTABLE_API_KEY is securely stored in your .env file. You will also need to populate the BASE_ID and TABLE_NAME variables by visiting your Airtable developer dashboard. It is best practice to document these verified constants in your local TOOLS.md and MEMORY.md files for future reference.

Use Cases

This skill is highly versatile for community management and operations. Use it to generate segments for email blasts based on specific retreat dates or tags. It is essential for SMS coordination, as it can filter for active participants with valid phone numbers. Managers can use it to pull high-level analytics, such as the total count of donors versus non-donors or the number of participants currently holding 'prospective' status. It effectively bridges the gap between raw database storage and actionable communication strategy.

Example Prompts

1. "Can you create a list of all active participants tagged with 'february-2026' for our upcoming retreat update?"
2. "How many participants do we currently have in our system, broken down by their retreat status?"
3. "Please export the contact information for all donors so I can prepare a personalized thank-you outreach list."

Tips & Limitations

Airtable returns results in paginated batches of 100 records. When performing large queries or data exports, ensure the agent iterates through the full set using the offset token provided in the API response to avoid incomplete reporting. While the skill is read-only by default to prevent accidental data corruption, any required modifications must be handled through explicit instructions approved by Austin. Always verify the field names in your Airtable schema against the documentation, as custom field naming in Airtable may cause query failures if not mapped correctly during setup.