AutomationMart
Home/Browse/Find, scrape & analyze Twitter posts by name with Bright Data & Gemini
n8n

Find, scrape & analyze Twitter posts by name with Bright Data & Gemini

n8nn8n22 modulesv1.0
Google SheetsOpenAIGemini

This n8n workflow template automates the process of collecting and analyzing Twitter (X) posts for any public profile, then generates a clean, AI-powered summary including key metrics, interests, and activity trends. 🚀 What It Does - Accepts a user's full name and date range through a public form. - Automatically finds the person’s X (formerly Twitter) profile using a Google search. - Uses Bright Data to retrieve full post data from the X.com profile. - Extracts key post metrics like views, like

At a glance

Find, scrape & analyze Twitter posts by name with Bright Data & Gemini is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, OpenAI, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, OpenAI, Gemini
Modules
22
Price
Free
Version
v1.0
Find, scrape & analyze Twitter posts by name with Bright Data & Gemini workflow diagram

About this workflow

This n8n workflow template automates the process of collecting and analyzing Twitter (X) posts for any public profile, then generates a clean, AI-powered summary including key metrics, interests, and activity trends. 🚀 What It Does - Accepts a user's full name and date range through a public form. - Automatically finds the person’s X (formerly Twitter) profile using a Google search. - Uses Bright Data to retrieve full post data from the X.com profile. - Extracts key post metrics like views, likes, reposts, hashtags, and mentions. - Uses Google Gemini (PaLM) to generate a personalized summary: tone, themes, popularity, and sentiments. - Stores both raw data and the AI summary into a connected Google Sheet for further review or team collaboration. 🛠️ Step-by-Step Setup 1. Deploy the public form to collect full name and date range. 2. Build a Google search query using the name to find their X profile. 3. Scrape the search results via Bright Data (Web Unlocker zone). 4. Parse the page content using the HTML node. 5. Use Gemini AI to extract the correct X profile URL. 6. Pull full post data via Bright Data dataset snapshot API. 7. Transform post data into clean structured fields: dateposted, description, hashtags, likes, views, quotedpost.dateposted, quotedpost.description, replies, reposts, quotes, and taggedusers.profilename. 8. Analyze all posts using Google Gemini for interest detection and persona generation. 9. Save results to a Google Sheet: structured post data + AI-written summary. 10. Show success or fallback messages depending on profile detection or scraping status. 🧠 How It Works: Workflow Overview - Trigger: When user submits form - Search & Match: Google search → HTML parse → Gemini filters matching X profile - Data Gathering: Bright Data → Poll for snapshot completion → Fetch post data - Transformation: Extract and restructure key fields via Code node - AI Summary: Use Gemini to analyze tone, interests, and trends - Export: Save results to Google Sheet - Fallback: Display custom error message if no X profile found 📨 Final Output - A record in your Google Sheet with: - Clean post-level data - Profile-level engagement summary - An AI-written overview including tone, common topics, and post popularity 🔐 Credentials Used - Bright Data account (for search & post scraping) - Google Gemini (PaLM) or Gemini Flash via - OpenAI/Google Vertex API - Google Sheets (OAuth2) account (for result storage) ⚠️Community Node Dependency This workflow uses a custom community node: n8n-nodes-brightdata Install it via UI (Settings → Community Nodes → Install).

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Send new rows with records from Google Sheets to Facebook Offline Conversions

When a new row is made in Google Sheets, the record is sent to Facebook Offline Conversions.

Free

Add a new Google Sheets row for every new MoreApp form submission

This template helps you collect and organize MoreApp form data in Google Sheets automatically. It’s ideal for teams who want to centralize submissions, reduce manual work, and keep form responses ready for reporting or further automation.

Free

Track investor data from Crunchbase to Google Sheets for market analysis

Automated pipeline to collect and analyze investor data from Crunchbase, tracking investment patterns, funding history, and portfolio companies for market analysis and lead generation. 🚀 What It Does - Investor Profiling: Collects comprehensive data on investors and VC firms - Investment Pattern Analysis: Tracks funding history and investment preferences - Portfolio Monitoring: Keeps tabs on investor portfolios and new investments - Data Enrichment: Enhances raw data with additional context and

Free

Promote YouTube videos on Reddit with AI-generated comments and email digest

Motivation Are you a small YT channel looking to grow to 1000 subs ? This workflow has helped me grow to 80 subs via Reddit Marketing. Check out the YT Tutorial. What it is This n8n workflow automates the process of promoting your YouTube videos on Reddit. It identifies relevant Reddit posts, generates humanized comments tailored to your video content, and delivers a weekly digest of opportunities directly to your inbox. How It Works A user submits their YouTube video URL and email through a fo

Free

Create Signable users from new Google Sheets spreadsheet rows

Every time a new row is added to a Google Sheets spreadsheet, Make will automatically create a new user in Signable.

Free

Add Google Sheets rows for new Mailparser.io emails

Every time a new email is parsed in mailparser.io, Make will automatically save a corresponding data row in Google Sheets.

Free

Generate deep research markdown reports with GPT, Tavily Search, and Google Sheets

This workflow generates deep researched report in markdown format and saves it in Google Sheet, that I then use for generating blogs for my website - Architjn Blogs How it works 1. User submits a search topic through a form. 2. AI generates five deep-dive subtopics for that main topic. 3. AI creates a research report intro, title, and table of contents based on those topics. 4. Each subtopic is sent to a search API (Tavily) to collect top 5 sources. 5. AI writes detailed Markdown content for eac

Free

AI agent: Find the right LinkedIn profiles in seconds

Automate LinkedIn Prospecting with AI Agent and Get Results Straight to Google Sheets! A practical AI-powered workflow that helps you find relevant LinkedIn profiles using natural language queries and saves the results automatically to Google Sheets. 🎯 What It Actually Does - Accepts natural language requests (e.g., "Find marketing managers in Paris") - Uses AI to extract search parameters: - Job titles - Industry - Location - Searches for matching LinkedIn profiles - Saves profile URLs and t

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free