Automatically Save & Organize LINE Message Files in Google Drive with Sheets Logging — n8n 워크플로

높음 복잡도🔗 Webhook23개의 노드🏷️ File Management👁 2,911회 조회작성자: Jaruphat J.

개요

Overview This workflow automatically saves files received via LINE Messaging API into Google Drive and logs the file details into a Google Sheet. It checks the file type against allowed types, organizes files into date-based folders and (optionally) file type–specific subfolders, and sends a reply message back to the LINE user with the file URL or an error message if the file type is not permitted.

Who is this for? Developers & IT Administrators: Looking to integrate LINE with Google Drive and

사용된 노드

Google SheetsHTTP RequestGoogle DriveCode

워크플로 미리보기

Workflow Entry & Configuration
This section initializes the workflow by listening to i
the LINE Messaging API and retrieving configuration det
It merg
Folder Search & Creation
This section handles the logic for finding or creating
It checks if a date folder exists (when Store by Date i
Upload, Log, & Reply
Once the file is validated and the correct folder deter
to Google Drive and logs the details in a Google Sheet.
File Retrieval & Validation
In this group, the workflow fetches the binary content
and validates whether the file type is allowed (e.g., i
Get Config
Create Date Folder
Set Date Folder ID
Create File Type Folder
Upload File to Google Dr…
Determine Folder Info
Search Date Folder
M
Merge Event and Config D…
C
Check Existing Date Folder
C
Check Existing File Type…
M
Merge Final Parent Folde…
Search File Type Folder
Set File Type Folder ID
Configure Final Parent F…
Process Event and Config…
Get File Binary Content
Log File Details to Goog…
C
Check Reply Enabled Flag
C
Check if Store by Date i…
C
Check if Store by File T…
L
LINE Webhook Listener
Send LINE Reply Message
Validate File Type
23 nodes28 edges

작동 원리

  1. 1

    트리거

    워크플로는 webhook 트리거로 시작합니다.

  2. 2

    처리

    데이터가 23개의 노드를 통해 흐릅니다, connecting code, googledrive, googlesheets.

  3. 3

    출력

    워크플로가 자동화를 완료하고 구성된 대상에 결과를 전달합니다.

노드 세부 정보 (23)

GO

Google Sheets

googleSheets

#1
HT

HTTP Request

httpRequest

#2
GO

Google Drive

googleDrive

#3
CO

Code

code

#4

이 워크플로 가져오는 방법

  1. 1오른쪽의 JSON 다운로드 버튼을 클릭하여 워크플로 파일을 저장합니다.
  2. 2n8n 인스턴스를 열고 워크플로 → 새로 만들기 → 파일에서 가져오기로 이동합니다.
  3. 3다운로드된 automatically-save-organize-line-message-files-in-google-drive-with-sheets-logging 파일을 선택하고 가져오기를 클릭합니다.
  4. 4각 서비스 노드에 대한 자격 증명(API 키, OAuth 등)을 설정합니다.
  5. 5워크플로 테스트를 클릭하여 모든 것이 작동하는지 확인한 후 활성화합니다.

또는 n8n → JSON에서 가져오기에 직접 붙여넣기:

{ "name": "Automatically Save & Organize LINE Message Files in Google Drive with Sheets Logging", "nodes": [...], ...}

통합

codegoogledrivegooglesheetshttprequestifmergewebhook

이 워크플로 가져오기

한 번의 클릭으로 다운로드 및 가져오기

JSON 다운로드n8n.io에서 보기
노드23
복잡도high
트리거webhook
조회수2,911
카테고리File Management

제작자

Jaruphat J.

Jaruphat J.

@jaruphatj

태그

codegoogledrivegooglesheetshttprequestifmergewebhook

n8n을 처음 사용하시나요?

n8n은 무료 오픈소스 워크플로 자동화 도구입니다. 자체 호스팅하거나 클라우드 버전을 사용하세요.

n8n 무료로 시작하기 →

Related File Management Workflows

COCOGOHT+5
medium

Sync SharePoint to Google Drive via Supabase (n8n Workflow)

Eliminate manual file transfers and data silos with this enterprise-grade synchronization pipeline. This n8n workflow automates the heavy lifting of mirroring your Microsoft SharePoint document libraries to Google Drive while maintaining a robust audit trail in Supabase or Postgres. Designed for high-reliability environments, the automation utilizes a sophisticated delta-check logic: it fetches SharePoint metadata, compares it against your existing database records using the 'Compare Datasets' node, and identifies only new or modified files for processing. By leveraging the 'Split in Batches' node, the system handles large volumes of data without hitting memory limits, ensuring every document is securely downloaded via HTTP and re-uploaded to its destination. Once the transfer is verified, the workflow updates your database status in real-time, providing a transparent log of your synchronization history. This is an essential solution for organizations transitioning between cloud ecosystems or those requiring a redundant, cross-platform backup strategy. It effectively bridges the gap between Microsoft and Google ecosystems using Supabase as a high-performance state-management layer. **Common Use Cases:** - Automated Multi-Cloud Disaster Recovery: Maintain a real-time mirror of critical SharePoint corporate assets in Google Drive to ensure business continuity during service outages. - Cross-Departmental Collaboration: Automatically sync project documentation from an executive SharePoint site to a creative team's Google Drive folder for seamless cross-platform access. - Centralized Document Auditing: Use Supabase to track every file movement between ecosystems, creating a searchable metadata index for compliance and regulatory reporting.

Scheduled·15 nodes
FOGOGOHT+2
medium

Automate Threads Video Backups to Google Drive & Sheets

Streamline your social media asset management with this robust n8n automation designed for digital marketers and content creators. This workflow eliminates the manual effort of downloading Threads content by providing a seamless bridge between Instagram's text-based platform and your cloud storage. Once triggered via a simple form input, the automation utilizes a RapidAPI connection to fetch high-quality video assets, processes the binary data, and securely uploads the file to a designated Google Drive folder. Simultaneously, the workflow maintains a centralized audit log in Google Sheets, capturing essential metadata such as timestamps and file IDs. Built-in logic gates and wait nodes ensure API rate limits are respected and file transfers are verified before logging. This is an essential tool for agencies managing high volumes of social content who need a reliable, automated pipeline for content repurposing, archival compliance, or collaborative review processes. By centralizing your Threads media assets, you ensure your creative team has instant access to raw footage without the friction of manual downloads. **Common Use Cases:** - Automated Social Media Content Archiving for Compliance - Centralized Asset Library Syncing for Creative Agencies - Competitor Research and Video Content Benchmarking

Trigger·9 nodes