Connect LINE OA to Google Sheets Automatically with n8n — Step-by-Step

The LINE → Google Sheets Workflow is one of the most frequently built automations at CherCode — because the pain is real. Business owners and admin teams waste 1–2 hours every day manually copying data from LINE into a spreadsheet. It is repetitive, error-prone work that n8n can eliminate in 30 minutes. Once set up, the entire process runs automatically 24 hours a day.

Why Connect LINE OA to Google Sheets?

Before the tutorial, here are the real business problems this automation solves:

• •Daily copy-paste waste — manually moving LINE lead data to Sheets creates errors and consumes significant time
• •Data loss — LINE messages get missed or forgotten, losing leads permanently
• •No real-time data — lead counts and trends require manual updates before anyone can see them
• •No audit trail — impossible to know which campaign or date a lead came from
• •Does not scale — the more leads arrive, the more manual work grows, creating a ceiling on growth

5 Things You Can Do When LINE OA and Google Sheets Are Connected

Connecting these two systems goes beyond simply recording messages — it opens a range of capabilities:

• •Automatic lead capture — LINE name, phone number, and interest logged to Sheets instantly
• •Log orders — LINE purchase requests flow into Spreadsheet automatically with timestamps
• •Track conversations — full conversation history stored for analytics and review
• •Auto-reporting — Google Sheets calculates daily leads, conversion rate, and emails a report every morning
• •Basic CRM — use Google Sheets as a lightweight CRM before investing in a full platform

How to Connect LINE OA to Google Sheets with n8n — Step-by-Step

Requirements: a LINE Official Account, a Google account, and n8n (free trial at n8n.io or self-hosted):

1. 1.Open n8n and create a new Workflow — go to n8n → click New Workflow → name it 'LINE Lead Capture'
2. 2.Add a LINE Trigger Node — search 'LINE' in the Node Panel → select 'LINE Trigger' → click 'Add new credential' → enter Channel Secret and Channel Access Token from LINE Developers Console
3. 3.Copy the Webhook URL — n8n generates a Webhook URL → go to LINE Developers Console → open your Channel → paste this URL into the Webhook URL field → click Verify
4. 4.Add a Set Node to parse the data — extract `{{$json.events[0].source.userId}}`, `{{$json.events[0].message.text}}`, and a timestamp as clean, readable variables
5. 5.Add a Google Sheets Node — search 'Google Sheets' → select 'Append Row' → connect your Google Account → choose Spreadsheet and Sheet → map columns: A=timestamp, B=userId, C=message
6. 6.Add a Notification Node (optional) — add a Slack Node or LINE Notify Node to alert the team when a new lead arrives
7. 7.Test and Activate — send a test message from LINE → verify data appears in Google Sheets → click Activate Workflow

Example: Online Shop Capturing LINE Orders into Sheets Automatically

A customer sends a purchase message to LINE OA. The system: (1) parses the message to identify product name and quantity → (2) logs to Google Sheets with Status 'Pending' → (3) sends a confirmation reply to the customer via LINE → (4) notifies the Warehouse team in Slack. All of this happens within 3 seconds of the customer's message.

Going Further: Connect LINE OA to Other Systems via n8n

Once the core pattern is understood, Workflows can expand in any direction:

• •Notion — log leads to a Notion Database with tags and status properties
• •Airtable — use Airtable as a CRM with richer views and filters than Google Sheets
• •HubSpot / Pipedrive — push leads directly into a professional CRM platform
• •LINE Notify — send daily lead summary notifications to the Sales team every evening
• •Email (Gmail/SMTP) — auto-send a welcome email immediately after receiving a LINE lead
• •Trello / Asana — automatically create a follow-up Task card for every new lead

Cost and Time — DIY vs Professional Build

A comparison by business context: