{"product_id":"n8n-ai-chatbot-lead-qualifier-openai-supabase-twilio","title":"n8n AI Chatbot Lead Qualifier: OpenAI + Supabase + Twilio","description":"\u003ch3\u003eTurn website chats into qualified leads—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow acts as an \u003cstrong\u003en8n AI chatbot lead qualifier\u003c\/strong\u003e for local service businesses and agencies. When visitors chat on your website, the bot answers using your FAQ, extracts key contact details, saves qualified leads to Google Sheets, sends an instant SMS via Twilio, and emails the full chat transcript to the owner via Gmail. Your FAQ knowledge stays current with a weekly updater.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCaptures visitor conversations\u003c\/strong\u003e through a webhook endpoint on your website.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnswers using your FAQ knowledge base\u003c\/strong\u003e stored in \u003cstrong\u003eSupabase\u003c\/strong\u003e (vector store). The AI agent responds based on the FAQ content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts lead information\u003c\/strong\u003e from the conversation: name, phone, service needed, and preferred time.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves qualified leads\u003c\/strong\u003e to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (a “Leads” tab).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends an instant SMS\u003c\/strong\u003e to the owner using \u003cstrong\u003eTwilio\u003c\/strong\u003e with the qualified lead details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail delivers the full transcript\u003c\/strong\u003e to the owner via \u003cstrong\u003eGmail\u003c\/strong\u003e so you can review the conversation context.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eKeeps answers up to date weekly\u003c\/strong\u003e: every Monday at \u003cstrong\u003e8:00 AM\u003c\/strong\u003e, the knowledge base updater lane downloads your FAQ document from \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, re-chunks it, and upserts it into the same \u003cstrong\u003eSupabase\u003c\/strong\u003e table (\u003ccode\u003efaq_documents\u003c\/code\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eA plumber\/clinic\/salon\/contractor gets website traffic but few enquiries—convert chat intent into SMS-notified leads.\u003c\/li\u003e\n  \u003cli\u003eAn agency wants to offer a chatbot lead qualification service without building each client bot from scratch.\u003c\/li\u003e\n  \u003cli\u003eTeams that update FAQs regularly need automated knowledge base refreshes without manual re-indexing.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIntegrations\/nodes: \u003cstrong\u003ewebhook\u003c\/strong\u003e, \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003etwilio\u003c\/strong\u003e, \u003cstrong\u003ewebhook\u003c\/strong\u003e, plus required credentials for \u003cstrong\u003eOpenAI\u003c\/strong\u003e, \u003cstrong\u003eSupabase\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eRequires creating a Supabase table: \u003ccode\u003efaq_documents\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003eConfiguration via two \u003cstrong\u003eCONFIG\u003c\/strong\u003e nodes: business\/trade\/service area\/hours, owner phone\/email, leads sheet ID, Twilio from-number, and Drive file ID for the FAQ document.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46275706945715,"sku":"N8N-21293","price":70.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Qhca-km8R-nDfLD56n-T-_033NKk58.png?v=1792833755","url":"https:\/\/buyflowscripts.com\/products\/n8n-ai-chatbot-lead-qualifier-openai-supabase-twilio","provider":"N8N Commerce","version":"1.0","type":"link"}