Log Fireflies meeting transcripts to Google Sheets CRM

Workflow preview

100%

Open on n8n.io

$20/month : Unlimited workflows

2500 executions/month

Try free

THE #1 IN WEB SCRAPING

Scrape any website without limits

Try free

HOSTINGER

Early Deal
DISCOUNT 20%

Self-hosted n8n

Unlimited workflows - from $4.99/mo

Try free

#1 hub for scraping, AI & automation

6000+ actors - $5 credits/mo

Try free

1. Workflow Overview

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 appe...

Best for

Automation automation workflows
intermediate n8n builders looking for reusable templates

Tools used

n8n-nodes-base.stickynote, n8n-nodes-base.webhook, @firefliesai/n8n-nodes-fireflies.fireflies, n8n-nodes-base.code, n8n-nodes-base.googlesheets, n8n-nodes-base.if, n8n-nodes-base.noop

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by isaWOW.

Original n8n.io source

1.1 Workflow description

Title: Log Fireflies meeting transcripts to Google Sheets CRM
Workflow name: Log Fireflies meeting transcripts to Google Sheets CRM

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.

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Overview

Type / Role: n8n-nodes-base.stickyNote - stickyNote
Config choices: Version 1

Block 2 - Section — Receive Notification and Get Transcript

Type / Role: n8n-nodes-base.stickyNote - stickyNote
Config choices: Version 1

Block 3 - Section — Detect Client and Find Lead

Type / Role: n8n-nodes-base.stickyNote - stickyNote
Config choices: Version 1

Block 4 - Section — Check Match and Log Conversation

Type / Role: n8n-nodes-base.stickyNote - stickyNote
Config choices: Version 1

Block 5 - 1. Webhook — Receive Fireflies Notification

Type / Role: n8n-nodes-base.webhook - webhook
Config choices: Version 2.1

Block 6 - 2. Fireflies — Get Transcript

Type / Role: @firefliesai/n8n-nodes-fireflies.fireflies - fireflies
Config choices: Version 1

Block 7 - 3. Code — Clean Transcript Data

Type / Role: n8n-nodes-base.code - code
Config choices: Version 2

Block 8 - 4. Google Sheets — Find Lead

Type / Role: n8n-nodes-base.googleSheets - googleSheets
Config choices: Version 4.7

Block 9 - 5. IF — Lead Found?

Type / Role: n8n-nodes-base.if - if
Config choices: Version 2

Block 10 - 6. Google Sheets — Log to Conversation Logs

Type / Role: n8n-nodes-base.googleSheets - googleSheets
Config choices: Version 4.7

Block 11 - No Operation — Client Not in Database

Type / Role: n8n-nodes-base.noOp - noOp
Config choices: Version 1

3. Summary Table

Workflow	Log Fireflies meeting transcripts to Google Sheets CRM
Complexity	intermediate
Nodes	11
Categories	Automation
Author	isaWOW
Published	16 Jun 2026

4. Reproducing the Workflow from Scratch

1. Download the workflow JSON

Use the JSON export at /data/workflows/16410/16410.json as the source template for this automation.
2. Import the template into n8n

Open n8n, import the downloaded JSON, and review each node before activating the workflow.
3. Configure credentials and variables

Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.
4. Test with sample data

Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.
5. Activate and monitor

Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Download workflow JSON Original n8n.io source Automation workflows

Frequently asked questions

What does Log Fireflies meeting transcripts to Google Sheets CRM do?

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Automation use case.

isaWOW

53 workflows

Nodes

n8n-nodes-base.stickynote n8n-nodes-base.webhook @firefliesai/n8n-nodes-fireflies.fireflies n8n-nodes-base.code n8n-nodes-base.googlesheets n8n-nodes-base.if n8n-nodes-base.noop

Complexity

intermediate

Published 16 Jun 2026

Likes 0

View on n8n.io Download Workflow

Install path: /data/workflows/16410/16410.json

Share Your Workflow

Have a useful automation to share? Publish it and help the community.

Submit Your Template How to Submit

Related Workflows

Generate and publish AI home cam Shorts with OpenAI, kie.ai and YouTube

## Quick overview This workflow runs three times daily to generate an AI “home cam” short video concept with OpenAI, create the video via kie.ai, then download and archive it to Google Drive, upload it to YouTube as a public video, and send a confirmation email via Gmail. ## How it works 1. Runs on a schedule three times a day (08:00, 12:00, and 18:00). 2. Selects a random scenario number from the configured range and asks OpenAI (GPT-4.1-mini) to generate a title, description, tags, and a detailed text-to-video prompt as structured JSON. 3. Builds a kie.ai Sora-2 text-to-video job request using the generated prompt and submits it to the kie.ai API. 4. Waits and repeatedly polls kie.ai until the job succeeds and returns a result payload containing a video download URL. 5. Downloads the generated video file from the returned URL. 6. Uploads the video to a specified Google Drive folder, publishes it to YouTube with the AI-generated metadata, and emails you a notification containing the prompt and video link. ## Setup 1. Add an OpenAI API credential, a kie.ai API key using HTTP Header Auth, and OAuth credentials for Google Drive, YouTube, and Gmail. 2. In the workflow variables, set your notification email address, the target Google Drive folder ID, and the callback URL value used in the kie.ai request. 3. Review or adjust the random scenario range (videoIdeaMin/videoIdeaMax) and YouTube upload settings (for example, privacyStatus and notifySubscribers) before activating the workflow. ## Requirements - OpenAI API credential - kie.ai API key - OAuth credentials for Google Drive, YouTube, and Gmail

