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
- Receives a POST webhook containing a meeting transcript (for example from Fireflies, Otter, or a custom form).
- Uses OpenAI to extract structured meeting notes including attendees, summary, decisions, action items, next steps, and sentiment.
- Appends the extracted meeting details to a Google Sheets tab named “Meetings.”
- Creates a new note in HubSpot CRM containing the meeting summary and attendees, continuing even if the HubSpot request fails.
- Formats the action items into a bullet list and, if any exist, emails them to the owner via Gmail.
- Emails a confirmation summary (summary, decisions, and next steps) to the rep via Gmail.
- 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
- Create OpenAI credentials and select a model (or update the model name in the workflow configuration).
- Connect Google Sheets OAuth, create a spreadsheet with a “Meetings” sheet/tab, and set your Google Sheet ID in both configuration steps.
- Connect Gmail OAuth and set the owner and rep email addresses used for the action-items and confirmation emails.
- (Optional) Create a HubSpot private app token and set it in the configuration so the workflow can create CRM notes.
- Copy the webhook URL from the webhook trigger and configure your transcript source to POST JSON that includes a
transcript field.