{"product_id":"n8n-workflow-score-sales-calls-from-google-drive-to-sheets","title":"n8n Workflow: Score Sales Calls from Google Drive to Sheets","description":"\u003ch3\u003eTurn New Google Drive Call Recordings into Actionable Sales Scoring—Automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically watches a \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e folder for new call audio files, analyzes each recording with \u003cstrong\u003eGoogle Gemini (gemini-3.6-flash)\u003c\/strong\u003e, and appends a structured “sales call score” (sentiment + lead qualification + objections + next actions) into a \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e “Call Sheet”.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMonitors your Google Drive folder\u003c\/strong\u003e every minute and triggers when a new file is created.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters file types\u003c\/strong\u003e: it checks whether the new item is an audio file and ignores anything that isn’t.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads and processes audio in sequence\u003c\/strong\u003e to avoid rate-limit issues (handles files one at a time).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnalyzes the audio with Google Gemini\u003c\/strong\u003e to generate a JSON response covering:\n    \u003cul\u003e\n      \u003cli\u003eSentiment and sentiment score\u003c\/li\u003e\n      \u003cli\u003eLead qualification details\u003c\/li\u003e\n      \u003cli\u003eObjections\u003c\/li\u003e\n      \u003cli\u003eA summary\u003c\/li\u003e\n      \u003cli\u003eRecommended next actions\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites results to Google Sheets\u003c\/strong\u003e by extracting the JSON fields and appending them as a new row (including a \u003cstrong\u003etimestamp\u003c\/strong\u003e) to your “Call Sheet”.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWaits 30 seconds\u003c\/strong\u003e between processing the next file in the batch.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams logging call outcomes to keep pipeline reporting consistent in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eSales managers reviewing sentiment, objections, and recommended follow-ups per call without manual transcription review.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers standardizing lead scoring outputs from recorded calls stored in Google Drive.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTrigger cadence\u003c\/strong\u003e: runs every minute for new file creation in a specified Google Drive folder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore nodes\/logic\u003c\/strong\u003e: \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003eno op\u003c\/em\u003e, \u003cem\u003ewait\u003c\/em\u003e, \u003cem\u003esticky note\u003c\/em\u003e, \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI analysis\u003c\/strong\u003e: sends the audio binary to \u003cstrong\u003eGoogle Gemini (models\/gemini-3.6-flash)\u003c\/strong\u003e and parses the returned JSON.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData destination\u003c\/strong\u003e: appends to a Google Sheets tab such as \u003cstrong\u003e“Call Sheet”\u003c\/strong\u003e (e.g., from “Spreadsheet_Sentiment”).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExpected columns\u003c\/strong\u003e: sentiment, sentiment score, objection category, lead qualification, recommended action, follow-up status, prospect name, company name, and conversation summary.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eGet started\u003c\/h3\u003e\n\u003cp\u003eConnect your \u003cstrong\u003eGoogle Drive OAuth2\u003c\/strong\u003e credentials, add your \u003cstrong\u003eGoogle Gemini (PaLM) API\u003c\/strong\u003e credential, and wire \u003cstrong\u003eGoogle Sheets OAuth2\u003c\/strong\u003e 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.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45767891976371,"sku":"N8N-17888","price":60.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/duZ1ts4z3Abv2qvhJEJGF_cPEicBSx.png?v=1786093334","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-score-sales-calls-from-google-drive-to-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}