What This Workflow Does
This automation solves the common problem of losing important files shared through LINE messages. Customer service teams, sales reps, and field staff often receive critical documents via LINE - contracts, receipts, ID copies - that need proper archival. Manual saving leads to lost files, disorganization, and compliance risks.
The workflow automatically detects file attachments in incoming LINE messages, saves them to designated Google Drive folders with proper naming conventions, and creates a detailed log in Google Sheets. This creates a searchable archive while eliminating manual file management work.
How It Works
1. LINE Message Trigger
The workflow monitors your LINE channel for new messages containing file attachments. It captures the file along with sender details and timestamp.
2. File Processing
Each file gets renamed using a consistent format (e.g. "2023-11-15_ClientName_Document.pdf") and has its metadata extracted. The system checks for duplicate files to prevent unnecessary transfers.
3. Google Drive Upload
Files get saved to predetermined Drive folders, which can be organized by date, department, or project. The folder structure automatically creates subfolders as needed.
4. Google Sheets Logging
A row gets added to your tracking sheet with file details including: original message text, sender info, timestamp, file type, Drive link, and any custom tags. This creates an audit trail.
Pro tip: Add a column in your Sheet for status tracking to manage follow-up actions on received files.
Who This Is For
This automation benefits any business using LINE for customer communication:
- Customer support teams receiving documentation
- Sales teams getting signed contracts via LINE
- Field service technicians submitting work reports
- Healthcare providers receiving patient documents
- Education institutions managing student submissions
What You'll Need
- A LINE Business account with Messaging API access
- Google Workspace account (for Drive and Sheets)
- n8n instance (self-hosted or cloud)
- Google Cloud Project with Drive and Sheets API enabled
Quick Setup Guide
- Download the JSON template file
- Import into your n8n instance
- Connect your LINE channel credentials
- Authorize Google Drive and Sheets access
- Configure target folder paths in Drive
- Set up your tracking Sheet template
- Test with sample LINE messages
Key Benefits
Eliminate lost files with automatic backup of every LINE attachment to your secure Google Drive, ensuring compliance with data retention policies.
Save 5+ hours weekly by removing manual file saving and organization work from your team's workload.
Improve response times with instant access to customer documents through the searchable Sheets log, no more digging through message history.
Customizable organization that adapts to your business needs with folder structures by date, department, or project.
Audit-ready documentation with complete tracking of when files were received, by whom, and where they're stored.