Ai Website Chatbot With Crm Lead Collection Using Gpt And Google Sheets 7227 – n8n Workflows – Free Template

What This Workflow Does

This n8n workflow creates an intelligent AI-powered chatbot for websites that collects leads and stores customer data directly into Google Sheets. It combines OpenAI’s GPT language model with CRM functionality, enabling real-time conversations while automatically capturing visitor information for follow-up and sales purposes.

How It Works

The workflow operates through a series of interconnected nodes that handle chat interactions and data management:

• A chat trigger captures incoming messages from website visitors
• The AI agent processes user input using OpenAI’s GPT model with customizable system messages
• Memory buffer window maintains conversation context across multiple exchanges
• Structured output parser formats responses for consistency
• Google Sheets integration automatically logs lead information and conversation details
• Tool workflow nodes enable extended functionality and custom logic
• Code nodes allow for advanced customization and data transformation

Use Cases

• Customer Support Automation: Provide instant responses to frequently asked questions while documenting customer issues for your support team
• Lead Generation: Qualify and capture prospect information automatically during initial conversations before handing off to sales
• Product Information: Guide potential customers through product features and capabilities in natural language conversations
• Appointment Scheduling Assistance: Help visitors understand availability and collect their contact details for scheduling follow-ups
• Feedback Collection: Gather customer opinions and suggestions while building a database of insights for product improvement

Nodes Used

• Chat Trigger (@n8n/chatTrigger): Listens for incoming chat messages from website visitors
• Execute Workflow Trigger (executeWorkflowTrigger): Enables workflow orchestration and execution control
• LM Chat OpenAI (@n8n/lmChatOpenAi): Integrates with OpenAI’s GPT model for natural language processing
• Memory Buffer Window (@n8n/memoryBufferWindow): Maintains conversation history and context
• Agent (@n8n/agent): Orchestrates the AI chatbot behavior and decision-making
• Output Parser Structured (@n8n/outputParserStructured): Formats AI responses into structured data
• Google Sheets (googleSheets): Stores lead information and chat transcripts
• Code Node (code): Enables custom logic and data manipulation
• Tool Workflow (@n8n/toolWorkflow): Extends functionality with additional workflow capabilities
• Sticky Note (stickyNote): Provides documentation and workflow notes

Prerequisites

• An active n8n account with workflow creation access
• OpenAI API key for GPT model integration
• Google account with Google Sheets enabled
• Website with chat embed capability or webhook integration
• Basic understanding of workflow automation concepts
• Configured authentication for OpenAI and Google services

Difficulty Level

Intermediate. This workflow requires understanding of AI agent configuration, API integration, and data management. While the template provides a foundation, customizing system messages, adjusting conversation flows, and mapping Google Sheets columns will require some technical knowledge. Users with basic n8n experience and familiarity with APIs should be able to set this up successfully.

This workflow template is shared under the n8n fair-code license. Free to use and modify.