Tweet Pipeline

Notion-to-Twitter automation — pull approved tweets from a Notion database, schedule one-shot crons for exact post times, and post via X/Twitter OAuth2 API....

Automate tweet posting from a Notion content calendar. Draft tweets in Notion, set status to "Approved" with a scheduled time, and this pipeline handles the rest.

Workflow

Notion DB (Tweet Pipeline)
  ├── Status: Pending → Agent drafts tweet
  ├── Status: Approved → Heartbeat picks up
  │     ├── Future time → Schedules one-shot cron
  │     └── Past due → Posts immediately
  └── Status: Posted → Done (updated by poster)

Notion DB Schema

Property	Type	Values
Title	title	Tweet text
Status	select	Pending, Approved, Posted, Failed
Scheduled	date	ISO datetime with timezone
Platform	select	Twitter, LinkedIn
Posted At	date	Filled after posting

Usage

python3 scripts/tweet_poster.py             # Check and schedule
python3 scripts/tweet_poster.py --dry-run   # Preview without scheduling

Key Lessons

• One-shot crons for exact times — don't batch-post from heartbeat, schedule each tweet individually
• X Free tier: 1,500 tweets/month, 280 char limit, no media upload via API
• Track scheduled tweets in a state file to avoid duplicate scheduling

Files

• scripts/tweet_poster.py — Scheduler (reads Notion, creates crons)
• scripts/tweet_post_one.py — Poster (called by each cron job)