Daily Pipedrive Deal Summaries with GPT-4o-mini

This n8n workflow streamlines sales pipeline monitoring by pulling all deals from Pipedrive, mapping numeric stage IDs to readable names (e.g., Prospecting, Qualified), fetching associated notes, aggregating them per deal, and feeding the structured data into OpenAI's GPT-4o-mini for a natural-language daily summary. It handles data cleaning, concatenation, and formatting automatically, producing concise reports on deal progress, stages, and key notes without manual effort.

Benefits include massive time savings for sales teams—eliminate hours of manual Excel reviews or dashboard digging. Get actionable insights like funnel health, stalled deals, or hot opportunities in plain English, emailed or logged daily. Ideal for managers tracking performance without deep CRM dives.

Use cases: Daily sales huddles, executive briefings, solo entrepreneurs monitoring pipelines, or scaling teams automating reporting. Schedule via cron for hands-free operation; customize filters for owners/labels. Requires Pipedrive API token and OpenAI key—setup takes minutes, ROI immediate through efficiency gains.