Analyze Zoom phone call recordings with Gemini and log results to Google Sheets
Ready for 3.0What this workflow does
This workflow has 12 nodes and runs on a schedule (every hour). Along the way it connects Google Drive and Google Sheets. It also calls api.zoom.us and generativelanguage.googleapis.com over HTTP.
How it runs
Trigger: On a schedule (every hour).
- Get Zoom Phone Recordings (HTTP Request): calls api.zoom.us
- Process Each Recording (Split Out): splits a list into separate items
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Build File Name (Edit Fields (Set)): sets 1 field: FileName
- Download Recording (HTTP Request): calls an HTTP API
- Upload to Google Drive (Google Drive): uses Google Drive
- Upload Audio to Gemini (HTTP Request): calls generativelanguage.googleapis.com (POST)
- Merge: merges the data from its input branches
- Analyze Call with Gemini (HTTP Request): calls generativelanguage.googleapis.com (POST)
- Format Results (Edit Fields (Set)): sets 7 fields: Caller, Date, Number…
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: api.zoom.us, generativelanguage.googleapis.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Edit Fields (Set)
n8n-nodes-base.set - Google Drive
n8n-nodes-base.googleDrive - Merge
n8n-nodes-base.merge - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Split Out
n8n-nodes-base.splitOut
From the author
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…