Setup AI Content Pipeline: Claude + Notion + Airtable

Manual ini mendokumentasikan setup AI content pipeline yang sudah running di 3 klien agency saya sejak Q4 2025. Sample size: 540+ content piece produced via pipeline ini.

§ 1.1.1 Prerequisites

Sebelum setup, pastikan ada:

• Claude Pro account atau Claude API key ($20/bulan atau ~$3-15 per juta input token)
• Notion workspace (Free plan cukup untuk 1-2 user)
• Airtable account (Free plan cukup untuk <1200 row)
• Zapier atau Make.com (optional, untuk automation antar platform)
• 4-8 jam waktu setup awal (one-time)

§ 1.1.2 Pipeline architecture

┌─────────────┐    ┌──────────────┐    ┌─────────────┐
│   IDEAS     │ →  │   DRAFTING   │ →  │   APPROVAL  │
│  (Notion)   │    │  (Claude API)│    │  (Airtable) │
└─────────────┘    └──────────────┘    └─────────────┘
                                              ↓
┌─────────────┐    ┌──────────────┐    ┌─────────────┐
│  PUBLISHED  │ ←  │   SCHEDULED  │ ←  │  REVIEWED   │
│  (CMS/Web)  │    │   (Buffer)   │    │  (Slack)    │
└─────────────┘    └──────────────┘    └─────────────┘

Stage breakdown:

1. IDEAS — capture topic ideas di Notion. Minimum daftar 30+ ideas sebelum lanjut.
2. DRAFTING — Claude generate draft dari brief + konteks brand.
3. APPROVAL — Airtable form untuk klien review. Status: Pending/Approved/Reject.
4. REVIEWED — final edit + posting prep.
5. SCHEDULED — Buffer/Hootsuite scheduled posting.
6. PUBLISHED — final, tracking metrics.

§ 1.1.3 Step 1: Notion Ideas database

Create database “Content Ideas” dengan field:

Field	Type	Purpose
Title	Text	Idea headline (1-line)
Status	Select	Idea, Brief Ready, Drafting, Approved, Published
Format	Select	Blog post, LinkedIn, Email, Instagram, Twitter
Klien	Relation	Link ke Klien database
Topic Cluster	Multi-select	SEO/AI/Social/Marketing
Priority	Number	1-5
Brief	Rich text	300-500 kata konteks

⚠ Critical: Brief field jadi 80% kualitas output. Slow di sini, fast di drafting.

§ 1.1.4 Step 2: Klien database

Linked database “Klien” dengan field:

Field	Purpose
Brand name	Display
Tone of voice	200-300 kata description voice
Target audience	Demographic + psychographic
Key messages	Multi-select, 5-8 core themes
Don’t say	Kata/topik banned (e.g., “easy”, “viral”)
Brand color/font	Reference untuk visual content

Ini reused di setiap drafting prompt.

§ 1.1.5 Step 3: Claude prompt template

Create reusable prompt:

SYSTEM:
You are a content writer for [BRAND_NAME].

Brand context:
[Tone of voice from Notion.Klien]

Target audience:
[Target audience from Notion.Klien]

Voice constraints:
- Avoid these words: [Don't say list]
- Match: [tone keywords]

TASK:
Write [FORMAT] of [WORD_COUNT] words about:
[BRIEF from Notion.Idea]

Structure requirements:
- Hook opening (1-2 paragraphs)
- Body with H2 subsections
- 1 concrete example or case study
- Closing with actionable CTA

Bahasa Indonesia. Hindari corporate jargon. Tone: [conversational/professional].

Test prompt dengan 5 berbeda topic dulu. Iterate brief sampai output consistent quality.

§ 1.1.6 Step 4: Airtable approval workflow

Create Airtable base “Content Pipeline” dengan:

View "Pending Approval":
- Title (linked back to Notion)
- Draft content (long text)
- Klien (linked)
- Submitted date
- Status: [Pending / Changes Requested / Approved]
- Klien feedback (rich text)
- Decision deadline

Setup auto-share view URL ke klien. Klien review, click approve/reject, write feedback.

Pakai Airtable Automations:

1. Saat status = Approved → Slack notification ke team
2. Saat status = Changes Requested → email ke writer
3. Saat status = Pending > 5 days → reminder klien

§ 1.1.7 Step 5: Posting workflow

Setelah approved:

1. Final edit (15-30 menit human polish)
2. Setup di Buffer/Hootsuite (scheduled)
3. Track UTM parameter di link
4. Update Notion status = Published

⚠ NOTE: Jangan auto-publish dari Airtable. Final human review masih needed (cek date, link, formatting platform-specific).

§ 1.1.8 Throughput metrics

Setelah pipeline running:

• Idea capture: 5-10 per minggu (passive accumulation)
• Draft production: 4-6 per minggu (Claude assist)
• Approval cycle: 2-3 days average
• Publish rate: 4-5 per minggu (drop ~20% di approval)
• Total time per piece: 25-45 menit human (vs 3-4 jam tanpa pipeline)

§ 1.1.9 Common pitfalls

Pitfall	Solution
Brief terlalu generic	Spend 5 min lebih per brief, output 30% lebih baik
Klien lambat approve	Set deadline default 3 hari, auto-publish dengan disclaimer kalau pass
Output AI feel	Edit 30-40% untuk human voice, jangan publish mentah
Tone drift across pieces	Reference voice document di setiap prompt
No content audit	Monthly review: top 10 performing pieces, replicate pattern

§ 1.1.10 Cost breakdown (per bulan)

• Claude Pro: $20 (Rp 320rb)
• Notion: $0 (Free) atau $10 (Plus)
• Airtable: $0 (Free) atau $24 (Teams)
• Zapier: $0 (Free 100 tasks) atau $29 (Starter)

Total minimal: Rp 320rb/bulan. Untuk agency 5 klien × Rp 3-5 juta/bulan retainer = ROI 50x.