Twitter Keyword & Public-Figure Monitor with Automated Airtable Archiving

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
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