Chat CRM Lead Manager with Google Gemini & Google Sheets (n8n)

Turn Google Sheets into a Chat CRM: add leads, answer pipeline questions, and log every message with Google Gemini (n8n)

This n8n workflow lets you use a chat interface as a CRM lead manager: it can append new leads to a Google Sheets “Leads” tab, answer pipeline questions by reading that sheet, and write a complete conversation log to “Chat Log”—powered by Google Gemini.

What this workflow does

• Receives chat messages through the built-in n8n chat interface (Chat Trigger URL).
• Interprets the user’s intent using a Google Gemini agent with short-term conversation memory to decide whether to:
  • Add a lead (append a new row in the Google Sheets “Leads” worksheet)
  • Query the pipeline (read rows from “Leads” and compute counts/totals using a calculator tool)
  • Handle other requests via intent classification
• Confirms lead additions with a short reply after successfully appending the row.
• Logs assistant usage by classifying each incoming message intent (add, query, update, or other) and appending the message + tagged intent to the Google Sheets “Chat Log” tab.

Use cases

• A SaaS operator uses chat to quickly record new prospects and keep a live pipeline in Google Sheets.
• Sales/ops teams ask questions like “How many leads do we have?” or “Total leads this week” and get answers based on the sheet data.
• Automation engineers track how the assistant is used over time with an auditable “Chat Log” of messages and intents.

Technical details

• n8n chat interface via n8nn8n-nodes-langchainchat Chat Trigger.
• Google Gemini (PaLM) API for the Gemini agent and intent-tagging model (requires API credentials).
• Google Sheets integration (OAuth2) with a selected CRM spreadsheet.
• Works with two worksheets named exactly: “Leads” and “Chat Log” (columns should match what you want to capture).
• Uses n8n LangChain components: n8nn8n-nodes-langchainagent, google sheets tool, and n8nn8n-nodes-langchainchain llm.

Open the Chat Trigger URL in n8n, then share or embed it wherever your team handles CRM chats.