Social Media Automation with n8n
Google Drive → Google Sheets → X (Twitter). Auto-post images with captions, and log Tweet IDs & metadata—end to end, no manual work.
- 📁 Drive folder trigger
- 📃 Caption lookup in Sheets
- ✅ Tweet with media
- 📝 Post log & dedupe
🎬 Demo Video
Short walkthrough of the automation in action.
📸 Screenshots
Key steps and execution views.
📋 Workflow Overview
- 📁 Upload image to a specific Google Drive folder
- 🔔 Google Drive Trigger fires in n8n (new file)
- 📄 Match caption in Google Sheets by filename
- 🡻 Download file, ✅ Upload media to X, then post Tweet + caption
- 🧾 Append log in Sheets (Time, FileID, Filename, CaptionUsed, TweetID, Status)
- ⚡ Dedupe by File ID + handle missing caption gracefully
Tech Stack
n8n
Google Drive API
Google Sheets API
X (Twitter) API
Must-haves implemented
- Missing caption fallback
- Dedupe by file ID
- Post log in Sheets
Outputs
- n8n workflow (JSON)
- GitHub repo & screenshots
- Automation Walkthrough
![Screenshot]()
.png)