LineChatBot with Google Sheets Memory Management

This n8n workflow integrates a Line Chatbot with Google Sheets to create a dynamic conversational memory system. When a user sends a message via Line, the workflow captures the input, retrieves previous chat history from Google Sheets, and compiles it into an optimized prompt for an AI language model (Google Gemini). The AI responds in Thai, reflecting a friendly and helpful personality named ‘ลลิตา’. The conversation, along with the user’s message, is then stored back into Google Sheets, with intelligent splitting and archiving of chat history to prevent data overflow. This setup is particularly useful for maintaining long-term, context-aware chatbot interactions in Thai, ensuring relevant past conversations are remembered and handled efficiently.