See llms.txt for all machine-readable content.

Back to Templates

Summarize meeting transcripts to Google Sheets, HubSpot, and Gmail with OpenAI

Quick overview

This workflow captures meeting transcripts via webhook, uses OpenAI to extract structured notes and action items, saves the summary to Google Sheets, logs a note to HubSpot CRM, emails follow-ups via Gmail, and sends a weekly Friday digest compiled from the saved meetings.

How it works

  1. Receives a POST webhook containing a meeting transcript (for example from Fireflies, Otter, or a custom form).
  2. Uses OpenAI to extract structured meeting notes including attendees, summary, decisions, action items, next steps, and sentiment.
  3. Appends the extracted meeting details to a Google Sheets tab named “Meetings.”
  4. Creates a new note in HubSpot CRM containing the meeting summary and attendees, continuing even if the HubSpot request fails.
  5. Formats the action items into a bullet list and, if any exist, emails them to the owner via Gmail.
  6. Emails a confirmation summary (summary, decisions, and next steps) to the rep via Gmail.
  7. Every Friday at 4 PM, reads the “Meetings” sheet entries from the last 7 days, uses OpenAI to write a concise weekly digest, and emails it to the owner via Gmail.

Setup

  1. Create OpenAI credentials and select a model (or update the model name in the workflow configuration).
  2. Connect Google Sheets OAuth, create a spreadsheet with a “Meetings” sheet/tab, and set your Google Sheet ID in both configuration steps.
  3. Connect Gmail OAuth and set the owner and rep email addresses used for the action-items and confirmation emails.
  4. (Optional) Create a HubSpot private app token and set it in the configuration so the workflow can create CRM notes.
  5. Copy the webhook URL from the webhook trigger and configure your transcript source to POST JSON that includes a transcript field.