cf-switch-backend

Switch Tracking Backend

Switch ContentForge's tracking and delivery backend between Google Sheets + Drive, Airtable, or Local filesystem. Optionally migrate existing tracking data and output files to the new backend.

When to Use

• Switching from local (default) to a cloud backend for collaboration
• Migrating from Google to Airtable (or vice versa) for simpler auth
• Downgrading to local when cloud access isn't needed
• Checking current backend status before switching

Running in Cowork? The "local" backend writes to the ephemeral sandbox filesystem — files vanish at session end. For Cowork team setups, use the Google (Drive) route and run /contentforge:cf-cowork-setup first to wire the Drive folder layout.

How to Use

/contentforge:cf-switch-backend airtable
/contentforge:cf-switch-backend google_sheets
/contentforge:cf-switch-backend local
/contentforge:cf-switch-backend --status

What This Command Does

Step 1: Identify Current Backend

Read the active brand profile's tracking.backend field.

Report current state:

Current backend: local
Records: 47 tracking records (~/.claude-marketing/{brand}/tracking/tracking.json)
Output files: 42 files in ~/.claude-marketing/{brand}/outputs/{YYYY}/{MM}/

Step 2: Validate Target Backend

If switching to Airtable:

1. Check AIRTABLE_TOKEN environment variable exists
2. If missing, guide through setup:
   • Go to airtable.com/create/tokens
   • Create a Personal Access Token with data.records:read and data.records:write scopes
   • Select the base that will hold tracking data
   • Set the environment variable: export AIRTABLE_TOKEN=patXXXXXXXX
3. Ask for the Airtable Base ID (from the base URL: airtable.com/appXXXXXXXXX/...)
4. Verify access by running:

   python {scripts_dir}/airtable-tracker.py --action init --base-id {base_id}
   

If switching to Google Sheets + Drive:

1. Check Google credentials at ~/.claude-marketing/google-credentials.json
2. If missing, guide through setup:
   • Go to Google Cloud Console > IAM & Admin > Service Accounts
   • Create a project (or use existing)
   • Enable Google Sheets API and Google Drive API
   • Create a Service Account and download the JSON key
   • Save to ~/.claude-marketing/google-credentials.json
   • Create a Google Sheet and share it with the service account email (Editor)
   • Create a Google Drive folder and share it with the service account email (Editor)
3. Ask for the Google Sheet ID and Drive folder ID
4. Verify access by running:

   python {scripts_dir}/sheets-tracker.py --action init --sheet-id {sheet_id}