Analyze weekly Fireflies sales calls with GPT-4o-mini, Google Sheets and Slack

Description Connect your Fireflies account once and activate the workflow — every Monday at 9AM it runs automatically without any input from you. It pulls all sales call transcripts from the past 7 days, analyzes each one with GPT-4o-mini, and extracts six intelligence fields: pricing mentions, objections, buying signals, competitor mentions, a key takeaway, and a recommended next action. Every call is logged as one row in Google Sheets and a full weekly digest is posted to your Slack channel. Built for sales managers and revenue teams who want structured call intelligence delivered without manual review. --- What This Workflow Does - Fetches last 7 days of calls automatically — Pulls up to 50 recent transcripts from Fireflies and filters to only those recorded in the past week - Analyzes every call individually — GPT-4o-mini reads each transcript and extracts six structured fields per call, not a generic summary - Detects objections and buying signals — Surfaces exactly what concerns were raised and what positive signals suggest the deal is moving forward - Flags competitor mentions — Identifies any competitor names or alternative products that came up across all calls this week - Logs each call to Google Sheets — Appends one 13-column row per call so your team has a permanent, searchable record of every sales conversation - Delivers a weekly Slack digest — Aggregates all calls into one report covering totals, top objections, top buying signals, and a call-by-call overview - Exits cleanly when no calls exist — If no transcripts are found for the week, the workflow stops silently without errors or empty Slack messages --- 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 Sales Call Analysis) - Slack workspace with OAuth2 app configured Credentials Required - Fireflies API key (pasted directly into 2. Set — Config Values — no n8n credential needed) - OpenAI API key - Google Sheets OAuth2 - Slack OAuth2 Estimated Setup Time: 15–20 minutes --- Step-by-Step Setup 1. Import the workflow — Open n8n → Workflows → Import from JSON → paste the workflow JSON → click Import 2. Get your Fireflies API key — Log in to fireflies.ai → go to Settings → Integrations → copy your API key 3. Fill in Config Values — Open node 2. Set — Config Values → replace all placeholders: | Field | What to enter | |---|---| | YOURFIREFLIESAPIKEY | Your Fireflies API key from step 2 | | YOURGOOGLESHEETID | The ID from your Google Sheet URL (the string between /d/ and /edit) | | Sales Call Analysis | Leave as-is, or change to match your sheet tab name exactly | | sales-team | Your Slack channel name including the | | YOUR COMPANY NAME | Your company name (used in the AI prompt and Slack report) | | salesKeywords | Comma-separated keywords to identify sales calls (default: sales,client,demo,proposal,pricing,onboarding,deal,contract) | 4. Connect OpenAI — Open node 10. OpenAI — GPT-4o-mini Model → click the credential dropdown → add your OpenAI API key → test the connection 5. Create your Google Sheet — Open Google Sheets → create a new sheet → add a tab named exactly Sales Call Analysis → add these 13 column headers in row 1: Call Date, Meeting Title, Duration (min), Participants, Overall Sentiment, Pricing Mentions, Objections, Buying Signals, Competitor Mentions, Key Takeaway, Recommended Action, Transcript URL, Logged At 6. Connect Google Sheets — Open node 13. Google Sheets — Log Call Analysis → click the credential dropdown → add Google Sheets OAuth2 → sign in with your Google account → authorize access 7. Connect Slack — Open node 15. Slack — Send Weekly Report → click the credential dropdown → connect your Slack workspace via OAuth2 → invite the n8n bot to your sales channel in Slack (/invite @n8n) 8. Activate the workflow — Toggle the workflow to Active — it will run automatically every Monday at 9AM > ⚠️ Te