Skip to main content

Automated content & promo tweet scheduler with Gemini AI and Google Sheets

Workflow preview

Automated content & promo tweet scheduler with Gemini AI and Google Sheets preview
Open on n8n.io
n8n Cloud
$20/month : Unlimited workflows
2500 executions/month
Try free
Bright Data
THE #1 IN WEB SCRAPING
Scrape any website without limits
Try free
HOSTINGER Hostinger Early Deal
DISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
Try free
Apify
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Try free

Important notice

This workflow is provided as-is. Please review and test before using in production.

Overview

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.3 → 0.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)