LINE Study Image Analysis with Gemini + Google Sheets Automation

Turn LINE study screenshots into automated feedback—Gemini + Google Sheets included

This n8n workflow receives student study result images sent via the LINE Messaging API, uses Google Gemini to extract key learning details, stores them in Google Sheets, analyzes the student’s history for weaknesses, and then replies with targeted review advice back in LINE.

What this workflow does

• Receives LINE messages through a POST webhook when a user sends a message via the LINE Messaging API.
• Detects image messages and downloads the image content from LINE.
• Extracts study data with Google Gemini to capture: Subject, Topic, Score, Weak Points, and short Review Advice.
• Saves results to Google Sheets by appending a study record that includes the LINE user ID and timestamp to your chosen worksheet.
• Builds learning history by looking up the same user’s past study records from Google Sheets and aggregating them into a single history payload.
• Analyzes trends with Gemini to generate: learning trends, recurring weak points, review priorities, next actions, and three review questions.
• Replies in LINE with the analysis and the generated review questions.

Use cases

• Automate review planning for students who submit quiz/test result screenshots in LINE.
• Create an “AI Study Review Tracker” using Google Sheets as the single source of truth for study history.
• Help educators or SaaS operators deliver personalized practice prompts without manual note-taking.

Technical details

• LINE Messaging API: webhook entry point + authenticated image download and LINE reply requests (HTTP Header Auth / Bearer token).
• Google Gemini (PaLM): extracts structured fields from the image and summarizes study history into actionable review content.
• Google Sheets: appends extracted study records and retrieves past records for each LINE user.
• n8n nodes / building blocks: filter, webhook, aggregate, sticky note, HTTP Request, Google Sheets.

Ideal for n8n users, automation engineers, and SaaS operators looking for a practical LINE + Gemini + Google Sheets automation that turns images into closed-loop study feedback.