📊 Twitter Keyword & Public-Figure Monitor with Automated Airtable Archiving
⚡ 934 views · 📊 Market Research & Insights
💡 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.
Description
Monitor & Archive Keyword Tweets to Airtable
📌 Overview
Automatically searches Twitter for any keyword/topic (person, brand, hashtag), filters duplicates, and stores new tweets in Airtable with rich metadata - all on a daily schedule.
🛠️ Workflow Steps
-
⏰ Schedule Trigger
Runs daily at 8 AM (customizable) -
🐦 Twitter Search
Fetches 100 latest tweets matching your keyword -
📦 Reformat Data
Structures:- Text | Likes | ID | URL
- Author | Timestamp
-
🗂️ Fetch Airtable Records
Retrieves existing tweet IDs -
🔍 Deduplicate
Compares IDs to exclude duplicates -
➕ Append New Tweets
Saves only fresh entries to Airtable
💡 Key Benefits
- 🤖 Automated Monitoring: Near real-time tracking
- 🧹 Clean Data: Zero duplicate entries
- 📁 Structured Archive: Organized metadata for analysis
- ⚙️ Fully Customizable: Adapt keywords/schedule/output
🧩 Perfect For
- Social media analysts tracking brand mentions
- Journalists monitoring public figures
- Researchers archiving topic conversations
- Marketing teams measuring campaign reach
🚀 Getting Started
- Import into n8n
- Connect Credentials:
- Twitter API keys
- Airtable base + table ID
- Configure:
- Search keyword (e.g.,
"Narendra Modi") - Schedule timing
- Search keyword (e.g.,
- Run & Forget:
- Initial run to backfill
- Daily auto-archiving
✅ Enhancement Ideas
-
Add Filters:
- Exclude retweets
- Filter by language
- Geolocation targeting
-
Notifications:
- Slack alerts for new tweets
- Email digests
-
AI Extensions:
- Sentiment analysis
- Auto-categorization
- Trend reporting
🔗 Nodes Used
Airtable, X (Formerly Twitter), Schedule Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File