{"product_id":"chat-crm-lead-manager-with-google-gemini-google-sheets-n8n","title":"Chat CRM Lead Manager with Google Gemini \u0026 Google Sheets (n8n)","description":"\u003ch3\u003eTurn Google Sheets into a Chat CRM: add leads, answer pipeline questions, and log every message with Google Gemini (n8n)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow lets you use a chat interface as a CRM lead manager: it can append new leads to a Google Sheets \u003cb\u003e“Leads”\u003c\/b\u003e tab, answer pipeline questions by reading that sheet, and write a complete conversation log to \u003cb\u003e“Chat Log”\u003c\/b\u003e—powered by \u003cb\u003eGoogle Gemini\u003c\/b\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eReceives chat messages\u003c\/b\u003e through the built-in n8n chat interface (Chat Trigger URL).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eInterprets the user’s intent\u003c\/b\u003e using a Google Gemini agent with short-term conversation memory to decide whether to:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cb\u003eAdd a lead\u003c\/b\u003e (append a new row in the Google Sheets “Leads” worksheet)\u003c\/li\u003e\n      \u003cli\u003e\n\u003cb\u003eQuery the pipeline\u003c\/b\u003e (read rows from “Leads” and compute counts\/totals using a calculator tool)\u003c\/li\u003e\n      \u003cli\u003e\n\u003cb\u003eHandle other requests\u003c\/b\u003e via intent classification\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eConfirms lead additions\u003c\/b\u003e with a short reply after successfully appending the row.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLogs assistant usage\u003c\/b\u003e by classifying each incoming message intent (add, query, update, or other) and appending the message + tagged intent to the \u003cb\u003eGoogle Sheets “Chat Log”\u003c\/b\u003e tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eA SaaS operator uses chat to quickly record new prospects and keep a live pipeline in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eSales\/ops teams ask questions like “How many leads do we have?” or “Total leads this week” and get answers based on the sheet data.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers track how the assistant is used over time with an auditable “Chat Log” of messages and intents.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003en8n chat interface\u003c\/b\u003e via \u003ci\u003en8nn8n-nodes-langchainchat Chat Trigger\u003c\/i\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Gemini (PaLM) API\u003c\/b\u003e for the Gemini agent and intent-tagging model (requires API credentials).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets\u003c\/b\u003e integration (OAuth2) with a selected CRM spreadsheet.\u003c\/li\u003e\n  \u003cli\u003eWorks with two worksheets named exactly: \u003cb\u003e“Leads”\u003c\/b\u003e and \u003cb\u003e“Chat Log”\u003c\/b\u003e (columns should match what you want to capture).\u003c\/li\u003e\n  \u003cli\u003eUses n8n LangChain components: \u003ci\u003en8nn8n-nodes-langchainagent\u003c\/i\u003e, \u003ci\u003egoogle sheets tool\u003c\/i\u003e, and \u003ci\u003en8nn8n-nodes-langchainchain llm\u003c\/i\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eOpen the \u003cb\u003eChat Trigger URL in n8n\u003c\/b\u003e, then share or embed it wherever your team handles CRM chats.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45747800211635,"sku":"N8N-17658","price":56.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/iwFlLQZwCzNVF9yQ1yH2l_fVbW3f7U.png?v=1785488653","url":"https:\/\/buyflowscripts.com\/products\/chat-crm-lead-manager-with-google-gemini-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}