Build Your Own Memory Chatbot with Line and Google Sheets
detail.loadingPreview
Create a powerful Line chatbot that remembers your conversations using Google Sheets as its memory. This n8n workflow allows your AI assistant, "ลลิตา," to recall past interactions and provide more personalized responses in Thai.
About This Workflow
Unlock the potential of conversational AI with this n8n workflow that seamlessly integrates Line messaging with the enduring memory of Google Sheets. Designed to empower your AI assistant, named "ลลิตา," this solution ensures every conversation is remembered, creating a truly personalized and context-aware experience for your users in Thailand. By leveraging Google Gemini for intelligent responses and Google Sheets for persistent conversation history, this workflow provides a robust foundation for building engaging and helpful chatbots. The AI agent is meticulously configured to understand and respond in Thai, operating within the local time zone for optimal user interaction. This workflow is perfect for developers and businesses looking to enhance their customer engagement through intelligent, memory-enabled messaging.
Key Features
- Line Chatbot Integration: Receive messages from users directly via Line.
- AI-Powered Responses: Utilize Google Gemini (models/gemini-2.0-flash-001) for intelligent and contextually relevant replies.
- Persistent Memory: Store and retrieve conversation history from Google Sheets, enabling the AI to remember past interactions.
- Thai Language Support: Configure your AI assistant, "ลลิตา," to communicate fluently and politely in Thai.
- Time Zone Awareness: Operates within the Thailand time zone (Asia/Bangkok, UTC+7) for localized interactions.
How To Use
- Set up n8n and necessary credentials: Ensure you have n8n installed and have connected your Line and Google Sheets accounts.
- Configure the Line Webhook: Set up a webhook in your Line Developer console to point to your n8n instance's webhook URL (e.g.,
https://your-n8n-instance.com/webhook/guitarpa). - Customize the AI Agent: In the 'AI Agent' node, review and adjust the
systemMessageto define your AI's persona and behavior. - Connect Google Sheets: In the 'Get History' and 'Save History' nodes, specify your Google Sheet document ID and sheet name where conversation history will be stored.
- Define Data Mapping: Ensure the 'Edit Fields' node correctly extracts necessary data from the Line webhook (message text, reply token, user ID).
- Construct Prompts: The 'Prepare Prompt' node dynamically builds the prompt for the AI by combining retrieved history and the current user message.
- Send Replies via Line: The 'HTTP Request' node sends the AI's generated response back to the user on Line.
Apps Used
Workflow JSON
{
"id": "9551e25d-876f-4785-95b6-8cefb3922899",
"name": "Build Your Own Memory Chatbot with Line and Google Sheets",
"nodes": 5,
"category": "Marketing",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 9551e25d-876f...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
AI-Powered On-Page SEO Audit & Report Automation
Instantly generate comprehensive on-page SEO technical and content audits for any website URL. This AI-powered workflow automates the entire process, from scraping the page to delivering a detailed report directly to your inbox, empowering you to optimize for better search rankings and user engagement.
Automated AI Motion Illustration Workflow with Midjourney and Kling
Unleash your creativity with this n8n workflow that automates the generation of stunning motion illustrations. It leverages the power of Midjourney for static image creation and Kling AI to transform them into dynamic videos, all managed through the PiAPI. Perfect for content creators, marketers, and social media professionals looking to produce engaging visuals at scale.
Automate LinkedIn Content Promotion for Your Ghost Blog with AI
Effortlessly promote your latest Ghost blog posts on LinkedIn. This workflow leverages AI to generate engaging, professional LinkedIn messages based on your article content and saves them, along with article metadata, directly to a Google Sheet.