Customer Intelligence Briefing Engine with Anthropic, Reddit, X, and SerpAPI - n8n Workflow

• Marketing Strategists needing fast competitive and market intelligence.


• Sales Leaders seeking high-value selling points based on customer pain.


• Product Managers looking for quantified, validated areas for improvement.


• Automation enthusiasts looking for complex, parallel n8n templates involving AI and multiple data sources.

This sophisticated n8n workflow functions as a powerful Customer Intelligence Engine, designed to rapidly analyze market complaints across diverse web sources (Reddit, X/Twitter, and SerpAPI for Google). It solves the critical problem of manually sifting through high-volume, unstructured social media and web commentary to identify genuine, systemic customer pain points.

This n8n automation utilizes a parallel, multi-source ingestion strategy, ensuring high speed. The collected data is cleaned, labeled, and categorized using custom JavaScript logic that assigns specific 'pain points' and sentiment scores—a highly efficient alternative to costly per-item LLM calls. The final output is a highly structured, strategic executive brief, formatted in professional HTML by the Anthropic n8n node (Claude), and delivered directly via Gmail. The data is simultaneously logged to Google Sheets, providing a reliable audit trail. This robust n8n workflow template provides immediate, actionable insights for strategy and sales teams.

The entire process is initiated by an n8n trigger, specifically a user filling out a web form specifying target search queries and data sources. The n8n workflow immediately branches into three parallel ingestion paths to ensure rapid execution:

1. Strategic Context Stream (SerpAPI): The Search Google n8n node queries the web for authoritative commentary and reports.


2. Community Complaint Stream (Reddit): The workflow splits user-provided subreddits into items, which the Search Reddit n8n node then iteratively queries, filtering posts for minimum engagement (score > 5).


3. Real-time Sentiment Stream (X/Twitter): An HTTP Request n8n node fetches real-time social sentiment data based on complex search queries.

All data streams converge into the Merge n8n node. A subsequent Function n8n node applies keyword-based categorization logic to identify specific pain points and score sentiment, efficiently preparing the data for aggregation. The Deduplicate, Count, and Format n8n node then aggregates the results, calculating frequencies and generating a crucial master summary string containing all metrics and examples.

In the final stage, the n8n workflow splits again: the aggregated statistical data is logged to Google Sheets for permanent record, while the summary string is passed to the Anthropic n8n node (Executive Email). Using a highly restrictive system prompt, the AI transforms the raw metrics into a professional, HTML-formatted executive brief, which is then delivered to the recipient's inbox using the Gmail n8n node. This end-to-end n8n workflow structure guarantees speed, accuracy, and professional delivery.

To install this robust n8n workflow template, follow these steps:

1. Import: Copy the provided JSON code and import it directly into your n8n instance.


2. Credentials Setup: This n8n workflow requires credentials for five services:

1. Activate: Ensure the workflow is set to 'Active'. Since the n8n trigger is a 'Form' node, you can access the URL provided by the form node to start the execution.

• Form (n8n Trigger): The starting n8n trigger. Collects user input including email, location, and the specific search queries for Google, X, and Reddit (two subreddits).


• SerpApi (Search Google): Executes the main web search query to find authoritative articles on customer problems.


• Reddit (Search Reddit): Fetches posts from the specified subreddits. It runs iteratively thanks to the upstream List Creator n8n node.


• HTTP Request (Search X): Fetches Twitter (X) data using an external API to overcome rate limiting and execute advanced Boolean queries configured in the n8n node settings.


• Merge: Combines the three parallel data streams into a single list ready for processing.


• Code (Categorization & Sentiment): A custom JavaScript n8n node that applies keyword-based logic to assign a specific painpoint (e.g., 'Call Hold/Availability') and a numerical sentimentscore to each item.


• Code (Deduplicate, Count, and Format): The primary data processing n8n node. It dedupes complaints, calculates aggregate statistics (counts, average sentiment), and generates a comprehensive summaryString for the LLM.


• Google Sheets (Log Search Details): Logs the aggregated pain point counts and average sentiment metrics, maintaining an audit trail of the n8n workflow execution.


• Anthropic (Executive Email): The core intelligence generator. This n8n node uses a detailed system prompt to analyze the summary string and output a professional, structured HTML executive brief using the Claude Haiku model.


• Gmail (Send Email): The final dispatcher n8n node. Retrieves the HTML content from the Anthropic n8n node and sends it to the email address provided in the initial n8n trigger form.