Back to Templates

Automated Content & Promo Tweet Scheduler with Gemini AI and Google Sheets

Created by

Created by: Jay Emp0 || jay-emp0

Jay Emp0

Last update

Last update 22 days ago

Share


Twitter Automation (n8n Template)

🚀 What it does

  • Posts a unique tweet every 2 hours
  • 70% content tweets (10 proven templates)
  • 30% promo tweets pulled from Google Sheets
  • Logs past tweets to avoid duplicates

✅ Requirements

  • n8n
  • Google Sheets with 2 tabs:
    • posts → log of past tweets (PAST TWEETS, Date)
    • promo → promo source (name, last_posted, optional extra fields)
      twitterinfluencerexcel.png
  • Twitter (X) account with OAuth2 write access
  • Gemini API key (for text generation)

⚡ Results

  1. Automated motivational posts
    twitterautomation1.png

  2. Automated promo posts
    twitterautomation2.png


🔄 How It Works

  1. Triggers every 2 hours (optional: random delay up to 120 min).
  2. Randomly selects content (70%) or promo (30%).
  3. Content path: checks posts, generates tweet, logs new one.
  4. Promo path: picks row from promo, generates tweet, updates last_posted.
  5. Posts to Twitter automatically.

🎯 Content Templates

Transformation · Hook–List–Takeaway · Interesting Fact · Metaphor · Contrast · Motivation · Triad · Comparison · 80/20 Rule · Callout


⚙️ Customization

Setting Where Example
Ads probability Code node Change Math.random() < 0.30.2 for 20%
Templates Code node Edit the templates array
Cadence Schedule Trigger Cron or fixed hours
Random delay Time randomizer Enable node (0–120 mins)

🛠️ Troubleshooting

Issue Fix
Repeated tweets Ensure posts has column PAST TWEETS
Not posting Reconnect Twitter creds with write access
Promo never used Increase ads probability (e.g., 0.4)