Twitter Keyword & Public-Figure Monitor with Automated Airtable Archiving

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