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

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