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

376 views · 📱 Social Media & Email Marketing

💡 Pro Tip — Twitter’s API is paid now, which makes simple data pulls expensive. ScraperNode is a community node that scrapes Twitter profiles and posts without needing API access.

View All Scrapers

Description

Twitter Automation (n8n Template)

🚀 What it does


✅ Requirements


⚡ 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.30.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)

🔗 Nodes Used

X (Formerly Twitter), Schedule Trigger, AI Agent, Google Gemini Chat Model

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup