Automated Daily Pipedrive Sales Funnel Summary Generator - n8n Workflow

Sales Managers seeking quick, summarized insights into funnel health.
Business Operations Specialists implementing AI automation.
Users looking for advanced n8n templates integrating CRM data with large language models.
Technical users wanting to learn how to connect multiple Pipedrive API calls within a single n8n workflow.

Keeping track of numerous active deals in a CRM like Pipedrive can be time-consuming. This n8n workflow solves this by streamlining data aggregation and analysis using artificial intelligence. It automatically pulls all necessary deal records and their corresponding notes, cleans up technical IDs into human-readable stage names, and then feeds this comprehensive dataset into an OpenAI agent. The final output is a concise, actionable daily summary generated by the gpt-4o-mini model, saving managers hours of manual data review. This powerful n8n workflow is a perfect example of modern AI automation.

The n8n workflow operates in a structured, multi-step process:

1. Initiation: The n8n trigger starts the process. In this n8n template, it is a Manual Trigger, but it can easily be changed to a Schedule n8n trigger for daily automated execution.


2. Deal Retrieval: The first Pipedrive n8n node fetches a list of all active deals from the CRM.


3. Data Standardization: A Code n8n node executes custom JavaScript to translate numerical stageid values (e.g., 1, 2, 3) into descriptive text stagename values (e.g., Prospecting, Qualified).


4. Note Retrieval: A subsequent Pipedrive n8n node fetches all associated notes for each deal retrieved in Step 2.


5. Data Linking: The Summarize n8n node groups these individual notes based on their deal_id, concatenating all note content for a single, comprehensive view of communication and progress per deal.


6. Preparation for AI: Multiple Set and Aggregate n8n node steps restructure the data, combining the custom stage names, deal titles, and concatenated notes into a single item, ensuring the data is properly formatted as a single text input string.


7. AI Summary Generation: The Langchain Agent n8n node is executed. It uses the gpt-4o-mini model (linked via the OpenAI Chat Model n8n node) and a specific system prompt to analyze the comprehensive deal data string and generate the final, daily sales funnel summary. This n8n process ensures the AI receives all relevant context.

To deploy this powerful n8n workflow template, follow these steps:

1. Import the n8n workflow: Copy the provided JSON code and import it into your n8n instance via the 'New' button, selecting 'Import from JSON'.


2. Set Up Pipedrive Credentials:

1. Execution: Once credentials are set up, run the n8n workflow using the 'Execute workflow' button on the Manual n8n trigger, or replace the n8n trigger with a Schedule node for automatic execution.

This n8n workflow relies on several specialized n8n node types to manage data flow and AI integration:

When clicking ‘Execute workflow’ (Manual Trigger n8n trigger):
Function: Starts the n8n workflow. Ideal for testing or manual execution. Should be replaced by a Schedule n8n trigger for production.
Key Configuration: None (Standard manual n8n trigger).

Get many deals (Pipedrive n8n node):
Function: Fetches all available deals from the connected Pipedrive account.
Key Configuration: Operation set to getAll, Return All enabled.

Code (Code n8n node):
Function: Transforms raw Pipedrive stageid numbers into descriptive stagename strings (e.g., '1' becomes 'Prospecting').
Key Configuration: Contains a JavaScript object map defining the stage ID translations.

Get many notes (Pipedrive n8n node):
Function: Retrieves all notes associated with the deals fetched previously, linked via expression dealid.
Key Configuration: Resource set to note, Operation set to getAll, using expression ={{ $json.id }} for filtering by deal ID.

Combine Notes (Summarize n8n node):
Function: Aggregates related notes together, grouping them by dealid and concatenating the note content into a single field.

Summarize Pipedrive (Langchain Agent n8n node):
Function: Acts as the processing layer. It sends the aggregated deal data string to the linked OpenAI model for analysis and summary creation.
Key Configuration: System Message provides context: "You are a helpful assistant. Do a daily summary of the deals in our pipedrive funnel."

OpenAI Chat Model3 (OpenAI Language Model n8n node):
Function: Provides the computational power for the Langchain Agent.
Key Configuration: Model selection is gpt-4o-mini, optimizing for cost-effective speed and quality.