CLAUDE

Social Content Creation

Create and schedule social media posts for SA businesses via Airtable.

---

Quick Start Commands

Command	Purpose
/get-company [name]	Get company context from Airtable
/plan-posts [company] [weeks]	Plan content for X weeks
/create-posts	Create approved posts in Airtable
/service-highlight [company]	20-week service promotion plan
/special-days [company]	Add SA holiday posts

---

MCP: Airtable

This workspace uses the Airtable MCP (already configured in ~/.claude.json).

Restart Claude Code to load the MCP server if this is your first time.

---

Airtable Structure

Base: GHL_Social_Posting

Base ID: appvZZBI4YecrNWaA

Tables

Table	ID	Purpose
pre_scheduled_posts	tblDbuMzYTDJ6EtFw	Create posts here
Companies	tblzlQAXyuw8uPNMd	Company context

Post Categories

Category	Record ID	Use For
Promote Service	recsRfQfOlJVZbggA	Highlight services
Special Day	recW7BXbuDWIiI17y	Holidays & occasions
General Info	reciBfbQ6PpEQONHs	Tips, education

---

How It Works

1. GET COMPANY CONTEXT
   └─> Airtable Companies table
       ├─ Company name
       ├─ About (description)
       ├─ Partner Services (what they offer)
       ├─ Location
       └─ Brand colors

2. PLAN POSTS
   └─> Generate content_description for each post
       ├─ Based on services offered
       ├─ 1-3 sentences per post
       └─ Approval before creation

3. CREATE IN AIRTABLE
   └─> pre_scheduled_posts table
       ├─ Link to company
       ├─ Link to category
       ├─ Set scheduled_for date
       └─ Add content_description

4. AIRTABLE AI GENERATES
   └─> Auto-populated fields
       ├─ content_title (4-8 words)
       ├─ content_body (full post)
       ├─ content_subtitle
       └─ ai_image_prompt

5. IMAGE GENERATION
   └─> Either:
       ├─ Creatomate (template-based)
       └─ FAL AI (AI-generated)

---

Creating Posts - Field Reference

Required Fields

{
  "fldT62aTKj6BbZrwp": ["recCOMPANY_ID"],     // test_company_id
  "fldDo40lAdJJr0jHC": ["recCATEGORY_ID"],    // post_category
  "fldPxrZY4Ebg1IbVU": "2025-01-06T14:00:00.000Z", // scheduled_for
  "fldBTNgZV94P8UjHh": "Content description..."    // content_description
}

Scheduling Format

• Time: Always 14:00:00.000Z (4pm SAST)
• Format: YYYY-MM-DDTHH:MM:SS.000Z
• Example: 2025-01-06T14:00:00.000Z

---

Content Guidelines

Language & Tone

• Region: South Africa
• Language: British English (colour, organised, specialise)
• Tone: Warm, authentic, professional but approachable

Content Description Rules

• 1-3 sentences maximum
• Focus on ONE specific service or topic
• Include enough context for AI generation
• Stay true to actual services offered

Good Examples

"Highlight palisade fencing installations for residential properties.
Emphasise security benefits and clean aesthetic finish."

"Showcase double carport installations for families with two vehicles.
Focus on weather protection and added property value."

Bad Examples

❌ "Post about fencing" (too vague)
❌ "Emergency fence repairs at night" (edge case)
❌ "Agricultural boundary fencing" (not in services)

---

SA Special Days Calendar

Date	Holiday
Jan 1	New Year’s Day
Feb 14	Valentine’s Day
Mar 21	Human Rights Day
Mar/Apr	Good Friday & Easter Monday
Apr 27	Freedom Day
May 1	Workers’ Day
May (2nd Sun)	Mother’s Day
Jun 16	Youth Day
Jun (3rd Sun)	Father’s Day
Jul 18	Mandela Day
Aug 9	National Women’s Day
Sep 24	Heritage Day
Dec 16	Day of Reconciliation
Dec 25	Christmas Day
Dec 26	Day of Goodwill

---

Company Context Fields

When getting company info, extract:

Field	Purpose
Company name	Use in posts
About Prompt OUTPUT	Primary description
Partner Services	Critical - all content based on this
Business physical address	Location context
Brand Identity Analysis	Visual style
primary_colour / secondary_colour	Brand colors

---

Service Variation Strategies

For “Promote Service” posts, vary by:

Strategy	Examples
Customer Type	Residential vs commercial
Scale	Single vs double vs multi-bay
Location	Home, business, estate, school
Use Case	Pool area, entertainment, parking
Benefit Focus	Security, weather, value, aesthetic

---

Folder Structure

social-content/
├── CLAUDE.md              # This file
├── .claude/commands/      # Slash commands
├── companies/             # Company tracking files
├── templates/             # Post templates
└── strategy/              # Planning docs

---

Company Files

Each company gets a tracking file: companies/[company-name].md

Contains:

• Company record ID
• Services offered
• Location
• All posts created (with dates and status)
• History of actions

---

Related

• Original Cursor project: ~/Dropbox/Shared Cursor Projects/Airtable Social Posts Project/
• Airtable base: https://airtable.com/appvZZBI4YecrNWaA