{"product_id":"qualify-score-omnichannel-leads-with-openai-gmail-sheets","title":"Qualify \u0026 Score Omnichannel Leads with OpenAI, Gmail \u0026 Sheets","description":"\u003ch3\u003eQualify and score every omnichannel lead automatically—using OpenAI, Gmail, and Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures inbound leads from \u003cstrong\u003eGmail\u003c\/strong\u003e or a \u003cstrong\u003ewebhook\u003c\/strong\u003e, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to extract qualification signals, then \u003cstrong\u003escores and classifies\u003c\/strong\u003e each lead (HOT\/WARM\/LOW). It logs results to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and creates a \u003cstrong\u003epersonalized Gmail draft\u003c\/strong\u003e for HOT leads for quick human review.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers on new lead input\u003c\/strong\u003e: runs when a new \u003cstrong\u003eunread Gmail email\u003c\/strong\u003e arrives or when a \u003cstrong\u003ePOST request\u003c\/strong\u003e hits the configured \u003cstrong\u003ewebhook endpoint\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and validates data\u003c\/strong\u003e: converts the incoming email\/webhook payload into a consistent lead format and checks required fields (including \u003cstrong\u003esender email\u003c\/strong\u003e and \u003cstrong\u003emessage\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicates\u003c\/strong\u003e: loads existing leads from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and stops processing if the incoming lead matches an existing \u003cstrong\u003eSource Record ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts structured signals with OpenAI\u003c\/strong\u003e: identifies qualification details such as \u003cem\u003eintent\u003c\/em\u003e, \u003cem\u003eurgency\u003c\/em\u003e, \u003cem\u003ecompany\u003c\/em\u003e, and \u003cem\u003emissing information\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores and classifies leads\u003c\/strong\u003e: calculates a \u003cstrong\u003eweighted lead score\u003c\/strong\u003e, then assigns a \u003cstrong\u003eHOT\/WARM\/LOW\u003c\/strong\u003e classification using configured thresholds.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs to Google Sheets\u003c\/strong\u003e: appends the finalized lead record to your tracking spreadsheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDrafts responses for HOT leads\u003c\/strong\u003e: for HOT leads, uses OpenAI to draft a tailored reply, adds your configured signature, and creates a \u003cstrong\u003eGmail draft\u003c\/strong\u003e (threaded for Gmail-sourced leads).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams triaging inbound enquiries from email while also accepting lead submissions via webhook.\u003c\/li\u003e\n  \u003cli\u003eOperators who want lead qualification scoring with human-in-the-loop email sending for high-priority (HOT) leads.\u003c\/li\u003e\n  \u003cli\u003eBusinesses maintaining a single source of truth for lead history in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e with duplicate detection.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e trigger for new unread emails and \u003cstrong\u003eGmail draft\u003c\/strong\u003e creation for HOT leads\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook\u003c\/strong\u003e trigger for omnichannel inbound POST requests\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e for structured extraction, lead scoring signals, and tailored reply drafting\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e integration to load existing leads and append new lead records\u003c\/li\u003e\n  \u003cli\u003eCore workflow logic via \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46019109716147,"sku":"N8N-19539","price":14.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/36PgxYS8F7hSN-RiJFGW__cyROvphU.png?v=1789377058","url":"https:\/\/buyflowscripts.com\/products\/qualify-score-omnichannel-leads-with-openai-gmail-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}