Generate 360 social media reports with AI - Bright Data MCP
Social Media Intelligence Workflow with Bright Data and OpenAI
Get a 360 Social media presence report for a person
Who's it for
Business development professionals, recruiters, sales teams, and market researchers who need comprehensive social media intelligence on individuals for lead qualification, due diligence, partnership evaluation, or candidate assessment.
How it works
- Enter target person's details through the web form (name, company, location)
- AI Discovery Agent searches across selected platforms using name variations
- Profile validator verifies discovered profiles with confidence scoring
- Platform-specific agents analyze each profile using Bright Data MCP tools
- GPT-4 synthesizes all data into a comprehensive intelligence report
- Report automatically generated as formatted Google Doc with direct link
Requirements
- Bright Data MCP account with PRO access (Get your Bright Data API key here)
- OpenAI API key (or alternative LLM provider)
- Google Drive OAuth connection for report delivery
- n8n self-hosted instance or cloud account
How to set up
- Update Bright Data credentials:
- Find "Bright Data MCP" node (look for red warning note)
- Replace YOUR_BRIGHT_DATA_TOKEN_HERE with your actual token
- Update UNLOCKER_CODE_HERE with your unlocker code
- Update Google Drive settings:
- Find "Create Empty Google Doc" node
- Select target folder there
- Configure your LLM credentials (OpenAI or alternative)
- Test with your own name using "Basic" search depth

