Line Save File to Google Drive and Log File's URL

• Developers: Individuals looking to automate file uploads from LINE to Google Drive.
• Business Professionals: Those who need to manage and store files efficiently based on date and type.
• Content Creators: Users who frequently share files and need a systematic way to log and access them.
• Team Collaborators: Teams working with shared files who require organized storage solutions in Google Drive.

This workflow automates the process of saving files sent via LINE to Google Drive, categorizing them based on date or file type. It eliminates manual file management, reduces errors, and ensures that important files are easily accessible and logged correctly in Google Sheets.

1. LINE Webhook Listener: Receives incoming file messages from LINE.
2. Get Config: Retrieves configuration details from Google Sheets, such as allowed file types and folder paths.
3. Merge Event and Config Data: Combines event data with configuration settings for further processing.
4. Determine Folder Info: Calculates folder names based on the configuration, deciding whether to store files by date or type.
5. Search Date Folder: Checks if a folder for the current date already exists.
6. Check Existing Date Folder: Validates the existence of the date folder and creates one if necessary.
7. Search File Type Folder: Looks for a folder specific to the file type.
8. Check Existing File Type Folder: Similar to date folder checks, it verifies or creates the file type folder.
9. Upload File to Google Drive: Once validated, the file is uploaded to the determined folder.
10. Log File Details to Google Sheet: Records the file's metadata including name, type, upload date, and Google Drive URL.
11. Check Reply Enabled Flag: Determines if replies are enabled in the configuration.
12. Send LINE Reply Message: Sends a confirmation or error message back to the user on LINE, providing the file's URL or an error description.