{"product_id":"n8n-agency-lead-routing-openai-scoring-gmail-replies","title":"n8n Agency Lead Routing: OpenAI Scoring + Gmail Replies","description":"\u003ch3\u003eAutomatically score agency leads with OpenAI, reply via Gmail, and track everything in Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n Agency Lead Routing workflow captures inbound agency leads from a hosted n8n form, uses OpenAI to score and draft responses, logs every lead to Google Sheets, and sends tier-based Gmail replies—plus a weekly pipeline digest for your sales process.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCaptures new submissions\u003c\/strong\u003e from a hosted n8n lead intake form (Form Trigger).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores and classifies leads with OpenAI\u003c\/strong\u003e to generate: lead score, Hot\/Warm\/Cold tier, intent, services needed, reasoning, and a drafted \u003cem\u003eplain-text reply\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs structured lead data to Google Sheets\u003c\/strong\u003e (appends a record including fields such as name, email, company, website, budget, needs, lead_score, tier, intent, services_needed, reasoning, reply_draft, status, and received_at).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes by lead tier\u003c\/strong\u003e using a Switch step and sends the appropriate \u003cstrong\u003eGmail\u003c\/strong\u003e reply to the lead.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlerts sales for Hot leads\u003c\/strong\u003e by emailing the sales team a detailed alert so follow-up can happen quickly.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a weekly pipeline digest every Monday at 9am\u003c\/strong\u003e: reads leads from Google Sheets, builds an HTML summary for the last 7 days, and emails it via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAgencies or SaaS operators receiving inbound lead form submissions and needing instant qualification + responses.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers implementing an \u003cstrong\u003eOpenAI scoring\u003c\/strong\u003e pipeline with \u003cstrong\u003eGoogle Sheets lead tracking\u003c\/strong\u003e and \u003cstrong\u003eGmail-based routing\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eTeams who want Hot\/Warm\/Cold triage with a weekly email digest to keep the pipeline visible.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e: generates lead score, tier (Hot\/Warm\/Cold), intent, services_needed, reasoning, and reply_draft.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (OAuth2): appends lead records and powers the weekly pipeline digest.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e (OAuth2): sends tier-based replies, Hot-lead sales alerts, and the weekly digest (HTML summary).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used\u003c\/strong\u003e: form trigger, set, code, gmail, switch, sticky note.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup note:\u003c\/strong\u003e provide credentials for OpenAI, Google Sheets OAuth2, and Gmail OAuth2; confirm your worksheet headers (name, email, company, website, budget, needs, lead_score, tier, intent, services_needed, reasoning, reply_draft, status, received_at); and set the recipient addresses for sales alerts and the weekly digest.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46008796053683,"sku":"N8N-19485","price":62.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/AKro9HWLqID3wOAkFoetK_7dUKUZxU.png?v=1789204517","url":"https:\/\/buyflowscripts.com\/products\/n8n-agency-lead-routing-openai-scoring-gmail-replies","provider":"N8N Commerce","version":"1.0","type":"link"}