Publish Approved Airtable Records to X: Hourly n8n Scheduler

Publish your approved Airtable queue to X automatically—every hour

This n8n workflow scans your Airtable for records marked Approved, posts them to X (Twitter), optionally replies with any extracted URLs as threaded tweets, and then updates Airtable with the Posted At timestamp and Tweet ID.

What this workflow does

• Runs hourly via a schedule trigger to keep your X posting cadence consistent.
• Pulls only approved records from Airtable where the Status field is set to Approved.
• Prepares the tweet text by splitting out any URLs found in the original post text.
• Creates the main X post using the cleaned text (publishing without links when possible).
• Posts extracted links as a reply (if present), threading the reply to the main tweet so you still get the same content coverage.
• Updates Airtable for the originating record: sets Status = Posted, stores Posted At, and saves the Tweet ID.

Use cases

• SaaS teams queue product updates in Airtable and publish them to X once marketing marks them Approved.
• Automation engineers maintain a simple approval pipeline: Draft → Approved → Posted with full traceability.
• Content operations reduce X post link costs by publishing text-only tweets when possible, then threading links separately.

Technical details

• Schedule Trigger (hourly runs)
• Airtable (search for Approved records; update Status, Posted At, Tweet ID)
• X (Twitter) via OAuth2 (create tweets; create threaded replies for extracted URLs)
• Code node (URL extraction and message preparation)
• If node (conditional logic when URLs are present)
• Sticky Note (workflow documentation)

Setup requirements: Configure Airtable credentials and replace the base/table IDs in the Airtable steps. Add X (Twitter) OAuth2 credentials with permission to create tweets, and ensure your X developer account has sufficient API credits.