SkillHub

tweet-pipeline

v1.0.0

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. Use when managing a content calendar in Notion and want automated, precisely-timed tweet posting.

Sourced from ClawHub, Authored by Nissan Dookeran

Installation

Please help me install the skill `tweet-pipeline` from SkillHub official store. npx skills add nissan/tweet-pipeline

Tweet Pipeline

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)