{"product_id":"n8n-lead-qualification-google-sheets-openai-twilio-whatsapp","title":"n8n Lead Qualification: Google Sheets + OpenAI + Twilio WhatsApp","description":"\u003ch3\u003eTurn every new lead into a qualified conversation automatically (Google Sheets + OpenAI + Twilio WhatsApp)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow polls your Google Sheets lead intake every 15 minutes, uses \u003cstrong\u003eOpenAI (GPT-4o-mini)\u003c\/strong\u003e to score and classify enquiries, logs enriched results into your \u003cstrong\u003eGoogle Sheets CRM\u003c\/strong\u003e, and instantly notifies the right counsellor—while sending the student a \u003cstrong\u003eTwilio WhatsApp\u003c\/strong\u003e welcome message.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a 15-minute schedule\u003c\/strong\u003e (schedule trigger).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads rows\u003c\/strong\u003e from the Google Sheets tab \u003cem\u003e“New Leads Input”\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSkips incomplete entries\u003c\/strong\u003e where \u003cem\u003e“Full Name”\u003c\/em\u003e is empty.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes lead fields\u003c\/strong\u003e (name, phone, email, course, city, source), creates a timestamp-based \u003cem\u003eLead ID\u003c\/em\u003e, and captures the source row number.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls OpenAI (GPT-4o-mini)\u003c\/strong\u003e with the lead details to return JSON including: intent score, lead category, course category, and a counsellor note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAssigns a counsellor at random\u003c\/strong\u003e from a predefined roster and merges this with the AI outputs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts into Google Sheets\u003c\/strong\u003e in the \u003cem\u003e“Leads CRM”\u003c\/em\u003e tab and marks the intake row as \u003cem\u003eProcessed\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends messages\/notifications\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eStudent:\u003c\/strong\u003e WhatsApp via \u003cstrong\u003eTwilio\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eCounsellor:\u003c\/strong\u003e alerts via \u003cstrong\u003eTelegram\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e with lead details and AI talking points\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eError handling:\u003c\/strong\u003e posts an alert to a \u003cstrong\u003eSlack\u003c\/strong\u003e channel if the workflow fails.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate lead qualification for admissions teams using \u003cem\u003eGoogle Sheets\u003c\/em\u003e as the intake form.\u003c\/li\u003e\n  \u003cli\u003eRoute enquiries with AI intent scoring so counsellors focus on higher-fit leads.\u003c\/li\u003e\n  \u003cli\u003eInstantly confirm WhatsApp follow-ups and notify internal teams (Telegram\/Gmail) without manual work.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: OAuth2 connection; reads from \u003cem\u003e“New Leads Input”\u003c\/em\u003e, writes to \u003cem\u003e“Leads CRM”\u003c\/em\u003e, updates \u003cem\u003eProcessed\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e: GPT-4o-mini for JSON-based scoring\/classification.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMessaging\u003c\/strong\u003e: \u003cstrong\u003eTwilio WhatsApp\u003c\/strong\u003e, \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail \u0026amp; alerts\u003c\/strong\u003e: \u003cstrong\u003eGmail\u003c\/strong\u003e notifications to assigned counsellor, \u003cstrong\u003eSlack\u003c\/strong\u003e error alerts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow components\u003c\/strong\u003e include nodes such as \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, and a \u003cem\u003esticky note\u003c\/em\u003e for clarity.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45872819339443,"sku":"N8N-18480","price":28.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/BwuRxPGbvYaG_4d4hhXt3_LFbicE9u.png?v=1787216892","url":"https:\/\/buyflowscripts.com\/products\/n8n-lead-qualification-google-sheets-openai-twilio-whatsapp","provider":"N8N Commerce","version":"1.0","type":"link"}