How to Build a Content Repurposing Pipeline With Airtable

Track every source asset and its derivatives in one base so nothing gets repurposed twice or forgotten.

11 minAdvanced

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.

Airtable - Sources table

Sources

Title | Type | URL | Date

Onboarding webinar | Video | yt.com/... | 2026-06-10

7 onboarding mistakes| Blog | site.com/... | 2026-06-12

Ep 42 with Jordan | Podcast | pod.fm/... | 2026-06-14

One row per original piece of content.

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.

Airtable - Derivatives table

Derivatives

Asset | Source | Platform | Status

Clip 1 (vert) | Onboarding webinar| TikTok | Posted

Clip 1 (vert) | Onboarding webinar| Reels | Scheduled

Carousel | 7 onboarding... | LinkedIn | Draft

Audiogram A | Ep 42 with Jordan | IG | To do

Each child asset links to its source and tracks status.

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.

fields.txt

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.

Airtable automation - script step

Script step: mark a derivative as Posted

$const table = base.getTable("Derivatives");

$const id = input.config().recordId;

$await table.updateRecordAsync(id, { Status: { name: "Posted" } });

Record updated: Status -> Posted

Count derivatives per source

Add a Count field on the Sources table that tallies linked Derivatives. At a glance you can see which source content you have squeezed dry and which still has clips left in it.

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.