Generate daily business briefing podcasts with OpenAI, Azure TTS, HubSpot, Zendesk, Pipedrive, Discord, Twilio and Confluence

Go to Workflow
0 views
Built by Jitesh Dugar Jitesh Dugar
Created on June 12, 2026

Description

Keep your leadership team informed with a data-driven, automated morning briefing. This workflow pulls live metrics from HubSpot, Zendesk, and Pipedrive, then uses AI and Neural TTS to generate a professional audio briefing delivered via Discord, SMS, and Confluence.

🎯 What This Workflow Does

This template acts as an automated newsroom, executing a "Fetch β†’ Analyze β†’ Broadcast" cycle every weekday morning.

⏰ Step 1 β€” Intelligent Triggering

Schedule:** Runs Monday–Friday at 7:30 AM
Weekday Guard:** Skips weekends automatically
Date Context:** Generates standardized timestamps for API calls

πŸ”€ Step 2 β€” Parallel Metric Fetching

HubSpot:** Fetches new leads and deal values
Zendesk:** Retrieves ticket volume and response metrics
Pipedrive:** Pulls pipeline health and deal status
Merge:** Waits for all APIs before proceeding

πŸ€– Step 3 β€” AI Scripting & Trend Analysis

Historical Comparison:** Reads previous data to calculate trends
AI Script Generation:** Uses OpenAI to create a natural, spoken-style briefing

πŸ”Š Step 4 β€” Neural TTS & Hosting

Voice Generation:** Uses Azure Neural TTS for high-quality audio
CDN Hosting:** Uploads MP3 via UploadToURL for public access

πŸ“‘ Step 5 β€” Multi-Channel Broadcast

Discord:** Sends rich message with audio link
Twilio SMS:** Delivers summary + link to leadership
Confluence:** Logs full report with embedded audio

✨ Key Features

Parallel Processing:** Faster execution with simultaneous API calls
Trend Intelligence:** Automatically calculates day-over-day changes
Mobile Friendly:** SMS delivery for on-the-go access
Premium Audio:** Natural-sounding Neural TTS voices

πŸ”§ Setup Requirements

Required Integrations

HubSpot, Zendesk, Pipedrive:** API access
OpenAI:** API key + Assistant ID
Azure Speech:** Subscription key
Twilio:** SMS credentials
Confluence:** API token + space access
UploadToURL:** CDN hosting for audio

Turn your metrics into a daily executive briefing. Import this template and start broadcasting insights automatically.

Nodes Used (2)

Code
n8n-nodes-base.code
HTTP Request
n8n-nodes-base.httpRequest