Monitor client meeting health with Fireflies, GPT-4o-mini, Google Sheets and Slack alerts
Description Activate this workflow once and every Monday morning it automatically scans all your client meetings from the past week. It pulls Fireflies sentiment scores per meeting, then sends each transcript to GPT-4...
Template notes
Description
Activate this workflow once and every Monday morning it automatically scans all your client meetings from the past week. It pulls Fireflies sentiment scores per meeting, then sends each transcript to GPT-4o-mini which explains why the sentiment was positive or negative, scores the churn risk, extracts a key quote, and recommends one concrete action. Every meeting is logged to Google Sheets and any negative or high-risk meeting triggers an immediate Slack alert to your dedicated urgent channel. Built for account managers, customer success teams, and agency leads who need early warning on at-risk clients before small problems become lost accounts.
---
What This Workflow Does
- Pulls last 7 days of client meetings automatically — Fetches up to 50 recent Fireflies transcripts and filters to only those recorded this week - Extracts Fireflies NLP sentiment scores — Uses the built-in positive, neutral, and negative percentages already computed by Fireflies per meeting - Computes a composite sentiment score — Converts raw percentages into a single 0–100 score and assigns a label: Positive, Mostly Positive, Neutral, Mostly Negative, or Negative - Adds AI context with GPT-4o-mini — Explains WHY sentiment was what it was, scores churn risk from Low to Critical, and identifies the most important quote from the meeting - Logs every meeting to Google Sheets — Appends a 15-column row per meeting with emoji labels, scores, analysis, and a direct Fireflies link - Fires instant Slack alerts for at-risk meetings — Any meeting with Negative sentiment or High/Critical churn risk triggers an immediate alert to your urgent-alerts channel - Exits cleanly with no meetings — If no meetings were recorded this week, the workflow stops silently without errors
---
Setup Requirements
Tools Needed - n8n instance (self-hosted or cloud) - Fireflies.ai account with API access - OpenAI account with GPT-4o-mini API access - Google Sheets (one sheet with a tab named Client Sentiment Log) - Slack workspace with OAuth2 app configured and two channels ready