Social Scheduling: Substack Integration (Long-form Content)

[rdfitted]

Overview

Integrate Substack for publishing long-form content from the CMS.

Requirements

• Publish posts/articles to Substack newsletter
• Support rich text, images, embeds
• Draft vs publish workflow
• Schedule future posts

Technical Notes

No official Substack API - options:

1. Unofficial API wrapper (substack-api on PyPI/npm) - uses cookie auth
2. Browser automation - Playwright/Puppeteer
3. Email-to-post - if Substack supports it

Unofficial API approach:

• Requires substack.sid cookie from authenticated session
• Python: pip install substack-api
• TypeScript wrapper also available
• Can create posts, notes, comments via OwnProfile class

Acceptance Criteria

• Auth flow (cookie-based or alternative)
• Can create draft posts
• Can publish posts
• Rich text/markdown support
• Image uploads
• Schedule for future publish
• UI in CMS for long-form composer

Priority: MEDIUM (after LinkedIn + Facebook)
Note: More complex due to unofficial API - may need browser automation fallback
Refs: https://substack-api.readthedocs.io/