Build an Instagram Influencer CRM in Airtable

Open Instagram Followers Exporter Pro while logged into your Instagram account:

1. Click the extension icon and navigate to your Instagram profile
2. Wait for the extension to load your complete followers list
3. Apply filters if desired — for an influencer CRM, filter for follower count ≥ 1,000 to focus on meaningful influencer profiles
4. Click Export CSV to download your followers data

The export provides all the key fields needed for an influencer database: username, display name, bio, follower count, following count, post count, and verified status.

Create a new Airtable base called Instagram Influencer CRM. Set up the main table with these fields:

• Username (Single line text) — primary field
• Display Name (Single line text)
• Followers (Number, integer)
• Following (Number, integer)
• Posts (Number, integer)
• Bio (Long text)
• Verified (Checkbox)
• Profile URL (URL)
• Tier (Single select) — Nano, Micro, Macro, Mega, Celebrity
• Niche (Multiple select) — Fitness, Beauty, Tech, Food, Lifestyle, etc.
• Pipeline Stage (Single select) — Prospect, Contacted, In Discussion, Active, Past Partner
• Engagement Rate (Percent) — manually entered after research
• Collab Notes (Long text)
• Last Contacted (Date)
• Import Date (Date)

Import your Instagram followers CSV into Airtable:

1. Open your Influencer CRM base → main table
2. Click Import data → CSV file from the toolbar
3. Upload your CSV and map columns to the corresponding fields
4. Click Import to populate the table

After import, add a Formula field called Auto Tier to classify followers automatically:

IF(Followers >= 1000000, "Celebrity", IF(Followers >= 100000, "Mega", IF(Followers >= 10000, "Macro", IF(Followers >= 1000, "Micro", "Nano"))))

Use this formula value to populate the Tier single select field in bulk (select all → fill down from the formula values).

Set up multiple Airtable views to manage your influencer relationships:

• Micro Prospects (Grid) — Filter: Tier = Micro, Pipeline Stage = Prospect. Sort: Followers descending. Your primary outreach queue for micro-influencer campaigns.
• Outreach Pipeline (Kanban) — Group by Pipeline Stage. Drag cards through stages as relationships progress from Prospect → Contacted → In Discussion → Active Partner.
• Active Partners (Gallery) — Filter: Pipeline Stage = Active. Shows active influencer partners with bio visible for quick context during campaign planning.
• By Niche (Grid) — Group by Niche. Useful for campaign planning when you need a specific type of influencer (e.g., all Fitness influencers with 5k+ followers).

Create a second Airtable table called Campaigns and link it to your Influencer table using a Linked Record field. This lets you track multiple campaigns per influencer and multiple influencers per campaign:

• Campaign Name (Title)
• Influencers (Linked record → Influencer table) — tag which influencers participated
• Start Date / End Date (Date)
• Platform (Select) — Instagram, Instagram Stories, Instagram Reels, etc.
• Budget (Currency)
• Reach (Number) — combined follower reach of all participating influencers
• Results (Long text) — link clicks, conversions, coupon redemptions
• ROI (Currency) — calculated revenue attributed to the campaign