n8n Workflow: Score Sales Calls from Google Drive to Sheets

Turn New Google Drive Call Recordings into Actionable Sales Scoring—Automatically

This n8n workflow automatically watches a Google Drive folder for new call audio files, analyzes each recording with Google Gemini (gemini-3.6-flash), and appends a structured “sales call score” (sentiment + lead qualification + objections + next actions) into a Google Sheets “Call Sheet”.

What this workflow does

• Monitors your Google Drive folder every minute and triggers when a new file is created.
• Filters file types: it checks whether the new item is an audio file and ignores anything that isn’t.
• Downloads and processes audio in sequence to avoid rate-limit issues (handles files one at a time).
• Analyzes the audio with Google Gemini to generate a JSON response covering:
  • Sentiment and sentiment score
  • Lead qualification details
  • Objections
  • A summary
  • Recommended next actions
• Writes results to Google Sheets by extracting the JSON fields and appending them as a new row (including a timestamp) to your “Call Sheet”.
• Waits 30 seconds between processing the next file in the batch.

Use cases

• SaaS teams logging call outcomes to keep pipeline reporting consistent in Google Sheets.
• Sales managers reviewing sentiment, objections, and recommended follow-ups per call without manual transcription review.
• Automation engineers standardizing lead scoring outputs from recorded calls stored in Google Drive.

Technical details

• Trigger cadence: runs every minute for new file creation in a specified Google Drive folder.
• Core nodes/logic: if, set, no op, wait, sticky note, Google Drive.
• AI analysis: sends the audio binary to Google Gemini (models/gemini-3.6-flash) and parses the returned JSON.
• Data destination: appends to a Google Sheets tab such as “Call Sheet” (e.g., from “Spreadsheet_Sentiment”).
• Expected columns: sentiment, sentiment score, objection category, lead qualification, recommended action, follow-up status, prospect name, company name, and conversation summary.

Get started

Connect your Google Drive OAuth2 credentials, add your Google Gemini (PaLM) API credential, and wire Google Sheets OAuth2 to your target spreadsheet ID and sheet tab. Ensure your sheet columns match the JSON output fields for a clean, automated sales-call scoring log.