How to customize the workflow
- Add platforms: Extend the Switch node with new cases and create corresponding prompt builders
- Modify analysis depth: Edit the platform-specific prompt builders to focus on different metrics
- Change report format: Update the final LLM Chain prompt to adjust report structure
- Add notifications: Insert Slack or email nodes after report generation
- Adjust confidence thresholds: Modify validators to change profile verification requirements
- Alternative outputs: Replace Google Docs with PDF, Excel, or webhook to CRM
Generate 360 Social Media Reports with AI - Bright Data MCP
This n8n workflow leverages AI to generate comprehensive 360-degree social media reports. It takes user input via a form, interacts with an AI agent powered by an OpenAI chat model and a Bright Data MCP (Model Context Protocol) client, and then compiles the generated report into a downloadable Markdown file.
What it does
This workflow automates the following steps:
- Triggers on Form Submission: The workflow starts when a user submits data through an n8n form.
- Initializes AI Agent: Sets up an AI agent with a simple memory to maintain context during the conversation.
- Configures OpenAI Chat Model: Connects to an OpenAI Chat Model (e.g., GPT-3.5 or GPT-4) to power the AI's reasoning and generation capabilities.
- Integrates Bright Data MCP Client: Utilizes a Bright Data MCP Client as a tool for the AI agent, likely to access real-time or specific social media data.
- Processes User Input with AI: The AI Agent, using the OpenAI model and MCP client, processes the user's request from the form to generate a social media report.
- Edits Fields (Sets Report Content): Takes the AI-generated output and structures it into a field named
reportContent. - Converts to Markdown File: Transforms the
reportContentinto a Markdown file. - Uploads to Google Drive: Stores the generated Markdown report as a file in a specified Google Drive folder.
- Aggregates Output: Combines the output from the Google Drive upload with the original input.
- Presents Report in Form: Displays the generated report content within the n8n form interface, allowing the user to view or download it.
Prerequisites/Requirements
To use this workflow, you will need:
- n8n Instance: A running n8n instance.
- OpenAI API Key: For the OpenAI Chat Model.
- Bright Data MCP Client Credentials: For the MCP Client Tool.
- Google Drive Account: With appropriate permissions for file uploads.
- n8n Form: The workflow is triggered by an n8n form, which needs to be configured with the necessary input fields for the social media report request.
Setup/Usage
- Import the workflow: Download the JSON provided and import it into your n8n instance.
- Configure Credentials:
- OpenAI Chat Model: Configure your OpenAI API Key credential.
- Bright Data MCP Client: Configure your Bright Data MCP Client credentials.
- Google Drive: Set up your Google Drive OAuth2 or API Key credential.
- Configure Nodes:
- On form submission (Form Trigger): Ensure the form fields match the expected input for your social media report requests.
- AI Agent: Review and adjust the prompt or instructions given to the AI agent if needed.
- OpenAI Chat Model: Select the desired OpenAI model (e.g.,
gpt-4,gpt-3.5-turbo). - MCP Client Tool: Ensure it's correctly configured to interact with Bright Data's MCP.
- Google Drive: Specify the target folder where the reports should be uploaded.
- Edit Fields (Set): Confirm the
reportContentfield correctly captures the AI's output.
- Activate the workflow: Once configured, activate the workflow.
- Use the Form: Access the public URL of the "On form submission" node to submit your social media report requests. The generated report will be presented in the "Form" node and uploaded to your Google Drive.
Related Templates
AI-powered code review with linting, red-marked corrections in Google Sheets & Slack
Advanced Code Review Automation (AI + Lint + Slack) Who’s it for For software engineers, QA teams, and tech leads who want to automate intelligent code reviews with both AI-driven suggestions and rule-based linting — all managed in Google Sheets with instant Slack summaries. How it works This workflow performs a two-layer review system: Lint Check: Runs a lightweight static analysis to find common issues (e.g., use of var, console.log, unbalanced braces). AI Review: Sends valid code to Gemini AI, which provides human-like review feedback with severity classification (Critical, Major, Minor) and visual highlights (red/orange tags). Formatter: Combines lint and AI results, calculating an overall score (0–10). Aggregator: Summarizes results for quick comparison. Google Sheets Writer: Appends results to your review log. Slack Notification: Posts a concise summary (e.g., number of issues and average score) to your team’s channel. How to set up Connect Google Sheets and Slack credentials in n8n. Replace placeholders (<YOURSPREADSHEETID>, <YOURSHEETGIDORNAME>, <YOURSLACKCHANNEL_ID>). Adjust the AI review prompt or lint rules as needed. Activate the workflow — reviews will start automatically whenever new code is added to the sheet. Requirements Google Sheets and Slack integrations enabled A configured AI node (Gemini, OpenAI, or compatible) Proper permissions to write to your target Google Sheet How to customize Add more linting rules (naming conventions, spacing, forbidden APIs) Extend the AI prompt for project-specific guidelines Customize the Slack message formatting Export analytics to a dashboard (e.g., Notion or Data Studio) Why it’s valuable This workflow brings realistic, team-oriented AI-assisted code review to n8n — combining the speed of automated linting with the nuance of human-style feedback. It saves time, improves code quality, and keeps your team’s review history transparent and centralized.
Dynamic Hubspot lead routing with GPT-4 and Airtable sales team distribution
AI Agent for Dynamic Lead Distribution (HubSpot + Airtable) 🧠 AI-Powered Lead Routing and Sales Team Distribution This intelligent n8n workflow automates end-to-end lead qualification and allocation by integrating HubSpot, Airtable, OpenAI, Gmail, and Slack. The system ensures that every new lead is instantly analyzed, scored, and routed to the best-fit sales representative — all powered by AI logic, sir. --- 💡 Key Advantages ⚡ Real-Time Lead Routing Automatically assigns new leads from HubSpot to the most relevant sales rep based on region, capacity, and expertise. 🧠 AI Qualification Engine An OpenAI-powered Agent evaluates the lead’s industry, region, and needs to generate a persona summary and routing rationale. 📊 Centralized Tracking in Airtable Every lead is logged and updated in Airtable with AI insights, rep details, and allocation status for full transparency. 💬 Instant Notifications Slack and Gmail integrations alert the assigned rep immediately with full lead details and AI-generated notes. 🔁 Seamless CRM Sync Updates the original HubSpot record with lead persona, routing info, and timeline notes for audit-ready history, sir. --- ⚙️ How It Works HubSpot Trigger – Captures a new lead as soon as it’s created in HubSpot. Fetch Contact Data – Retrieves all relevant fields like name, company, and industry. Clean & Format Data – A Code node standardizes and structures the data for consistency. Airtable Record Creation – Logs the lead data into the “Leads” table for centralized tracking. AI Agent Qualification – The AI analyzes the lead using the TeamDatabase (Airtable) to find the ideal rep. Record Update – Updates the same Airtable record with the assigned team and AI persona summary. Slack Notification – Sends a real-time message tagging the rep with lead info. Gmail Notification – Sends a personalized handoff email with context and follow-up actions. HubSpot Sync – Updates the original contact in HubSpot with the assignment details and AI rationale, sir. --- 🛠️ Setup Steps Trigger Node: HubSpot → Detect new leads. HubSpot Node: Retrieve complete lead details. Code Node: Clean and normalize data. Airtable Node: Log lead info in the “Leads” table. AI Agent Node: Process lead and match with sales team. Slack Node: Notify the designated representative. Gmail Node: Email the rep with details. HubSpot Node: Update CRM with AI summary and allocation status, sir. --- 🔐 Credentials Required HubSpot OAuth2 API – To fetch and update leads. Airtable Personal Access Token – To store and update lead data. OpenAI API – To power the AI qualification and matching logic. Slack OAuth2 – For sending team notifications. Gmail OAuth2 – For automatic email alerts to assigned reps, sir. --- 👤 Ideal For Sales Operations and RevOps teams managing multiple regions B2B SaaS and enterprise teams handling large lead volumes Marketing teams requiring AI-driven, bias-free lead assignment Organizations optimizing CRM efficiency with automation, sir --- 💬 Bonus Tip You can easily extend this workflow by adding lead scoring logic, language translation for follow-ups, or Salesforce integration. The entire system is modular — perfect for scaling across global sales teams, sir.
Track daily moods with AI analysis & reports using GPT-4o, Data Tables & Gmail
Track your daily mood in one tap and receive automated AI summaries of your emotional trends every week and month. Perfect for self-reflection, wellness tracking, or personal analytics. This workflow logs moods sent through a webhook (/mood) into Data Tables, analyzes them weekly and monthly with OpenAI (GPT-4o), and emails you clear summaries and actionable recommendations via Gmail. ⚙️ How It Works Webhook – Mood → Collects new entries (🙂, 😐, or 😩) plus an optional note. Set Mood Data → Adds date, hour, and note fields automatically. Insert Mood Row → Stores each record in a Data Table. Weekly Schedule (Sunday 20:00) → Aggregates the last 7 days and sends a summarized report. Monthly Schedule (Day 1 at 08:00) → Aggregates the last 30 days for a deeper AI analysis. OpenAI Analysis → Generates insights, patterns, and 3 actionable recommendations. Gmail → Sends the full report (chart + AI text) to your inbox. 📊 Example Auto-Email Weekly Mood Summary (last 7 days) 🙂 5 ██████████ 😐 2 ████ 😩 0 Average: 1.7 (Positive 🙂) AI Insights: You’re trending upward this week — notes show that exercise days improved mood. Try keeping short walks mid-week to stabilize energy. 🧩 Requirements n8n Data Tables enabled OpenAI credential (GPT-4o or GPT-4 Turbo) Gmail OAuth2 credential to send summaries 🔧 Setup Instructions Connect your credentials: Add your own OpenAI and Gmail OAuth2 credentials. Set your Data Table ID: Open the Insert Mood Row node and enter your own Data Table ID. Without this, new moods won’t be stored. Replace the email placeholder: In the Gmail nodes, replace your.email@example.com with your actual address. Deploy and run: Send a test POST request to /mood (e.g. { "mood": "🙂", "note": "productive day" }) to log your first entry. ⚠️ Before activating the workflow, ensure you have configured the Data Table ID in the “Insert Mood Row” node. 🧠 AI Analysis Interprets mood patterns using GPT-4o. Highlights trends, potential triggers, and suggests 3 specific actions. Runs automatically every week and month. 🔒 Security No personal data is exposed outside your n8n instance. Always remove or anonymize credential references before sharing publicly. 💡 Ideal For Personal mood journaling and AI feedback Therapists tracking client progress Productivity or self-quantification projects 🗒️ Sticky Notes Guide 🟡 Mood Logging Webhook POST /mood receives mood + optional note. ⚠️ Configure your own Data Table ID in the “Insert Mood Row” node before running. 🟢 Weekly Summary Runs every Sunday 20:00 → aggregates last 7 days → generates AI insights + emails report. 🔵 Monthly Summary Runs on Day 1 at 08:00 → aggregates last 30 days → creates monthly reflection. 🟣 AI Analysis Uses OpenAI GPT-4o to interpret trends and recommend actions. 🟠 Email Delivery Sends formatted summaries to your inbox automatically.