View

Score company ad spend from Meta, Google and LinkedIn Ads with Google Sheets

## Quick Overview This workflow pulls Pending companies from Google Sheets, checks their ad activity via Adyntel for Meta (Facebook), Google Ads, and LinkedIn Ads, calculates a budget signal score from ad volume and channel diversity, and writes the results back to the same sheet. ## How it works 1. Runs when you manually execute the workflow in n8n. 2. Reads rows from Google Sheets where the Status column is set to Pending. 3. Processes each company domain in sequence and queries Adyntel for Meta (Facebook) ads, Google Ads, and LinkedIn Ads. 4. Combines the three ad search results into a single dataset for the current company. 5. Calculates per-platform ad counts, total ads, active platforms, channel diversity, and a composite budget_signal_score. 6. Updates the matching row in Google Sheets (by domain), writes the scoring fields, and sets Status to Done before moving to the next company. ## Setup 1. Connect Google Sheets OAuth credentials and set the target spreadsheet and sheet where your company list lives. 2. Add Adyntel API credentials so the workflow can query Meta (Facebook), Google Ads, and LinkedIn Ads by company domain. 3. Ensure your Google Sheet includes at least company_name, domain, and Status columns, with Status set to Pending for rows you want to process.

View

Prioritize exception queues with Gemini, Google Sheets, Slack and Gmail

## Quick Overview This workflow receives a webhook trigger, reads exception records from Google Sheets, uses Google Gemini (Generative Language API) to rank and summarize them, posts a prioritized report to Slack, writes summary metrics back to Google Sheets, and emails a critical alert via Gmail when needed. ## How it works 1. Receives a webhook request to start an exception-queue analysis run. 2. Reads the current exception list from a Google Sheets worksheet and stops with a “No open exceptions found” webhook response if there are no rows. 3. Formats the sheet rows into a structured text list and sends it to the Google Gemini API to generate a ranked, scored priority list plus summary counts. 4. Parses the Gemini response and builds Slack Block Kit content, an HTML email body for critical items, and fields for saving analysis metadata. 5. Appends or updates a summary row in a second Google Sheets worksheet with the AI summary and severity counts. 6. Posts the ranked exception report to a Slack channel. 7. If any critical exceptions are detected, sends an alert email via Gmail, then returns a JSON “Done” response to the original webhook caller with processing statistics. ## Setup 1. Add credentials for Google Sheets OAuth2, Slack OAuth2, and Gmail OAuth2 in n8n. 2. Provide a Google Gemini API key and update the HTTP request to use it (preferably via an n8n credential or environment variable rather than hard-coding). 3. Update the Google Sheets document ID and ensure Sheet1 contains columns like ExceptionID, Title, Severity, System, and ReportedAt, and Sheet2 has columns for summary and count fields used by the workflow. 4. Select the target Slack channel in the Slack node and confirm it matches where you want the priority report posted. 5. Configure the Gmail node with the recipient(s) and ensure your webhook URL (path: /exception-trigger) is used by the system that should trigger the analysis.

View

Need Custom Automation?

Get help designing a custom n8n workflow that connects your stack and fits your process.

Log Fireflies meeting transcripts to Google Sheets CRM

Workflow preview

1. Workflow Overview

Best for

Tools used

Source and attribution

1.1 Workflow description

Quick Overview

How it works

Setup

1.2 Logical Blocks

2. Block-by-Block Analysis

Block 1 - Overview

Block 2 - Section — Receive Notification and Get Transcript

Block 3 - Section — Detect Client and Find Lead

Block 4 - Section — Check Match and Log Conversation

Block 5 - 1. Webhook — Receive Fireflies Notification

Block 6 - 2. Fireflies — Get Transcript

Block 7 - 3. Code — Clean Transcript Data

Block 8 - 4. Google Sheets — Find Lead

Block 9 - 5. IF — Lead Found?

Block 10 - 6. Google Sheets — Log to Conversation Logs

Block 11 - No Operation — Client Not in Database

3. Summary Table

4. Reproducing the Workflow from Scratch

1. Download the workflow JSON

2. Import the template into n8n

3. Configure credentials and variables

4. Test with sample data

5. Activate and monitor

5. General Notes & Resources

Frequently asked questions