Airtable CRM Builder

Purpose

Build a powerful CRM database in Airtable with enriched contact and company data. This skill researches your prospects, gathers key information, and creates a structured database to track your sales pipeline and relationships.

When to Use

Use this Skill when you need to:

• Set up a new CRM for your business
• Build a prospect list with enriched data
• Organize contacts from an event or campaign
• Create a database from a list of companies
• Track sales pipeline in Airtable

Step-by-Step Process

Step 1: Define CRM Requirements

Understand what data you need to track.

Ask guiding questions:

• "What type of contacts are you tracking? (leads, customers, partners)"
• "Do you have an existing list to import, or are we building from scratch?"
• "What industries or companies are you targeting?"
• "What fields do you need? (company, role, email, phone, etc.)"
• "Do you want pipeline/stage tracking?"
• "Any custom fields specific to your business?"

Context to gather:

• Contact type and purpose
• Existing data or lists
• Target criteria
• Required fields
• Custom tracking needs

Output Variable: crm_requirements

Step 2: Research Companies and Contacts

Gather and enrich contact data.

If starting from a list:

• Parse provided companies/contacts
• Research each to fill missing data

If building from criteria:

• Use exa_search to find companies matching criteria
• Research company details
• Identify key contacts

For each company, gather:

• Company name and website
• Industry and size
• Location
• Key contacts and roles
• Recent news or updates
• Social profiles

Use perplexity_research for company analysis. Use web_search and web_scrape for detailed information.

Output Variable: researched_contacts

Step 3: Design CRM Structure

Plan the Airtable base structure.

Create table schema:

• Companies Table: Name, Website, Industry, Size, Location, Status, Notes
• Contacts Table: Name, Email, Phone, Role, Company (linked), LinkedIn, Status
• Interactions Table: Date, Type, Contact (linked), Notes, Next Steps
• Deals Table (optional): Value, Stage, Company (linked), Close Date

Define field types:

• Single line text for names
• URL for websites
• Single select for Status/Stage
• Linked records for relationships
• Date fields for tracking
• Long text for notes

Output Variable: crm_schema

Step 4: Create Airtable Base

Build the CRM database in Airtable.

Use AIRTABLE_LIST_BASES to check existing bases. Use AIRTABLE_CREATE_BASE to create a new base for the CRM. Use AIRTABLE_CREATE_TABLE to create each table with proper fields.

Then populate with data: Use AIRTABLE_CREATE_MULTIPLE_RECORDS to add:

• All researched companies
• All contacts with company links
• Initial status/stage values

Verify records were created successfully.

Output Variable: created_crm

Step 5: Finalize and Document

Complete setup and provide guidance.

Deliver:

• Link to the Airtable base
• Summary of records created
• Field descriptions and usage guide
• Suggested views (by status, by industry, etc.)

Create a companion document with:

• CRM structure overview
• Data entry best practices
• Pipeline stage definitions
• Recommended workflows

Suggest next steps:

• Add Airtable automations
• Set up views for different use cases
• Integrate with email tools
• Schedule regular data enrichment

Output Variable: crm_summary

Best Practices

• Keep contact data up to date
• Use consistent status values
• Log all interactions promptly
• Review pipeline weekly
• Enrich data regularly