{"product_id":"n8n-workflow-log-line-official-account-messages-to-google-sheets","title":"n8n Workflow: Log LINE Official Account Messages to Google Sheets","description":"\u003ch3\u003eAutomatically log every LINE Official Account text message to Google Sheets—then auto-reply\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures \u003cstrong\u003eincoming messages from your LINE Official Account\u003c\/strong\u003e, saves each text message to a \u003cstrong\u003eGoogle Sheet\u003c\/strong\u003e (with timestamp and sender details), and immediately sends a short \u003cstrong\u003eLINE auto-reply\u003c\/strong\u003e using the official reply token.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives LINE events via Webhook\u003c\/strong\u003e: The LINE Webhook receives messages from the \u003cstrong\u003eLINE Messaging API\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eVerifies request authenticity\u003c\/strong\u003e: The \u003cem\u003eVerify LINE Signature\u003c\/em\u003e node checks the \u003cstrong\u003ex-line-signature\u003c\/strong\u003e header using HMAC-SHA256 with your \u003cstrong\u003eChannel secret\u003c\/strong\u003e. If verification fails, it returns \u003cstrong\u003e401\u003c\/strong\u003e and answers LINE with \u003cstrong\u003e200 OK\u003c\/strong\u003e right away as LINE expects.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses each event and filters to text only\u003c\/strong\u003e: \u003cem\u003eSplit Out Events\u003c\/em\u003e handles events separately, and \u003cem\u003eOnly Text Messages\u003c\/em\u003e keeps text messages only.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnriches with sender info\u003c\/strong\u003e: \u003cem\u003eGet LINE User Profile\u003c\/em\u003e retrieves the sender’s \u003cstrong\u003edisplay name\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends a row to Google Sheets\u003c\/strong\u003e: \u003cem\u003eAppend Row to Google Sheet\u003c\/em\u003e stores \u003cstrong\u003etimestamp, userId, displayName, message, and replyToken\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends an auto-reply\u003c\/strong\u003e: \u003cem\u003eSend LINE Auto-Reply\u003c\/em\u003e replies using the \u003cstrong\u003ereplyToken\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSmall shops and teams who manage customer chat via \u003cstrong\u003eLINE OA\u003c\/strong\u003e and want a simple, auditable \u003cstrong\u003emessage log\u003c\/strong\u003e without a full CRM.\u003c\/li\u003e\n  \u003cli\u003eOperational visibility: quickly track inbound requests, questions, or feedback by sender and time.\u003c\/li\u003e\n  \u003cli\u003eLightweight support intake: log everything first, then respond instantly to confirm receipt.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIntegrates with \u003cstrong\u003eLINE Messaging API\u003c\/strong\u003e using a Webhook and signature verification.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for appending rows (timestamp, userId, displayName, message, replyToken).\u003c\/li\u003e\n  \u003cli\u003en8n nodes include: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003efilter\u003c\/strong\u003e, \u003cstrong\u003ewebhook\u003c\/strong\u003e, \u003cstrong\u003esplit out\u003c\/strong\u003e, plus supporting logic (e.g., sticky notes for guidance).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup inputs:\u003c\/strong\u003e In LINE Developers, use your \u003cstrong\u003eChannel secret\u003c\/strong\u003e and a \u003cstrong\u003elong-lived Channel access token\u003c\/strong\u003e. In n8n, configure the HTTP Request authentication as \u003ccode\u003eBearer \u0026lt;your token\u0026gt;\u003c\/code\u003e, paste the secret into the signature verification node, and connect the target Google Sheet.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46244507058355,"sku":"N8N-21172","price":53.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/TlnbMiMOQQBpwqM-FiNQy_rpZ8l2gz.png?v=1792400799","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-log-line-official-account-messages-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}