Find, Scrape & Analyze Twitter Posts by Name with Bright Data & Gemini

Turn any Twitter (X) profile into actionable insights — automatically!

This AI-powered automation collects public X (formerly Twitter) posts, analyzes tone and activity trends using Google Gemini, and delivers a clean, structured report to your Google Sheet — all starting from just a name and date range.

Perfect for researchers, brand strategists, and marketing teams who need fast, reliable social media analysis without manual digging.

What it does:

📝 Accepts a name + date range via a public form
🔎 Uses Google search + Gemini AI to find the correct X profile
📤 Scrapes full post history using Bright Data (with snapshot polling)
📊 Extracts key post metrics: likes, views, hashtags, mentions, replies, and reposts
🧠 Analyzes tone, themes, sentiment, and persona with Google Gemini
📄 Saves both raw data and AI-written summaries to Google Sheets
⚙️ Includes success + fallback handling for edge cases

✅ Setup guide & importable automation included
Requires Bright Data, Gemini (Google), and Google Sheets credentials.

Need help setting it up? We offer full configuration and testing for a one-time fee.