This workflow fetches deals and their notes from Pipedrive, cleans up stage IDs into names, aggregates the information, and uses OpenAI to generate a daily summary of your funnel. --- ⚙️ Setup Instructions 1️⃣ Set Up OpenAI Connection 1. Go to OpenAI Platform 2. Navigate to OpenAI Billing 3. Add funds to your billing account 4. Copy your API key into the OpenAI credentials in n8n 2️⃣ Connect Pipedrive 1. In Pipedrive → Personal preferences → API → copy your API token - URL shortcut: 2. In

This workflow fetches deals and their notes from Pipedrive, cleans up stage IDs into names, aggregates the information, and uses OpenAI to generate a daily summary of your funnel. --- ⚙️ Setup Instructions 1️⃣ Set Up OpenAI Connection 1. Go to OpenAI Platform 2. Navigate to OpenAI Billing 3. Add funds to your billing account 4. Copy your API key into the OpenAI credentials in n8n 2️⃣ Connect Pipedrive 1. In Pipedrive → Personal preferences → API → copy your API token - URL shortcut: 2. In n8n → Credentials → New → Pipedrive API - Company domain: {your-company} (the subdomain in your Pipedrive URL) - API Token: paste the token from step 1 → Save 3. In the Pipedrive nodes, select your Pipedrive credential and (optionally) set filters (e.g., owner, label, created time). --- 🧠 How It Works - Trigger: Workflow runs on manual execution (can be scheduled). - Get many deals: Pulls all deals from your Pipedrive. - Code node: Maps stageid numbers into friendly stage names (Prospecting, Qualified, Proposal Sent, etc.). - Get many notes: Fetches notes attached to each deal. - Combine Notes: Groups notes by deal, concatenates content, and keeps deal titles. - Set Field Names: Normalizes the fields for summarization. - Aggregate for Agent: Collects data into one object. - Turn Objects to Text: Prepares text data for AI. - OpenAI Chat Model + Summarize Agent: Generates a daily natural-language summary of deals and their current stage. --- 💬 Example Prompts - “Summarize today’s deal activity.” - “Which deals are still in negotiation?” - “What updates were added to closed-won deals this week?” --- 📬 Contact Need help extending this (e.g., send summaries by Slack/Email, or auto-create tasks in Pipedrive)? - 📧 rbreen@ynteractive.com - 🔗 Robert Breen - 🌐 ynteractive.com
Download the workflow JSON file after purchase.
Open n8n → click the menu → Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.