{"product_id":"line-inbox-to-google-sheets-crm-daily-gmail-digest-n8n","title":"LINE Inbox to Google Sheets CRM + Daily Gmail Digest (n8n)","description":"\u003ch3\u003eTurn LINE inbound messages into a Google Sheets CRM—with an automatic daily Gmail follow‑up digest\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures every inbound LINE text message, logs it into a Google Sheets CRM, lets you respond through a secured webhook, and sends a daily Gmail digest of contacts who still need a reply.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives LINE webhook events\u003c\/strong\u003e and checks that the event is a `text` message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes the payload\u003c\/strong\u003e, fetches the sender profile from the LINE API, and combines everything into one contact\/message record.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites to Google Sheets\u003c\/strong\u003e: appends inbound messages to the \u003cem\u003e“Messages”\u003c\/em\u003e sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts contacts\u003c\/strong\u003e in the \u003cem\u003e“Contacts”\u003c\/em\u003e sheet by LINE user ID:\n    \u003cul\u003e\n      \u003cli\u003eIncrements message count\u003c\/li\u003e\n      \u003cli\u003eSets \u003ccode\u003eneeds_reply=true\u003c\/code\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles owner replies\u003c\/strong\u003e via a separate webhook:\n    \u003cul\u003e\n      \u003cli\u003eValidates an \u003ccode\u003eowner_key\u003c\/code\u003e\n\u003c\/li\u003e\n      \u003cli\u003eSends the reply back to the user using LINE push message API\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs outbound replies\u003c\/strong\u003e to \u003cem\u003e“Messages”\u003c\/em\u003e and updates the related contact to set \u003ccode\u003eneeds_reply=false\u003c\/code\u003e and \u003ccode\u003elast_reply_at\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 09:00\u003c\/strong\u003e: reads contacts from Google Sheets, filters to \u003ccode\u003eneeds_reply=true\u003c\/code\u003e, and sends a plain-text \u003cstrong\u003eGmail digest\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eManage customer support chats from LINE while keeping a lightweight CRM in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eEnsure no one gets missed with an automatic daily follow-up email via Gmail.\u003c\/li\u003e\n  \u003cli\u003eRoute team responses: submit replies through the owner webhook and keep message history synchronized.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLINE Messaging API webhooks (inbound) and push messaging (outbound)\u003c\/li\u003e\n  \u003cli\u003eGoogle Sheets CRM tabs: \u003cem\u003eContacts\u003c\/em\u003e and \u003cem\u003eMessages\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003en8n nodes referenced: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, \u003cstrong\u003ewebhook\u003c\/strong\u003e, \u003cstrong\u003eaggregate\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eIdeal for n8n users, automation engineers, and SaaS operators who want an auditable LINE-to-CRM workflow with Gmail-based daily reminders.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46081449689267,"sku":"N8N-19856","price":20.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/valaa2fJAt7tcQeP-zjEk_NbGuWHaB.png?v=1790241461","url":"https:\/\/buyflowscripts.com\/products\/line-inbox-to-google-sheets-crm-daily-gmail-digest-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}