HumationHuman + Automation
Back to Catalog

Analyze market demand using GPT-4o, XPOZ MCP, Notion and email reports

Rahul JoshiRahul Joshi
190 views
2/3/2026
Data TransferMigrationHTTP RequestAPIBatch Processing
Official Page

📘 Description

This workflow performs automated market demand research for a defined niche on a scheduled basis and converts raw public discussions into actionable business insights. It continuously scans search engines and social platforms to identify real customer pain points, unmet needs, buying or switching intent, and dissatisfaction with existing tools or solutions. An AI market research agent analyzes public conversations to filter out noise and extract only high-signal demand indicators. These insights are then transformed into two outputs: a concise Notion-ready research summary for internal knowledge tracking and a professional, customer-ready email that communicates key findings in clear, business-friendly language. Built-in validation and error handling ensure reliability and traceability. This workflow replaces repetitive manual market research with a consistent, insight-driven intelligence pipeline that supports founders, marketers, and growth teams. ⚠️ Deployment Disclaimer This template is intended for self-hosted n8n instances only. It relies on external MCP-based social intelligence tools and advanced AI agents not supported on n8n Cloud.

⚙️ What This Workflow Does (Step-by-Step)

⏰ Scheduled Market Research Trigger Runs automatically on a defined schedule. 🧾 Inject Niche, Query, and Research Context Sets the niche, keywords, and analyst notes to guide research focus. 🔎 Analyze Public Discussions for Market Demand (AI) Scans public search and social platforms to identify real demand signals, pain points, and buying intent. 📡 Public Search & Social Intelligence (MCP Tool) Fetches relevant public discussions for analysis. 🧠 Convert Market Signals into Structured Insights (AI) Transforms raw findings into a Notion-ready summary and a customer-friendly email. 🧹 Parse & Validate AI Output Ensures structured JSON output for safe downstream use. 📘 Save Market Research Insight to Notion Stores summarized insights for long-term research and tracking. 📧 Send Market Insight Email to Stakeholder Delivers a concise, value-focused email highlighting key findings. 🚨 Workflow Error Handler → Email Alert Sends detailed error notifications if any step fails.

🧩 Prerequisites

• Self-hosted n8n instance • OpenAI API credentials • MCP (Xpoz) public search & social intelligence credentials • Notion API access • Gmail OAuth credentials

💡 Key Benefits

✔ Automates recurring market research ✔ Identifies real demand and buying intent signals ✔ Produces clean Notion documentation automatically ✔ Generates customer-ready insight emails ✔ Eliminates manual scanning of forums and social media ✔ Built-in error alerts for reliability

👥 Perfect For

  • Startup founders validating ideas
  • Growth and marketing teams
  • Product strategy teams
  • Market research and competitive intelligence teams

n8n Workflow: Analyze Market Demand Using GPT-4o, Notion, and Email Reports

This n8n workflow automates the process of analyzing market demand using an AI agent (GPT-4o), storing the results in Notion, and sending email reports. It's designed to run on a schedule and provides error handling for robust operation.

What it does

This workflow streamlines market demand analysis by:

  1. Triggering on a Schedule: The workflow initiates automatically based on a predefined schedule.
  2. Initializing AI Agent: It sets up an AI agent powered by GPT-4o, configured with a Model Context Protocol (MCP) client tool for enhanced capabilities.
  3. Performing Market Demand Analysis: The AI agent executes a prompt to analyze market demand, leveraging its configured tools.
  4. Storing Results in Notion: The analysis output from the AI agent is then saved as a new item in a specified Notion database.
  5. Sending Email Reports: A summary of the analysis or a notification is sent via Gmail to designated recipients.
  6. Error Handling: If any part of the main workflow fails, a dedicated error workflow is triggered to manage and report the failure.

Prerequisites/Requirements

To use this workflow, you will need:

  • n8n Instance: A running n8n instance.
  • OpenAI API Key: For the OpenAI Chat Model to interact with GPT-4o.
  • Notion Integration: A Notion integration setup with access to the target database where market demand analysis results will be stored.
  • Gmail Account: Configured credentials for sending emails via Gmail.
  • Model Context Protocol (MCP) Client: This tool is part of the Langchain integration and might require specific setup or configuration depending on its use case within your n8n environment.

Setup/Usage

  1. Import the Workflow:

    • Download the provided JSON file.
    • In your n8n instance, click "Workflows" in the left sidebar.
    • Click "New Workflow" and then "Import from JSON".
    • Paste the JSON content or upload the file.

  2. Configure Credentials:

    • Locate the OpenAI Chat Model node and configure your OpenAI API Key credential.
    • Locate the Notion node and configure your Notion API Key credential.
    • Locate the Gmail node and configure your Gmail OAuth2 or API Key credential.

  3. Configure Nodes:

    • Schedule Trigger (ID: 839): Adjust the schedule as needed (e.g., daily, weekly, monthly) to define when the market analysis should run.
    • Edit Fields (Set) (ID: 38): This node likely prepares data for the AI agent. Review and modify the fields if specific inputs are required for your market demand analysis prompt.
    • Code (ID: 834): This node might contain custom logic or data manipulation. Review its JavaScript code and adjust if necessary.
    • AI Agent (ID: 1119):
      • Model: Ensure OpenAI Chat Model is selected.
      • Tools: Verify MCP Client Tool is correctly linked and configured.
      • Prompt: Customize the prompt to guide GPT-4o on what kind of market demand analysis you need (e.g., "Analyze current trends in the e-commerce market for sustainable products and identify emerging opportunities.").
    • Notion (ID: 487):
      • Operation: Set to "Create" or "Append" an item.
      • Database ID: Specify the ID of your Notion database where the analysis results will be stored.
      • Properties: Map the output from the AI agent to the relevant properties in your Notion database (e.g., "Title" for the analysis summary, "Date" for the execution date, "Content" for the detailed report).
    • Gmail (ID: 356):
      • To: Enter the email address(es) of the recipients for the market analysis report.
      • Subject: Customize the email subject (e.g., "Daily Market Demand Analysis Report").
      • Body: Design the email body to include relevant information from the AI agent's output.
    • Error Trigger (ID: 12): This node is the trigger for an error workflow. You would typically have a separate workflow that starts with this node to handle errors from this workflow.

  4. Activate the Workflow: Once all configurations are complete, activate the workflow.

Related Templates

Auto-reply & create Linear tickets from Gmail with GPT-5, gotoHuman & human review

This workflow automatically classifies every new email from your linked mailbox, drafts a personalized reply, and creates Linear tickets for bugs or feature requests. It uses a human-in-the-loop with gotoHuman and continuously improves itself by learning from approved examples. How it works The workflow triggers on every new email from your linked mailbox. Self-learning Email Classifier: an AI model categorizes the email into defined categories (e.g., Bug Report, Feature Request, Sales Opportunity, etc.). It fetches previously approved classification examples from gotoHuman to refine decisions. Self-learning Email Writer: the AI drafts a reply to the email. It learns over time by using previously approved replies from gotoHuman, with per-classification context to tailor tone and style (e.g., different style for sales vs. bug reports). Human Review in gotoHuman: review the classification and the drafted reply. Drafts can be edited or retried. Approved values are used to train the self-learning agents. Send approved Reply: the approved response is sent as a reply to the email thread. Create ticket: if the classification is Bug or Feature Request, a ticket is created by another AI agent in Linear. Human Review in gotoHuman: How to set up Most importantly, install the gotoHuman node before importing this template! (Just add the node to a blank canvas before importing) Set up credentials for gotoHuman, OpenAI, your email provider (e.g. Gmail), and Linear. In gotoHuman, select and create the pre-built review template "Support email agent" or import the ID: 6fzuCJlFYJtlu9mGYcVT. Select this template in the gotoHuman node. In the "gotoHuman: Fetch approved examples" http nodes you need to add your formId. It is the ID of the review template that you just created/imported in gotoHuman. Requirements gotoHuman (human supervision, memory for self-learning) OpenAI (classification, drafting) Gmail or your preferred email provider (for email trigger+replies) Linear (ticketing) How to customize Expand or refine the categories used by the classifier. Update the prompt to reflect your own taxonomy. Filter fetched training data from gotoHuman by reviewer so the writer adapts to their personalized tone and preferences. Add more context to the AI email writer (calendar events, FAQs, product docs) to improve reply quality.

gotoHumanBy gotoHuman
353

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.

MANISH KUMARBy MANISH KUMAR
113

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.

Jose CastilloBy Jose Castillo
105