(G) LineChatBot + Google Sheets (as a memory)

★ 6.0 · n8n · complex · 25 nodes

(G) LineChatBot + Google Sheets (as a memory) is an n8n automation template that connects a Line messaging bot to Google Gemini for AI-generated replies and uses Google Sheets as persistent conversation memory. Reach for it when you want an AI assistant inside Line that actually remembers what was said earlier in the chat, or when you need to log every conversation to a spreadsheet without setting up a separate database. Trigger: webhook. Integrations: Line Messaging API, Google Gemini, Google Sheets. The flow activates on each incoming Line message, reads the conversation history from Google Sheets, passes it to Gemini for a context-aware response, sends the reply back to Line, and appends the new exchange to the sheet. The direction is inbound message handling and AI response generation — not broadcasting or scraping; use other catalog templates for outbound notification flows. Deploy by importing into n8n and configuring credentials for Line Messaging API, Google Gemini, and Google Sheets. Works well for customer support bots, internal team assistants, or simple FAQ bots on Line; not the right fit when multi-user isolated memory or storage outside the Google ecosystem is required.