n8nflow.net logo

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

by Jay Emp0•Updated: Last update 20 days ago•Source: n8n.io

Getting Started

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

SettingWhereExample
Ads probabilityCode nodeChange Math.random() < 0.3 → 0.2 for 20%
TemplatesCode nodeEdit the templates array
CadenceSchedule TriggerCron or fixed hours
Random delayTime randomizerEnable node (0–120 mins)

🛠️ Troubleshooting

IssueFix
Repeated tweetsEnsure posts has column PAST TWEETS
Not postingReconnect Twitter creds with write access
Promo never usedIncrease ads probability (e.g., 0.4)