Analyze meeting sentiment with Azure OpenAI and save insights to Google Sheets
Go to Workflow
Rahul Joshi
Description
📊 Description
This workflow analyzes meeting transcripts using AI to understand team sentiment, engagement, and morale.
The results are saved in Google Sheets for easy tracking and review.
It receives meeting data through a webhook, validates the input, sends the transcript to AI for analysis, cleans the output, and stores the insights in a structured format. This helps teams track morale over time and spot risks early.
🔁 What This Template Does
Receives meeting transcript data through a webhook.
Checks that all required fields are present.
Sends the transcript to AI for analysis.
Identifies sentiment, engagement, emotional tone, and morale risk.
Cleans and structures the AI response.
Adds a timestamp for when the analysis was done.
Looks for an existing record in Google Sheets using the meeting ID.
Updates the row if the meeting already exists.
Creates a new row if the meeting is new.
Sends a response back to the webhook caller.
⭐ Key Benefits
Removes the need for manual sentiment review
Gives consistent and structured meeting insights
Helps detect morale and engagement risks early
Avoids duplicate records using meeting ID
Keeps all sentiment data in one place
Works with any system that can send webhooks
🧩 Features
Webhook-based meeting data input
AI-powered sentiment and engagement analysis
Clear extraction of morale and risk signals
Clean and predictable output structure
Google Sheets create or update logic
Safe retry handling using meeting ID
Webhook response after completion
Production-ready workflow design
🔐 Requirements
A webhook source that can send meeting data
Azure OpenAI credentials or a compatible AI model
Google Sheets OAuth credentials
A Google Sheet with required columns
An AI prompt for meeting sentiment analysis
🎯 Target Audience
Engineering and product teams
HR and people operations teams
Project and delivery managers
Leadership teams tracking team health
n8n automation builders
Organizations monitoring meeting effectiveness