Send weekly Fireflies meeting reports to Gmail and log metrics in Google Sheets

Description

Activate this workflow once and every Friday at 5PM it automatically pulls your week's meeting data from Fireflies, calculates seven metrics, and emails a formatted report to your manager inbox. It tracks total meetings, total hours, average duration, busiest day, top participant, and longest meeting — plus a day-by-day breakdown and a numbered list of every meeting. Every week's summary is also logged to Google Sheets so you can track meeting load trends over time. Built for team leads, operations managers, and founders who want visibility into meeting time without manually checking Fireflies each week.

---

What This Workflow Does

- Runs automatically every Friday — Fires at 5PM every week so your end-of-week report arrives without any manual trigger - Calculates seven meeting metrics — Computes total meetings, total hours, average duration, busiest day, top participant, longest meeting, and a day-by-day breakdown from raw Fireflies data - Identifies the busiest day — Counts meetings per day of the week and surfaces which day had the most meetings and exactly how many - Finds the top participant — Counts how many meetings each person attended and surfaces the most-present person across the week - Logs one summary row to Google Sheets — Appends a 9-column weekly record for trend tracking so you can compare meeting load week over week - Emails a formatted plain-text report — Sends the full report with all metrics, daily breakdown, and numbered meeting list to your manager email automatically - Exits cleanly with no meetings — If no meetings were recorded this week, the workflow stops silently without sending an empty email

---

Setup Requirements

Tools Needed - n8n instance (self-hosted or cloud) - Fireflies.ai account with API access - Google Sheets (one sheet with a tab named Weekly Meeting Report) - Gmail account (used to send the weekly report)