How to Build a Content Repurposing Pipeline With Airtable

Once you repurpose seriously, the bottleneck stops being ideas and becomes tracking. Which clips came from which video? What has already been posted where? A simple Airtable base turns repurposing into a pipeline where every source asset spawns and tracks its children. This guide builds that base.

• An Airtable account (the free plan is enough to start)
• A list of your source content (videos, posts, episodes)
• Optional: an Airtable automation or Zapier connection
• Your social scheduler for the final publish step

Step 1: Create the Sources table

Make a table called Sources with one row per original piece: a long video, a blog post, a podcast episode. Add fields for title, type, URL, and date. This is the parent of everything you will derive.

Step 2: Create the Derivatives table and link it

Make a second table called Derivatives with one row per repurposed asset: a clip, a thread, a carousel. Add a Linked Record field pointing back to Sources, plus fields for platform, format, status, and scheduled date. Now every derivative knows its parent.

Step 3: Add a status field and views

Add a single-select Status field with values like To do, Draft, Scheduled and Posted. Then create filtered views: one showing everything still To do, one grouped by platform, and a calendar view by scheduled date. The views become your daily worklist.

Derivatives table fields
- Asset (single line text)
- Source (link to Sources)
- Platform (single select: TikTok, Reels, Shorts, LinkedIn, X)
- Format (single select: Clip, Thread, Carousel, Audiogram, Quote)
- Status (single select: To do, Draft, Scheduled, Posted)
- Scheduled (date)
- Permalink (URL)

Step 4: Automate the status flip on publish

Connect Airtable to your scheduler with an automation so that when a post goes live, its row flips to Posted and the permalink is filled in. If you prefer no extra tools, an Airtable button field that opens the scheduler and a manual status change still keeps the pipeline honest.

Result: a living base where every original asset shows exactly what has been derived from it and where each piece stands, so you never repost a duplicate or leave a good clip on the shelf.