LINE AI Chatbot Reply with Gemini + Log to Google Sheets (n8n)

Turn LINE Messages Into an AI Chat Assistant (Gemini) + Log Everything to Google Sheets

This n8n workflow connects your LINE Official Account to Google Gemini so incoming customer messages automatically receive short, helpful AI replies—and every conversation is saved to Google Sheets for easy tracking.

What this workflow does

• Receives LINE webhook events via a POST webhook endpoint for the LINE Messaging API.
• Extracts required fields from the LINE event payload, including the reply token, user ID, and message text.
• Skips non-text messages by checking whether the event contains a text message before processing.
• Applies a brand and support persona (predefined text you can update) to guide Gemini’s reply style and language.
• Generates an AI response with Gemini using the customer message plus persona instructions, producing a short, helpful answer in the customer’s language.
• Sends the reply back to LINE using the LINE Messaging API and the reply token.
• Logs the exchange to Google Sheets by appending conversation rows for ongoing visibility and reporting.

Use cases

• Automate first-line support for an e-commerce LINE account (order questions, product FAQs) while keeping replies consistent with your persona.
• Reduce manual workload for SaaS operators handling common onboarding and troubleshooting questions via LINE.
• Maintain an audit trail of AI interactions by storing user messages and AI replies in Google Sheets.

Technical details

• n8n nodes/workflow components: webhook, if, set, code, http request (plus supporting notes/sticky note).
• LINE integration: uses HTTP Header Auth for the LINE Messaging API (Authorization: Bearer <token>) and replies using the LINE reply token.
• AI integration: Google Gemini (PaLM) chat model credentials.
• Logging: Google Sheets OAuth credentials; appends rows to a target spreadsheet (e.g., a sheet named “LINE Log”).

Perfect for: n8n users, automation engineers, and teams that want a practical LINE AI chatbot workflow with Gemini responses and Google Sheets conversation logging.