Organize handwritten memos from LINE using Gemini OCR, Drive and Sheets

Description

AI Handwritten Memo Organizer – Overview
This workflow receives handwritten memo images sent via LINE and automatically extracts, summarizes, and organizes the content using AI.

Step-by-step process:
User sends a handwritten memo image via LINE
Webhook receives the image
Immediate reply is sent: “Processing…”
Image is saved to Google Drive
AI performs OCR and generates structured data (title, category, summary, tags)
The JSON response is safely parsed with error handling
OCR failure is detected if text cannot be properly extracted
If OCR fails:
→ User is notified with guidance for retaking the image
If OCR succeeds:
→ Check if the category sheet exists in Google Sheets
→ If not, create a new sheet
→ Save the data (title, summary, tags, date, image URL)
Completion message is sent to the user via LINE

Setup Steps
Create a LINE Messaging API channel and obtain the Channel Access Token
Create a Google Spreadsheet for storing memo data
Create a Google Drive folder to store uploaded images
Set the following values in the Config node:
o LINE_ACCESS_TOKEN
o GOOGLE_SHEETS_ID
Set the Webhook URL in the LINE Developers Console