Log Fireflies meeting transcripts to Google Sheets CRM

Description

Quick Overview
This workflow receives a Fireflies webhook when a meeting is processed, fetches the full transcript from Fireflies, matches the external attendee to a lead in Google Sheets, and appends the transcript to a Conversation Logs tab linked to that lead.

How it works
Receives a POST webhook from Fireflies containing the processed meeting ID.
Fetches the meeting transcript, speakers, and meeting date from Fireflies using the meeting ID.
Identifies the likely client speaker (not matching your internal team markers) and formats the transcript as “Speaker: line” text.
Searches the Google Sheets “Lead Database” tab for a lead whose Name matches the detected client name.
If a matching Lead ID is found, appends a new row to the Google Sheets “Conversation Logs” tab with the Lead ID, date, and full transcript.
If no matching lead is found, stops without writing anything to Google Sheets.

Setup
Install the Fireflies community node (@firefliesai/n8n-nodes-fireflies) and add your Fireflies API key credential.
Add a Google Sheets OAuth2 credential, set the spreadsheet ID, and ensure you have “Lead Database” (with Name and Lead ID columns) and “Conversation Logs” (with Lead ID, Date, and Details columns) tabs.
Update the internal team marker keywords in the code step so the workflow correctly distinguishes your team members from the client.
Copy the workflow’s Production webhook URL and configure it as a webhook destination in Fireflies so processed meetings are sent to n8n.