Automated Prospect Research and Sales Prep - n8n Workflow

Founders taking high-stakes sales calls and wanting instant preparation.
Agencies and consultants who need to personalize discovery calls using rapid data insights.
SDRs/BDRs managing high-volume B2B outreach where context is critical.
Technical teams looking for advanced n8n templates for AI-driven sales enablement.

The challenge in high-touch sales and consulting is ensuring that team members are fully prepared for every call without sacrificing hours to manual research. This expert n8n workflow solves this critical problem by fully automating the preparation process. When a prospect books a meeting via a scheduling tool, the system initiates a parallel deep research phase: scraping their LinkedIn profile for history and recent posts, and utilizing the powerful Perplexity n8n node for deep-dive company analysis and current events.

The resulting structured data is then fed into two dedicated LLM analysis steps using the OpenAI n8n node. These steps perform high-level strategic analysis, including generating a personalized profile summary, predicting potential pain points, and identifying five high-ROI automation solutions tailored to the prospect's company. This entire automated n8n workflow culminates in a detailed, personalized HTML report emailed directly to the consultant, ensuring they are perfectly positioned for a high-impact discovery call. This automated process is one of the most powerful n8n templates available for sales intelligence.

This n8n workflow executes a sophisticated chain of data gathering, processing, and AI summarization:

1. Trigger Event: The n8n trigger starts when a new call is booked, specifically using the Cal.com Trigger node (though it can be replaced by any booking tool trigger).


2. Lead Lookup: The prospect's email from the booking event is used to search across multiple Google Sheets (acting as a lead database) to find the corresponding LinkedIn URL and other contact data.


3. Data Extraction: The workflow uses an external HTTP Request (configured for Relevance AI) to scrape the public LinkedIn profile for details like history, education, company info, and recent posts.


4. Deep Web Research: Simultaneously, the Perplexity n8n node runs a powerful search query on the prospect's company and website URL to gather real-time context, news, and business descriptions.


5. Data Transformation: Multiple n8n Code nodes (Posts, Experiences, Education, Citations) clean and format the raw JSON data extracted from LinkedIn and Perplexity, converting it into reusable HTML snippets (like formatted tables and lists).


6. AI Analysis (Profile): The first OpenAI n8n node (Person + Company Profile) analyzes the scraped data to generate customized text sections: Personal Profile, Interests, Company Profile, and Unique Facts—all formatted in clean HTML.


7. AI Analysis (Strategy): The second OpenAI n8n node (Pain Points + Solutions) uses the profiles and research to generate strategic insights, including a table of predicted pain points, evidence, and corresponding solutions from the consulting agency, along with the 5 highest ROI opportunities.


8. Report Compilation: The Create HTML Report n8n node uses all the formatted snippets and AI-generated content to build a single, comprehensive, and highly styled HTML document.


9. Delivery: Finally, the Email Report Gmail n8n node sends the complete HTML report to the consultant's inbox, ready for immediate review before the meeting.

To deploy this comprehensive n8n workflow, follow these steps:

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


2. Cal.com/Trigger Setup: Configure the Cal.com Trigger n8n node (or replace it with your preferred booking platform's n8n trigger node, such as Calendly or SavvyCal) and set it to fire on 'Booking Created'.


3. Google Sheets Credentials: Update the four Google Sheets n8n nodes with your specific spreadsheet IDs and sheet names where your lead data (including LinkedIn URLs linked to emails) is stored. Ensure you have the necessary Google Sheets OAuth2 credential connected.


4. Relevance AI/Scraping Credential: Set up the credentials for the Scrape Profiles + Posts - Relevance AI HTTP Request node. This typically requires an API key for the scraping service to access LinkedIn data.


5. Perplexity AI Credential: Add your API key to the Perplexity n8n node credential. This is essential for the deep web research step.


6. OpenAI Credential: Ensure both LLM nodes (Person + Company Profile and Pain Points + Solutions) are linked to a valid OpenAI API credential. If necessary, review and customize the complex LLM prompts within these n8n node parameters to align with your agency's tone and service offerings.


7. Gmail Credential: Configure the Email Report Gmail n8n node with your sending email address and the target recipient (the consultant) to finalize the delivery of the report.

Cal.com Trigger: The initial n8n trigger that starts the flow upon a new appointment booking. It captures key details like the prospect's email and profile URL (if provided).
Google Sheets (x4): These n8n nodes act as a database lookup, querying multiple lead lists to find the LinkedIn profile URL associated with the booking email.
Scrape Profiles + Posts - Relevance AI (HTTP Request): This critical n8n node calls an external service to perform the actual LinkedIn scraping, extracting the prospect's 'About' section, job history, education, and last 30 days of posts.
Perplexity: An AI web research n8n node that performs a detailed, cited search query about the prospect's company using their company name and website, providing deep contextual information.
Code Nodes (Posts, Experiences, Education, Citations): These Code n8n nodes are used exclusively for transformation, taking complex JSON arrays and programmatically converting them into clean, structured HTML table rows and list elements required for the final report.
Person + Company Profile (OpenAI/LLM): The first LLM n8n node, responsible for synthesizing scraped data into a cohesive HTML profile summary, identifying personal interests, and extracting unique, rapport-building facts.
Pain Points + Solutions (OpenAI/LLM): The second LLM n8n node, which performs strategic analysis. It uses the input research to generate a structured HTML table of likely pain points, supporting evidence, and proposed high-ROI automation solutions from the agency.
Create HTML Report: A standard HTML n8n node that compiles all the outputs from the Code and LLM nodes into a single, fully styled, production-ready sales prep document.

• Email Report (Gmail): The final n8n node responsible for delivering the finished HTML report to the intended recipient via Gmail.