Automate Weekly Fireflies Reports to Gmail & Google Sheets

Transform Your Meeting Management with Automated Weekly Reports

Stop manually tracking meeting hours and let this n8n workflow automatically generate comprehensive weekly reports from your Fireflies data. Every Friday at 5PM, this automation pulls your week's meeting information, calculates seven key metrics, and delivers a formatted report straight to your manager's Gmail inbox while logging summary data to Google Sheets for long-term trend analysis.

What This Workflow Does

• Runs automatically every Friday at 5PM — No manual triggers needed, your end-of-week meeting report arrives consistently
• Calculates seven essential meeting metrics — Computes total meetings, total hours, average duration, busiest day, top participant, longest meeting, and day-by-day breakdown from raw Fireflies data
• Identifies your busiest meeting day — Analyzes meeting distribution across the week and highlights which day had the most meetings with exact counts
• Finds your top meeting participant — Tracks attendance across all meetings and surfaces the most-present person for the week
• Logs weekly summaries to Google Sheets — Appends a 9-column record for each week, enabling week-over-week meeting load comparisons and trend tracking
• Delivers formatted Gmail reports — Sends complete plain-text reports with all metrics, daily breakdowns, and numbered meeting lists

Perfect Use Cases

• Team leads reporting meeting overhead to management
• Operations managers tracking team meeting efficiency
• Founders monitoring organizational meeting load without manual Fireflies checking
• Remote teams maintaining visibility into collaboration patterns

Technical Details

Built using proven n8n nodes including HTTP Request for Fireflies API integration, Code nodes for metric calculations, Gmail for automated email delivery, and Google Sheets for data persistence. Additional nodes include If conditions, Set operations, and Sticky Notes for workflow documentation.

Activate once and gain weekly meeting insights automatically — perfect for busy leaders who need Fireflies data visibility without the manual effort.