Analyze Zoom phone call recordings with Gemini and log results to Google Sheets

Description

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