Analyze Zoom phone call recordings with Gemini AI and log to Google Sheets
Analyze Zoom phone call recordings with Gemini AI and log to Google Sheets Who is this for Sales managers and team leads who use Zoom Phone for outbound calls and want automated performance tracking without manually reviewing every recording. What this workflow does A schedule trigger runs periodically and fetches recent phone recordings from the Zoom Phone API Each recording is split out and processed one by one through a loop The audio file is downloaded from Zoom, then sent in parallel to: Google Drive for backup storage Google Gemini API for AI-powered call analysis Gemini evaluates how far the call progressed (contact reached, needs identified, meeting proposed, or appointment booked) and returns specific coaching advice The analysis results are merged with the Google Drive link and caller metadata Everything is appended as a new row in a Google Sheets tracking document How to set up Zoom credentials — Create a Server-to-Server OAuth app in the Zoom Marketplace with phone:read and recording:read scopes. Add the credentials in n8n as "Zoom OAuth2 API" Google Gemini API — Get an API key from Google AI Studio and add it as "Google PaLM API" credentials in n8n Google Drive — Connect your Google Drive OAuth2 account and set the target folder ID in the "Upload to Google Drive" node Google Sheets — Connect Google Sheets OAuth2 and set your spreadsheet ID in the "Log to Google Sheets" node. Create columns: Caller, Date, Number, Direction, Stage, Advice, DriveURL Requirements Zoom Phone plan with call recording enabled Google Cloud account with Gemini API access Google Workspace (Drive + Sheets) n8n instance (cloud or self-hosted) How to customize Schedule frequency**: Adjust the interval in the Schedule Trigger node — default runs every hour Analysis prompt**: Edit the prompt text in the "Analyze Call with Gemini" node to match your scoring criteria or industry terminology Spreadsheet columns**: Add extra fields in the "Format Results" node if you want to track additional metadata like call duration or team name. An n8n automation workflow template by Oka Hironobu.
Oka Hironobu
web
paid
Others in the same category, ranked by how often they are opened.
