{"product_id":"line-study-image-analysis-with-gemini-google-sheets-automation","title":"LINE Study Image Analysis with Gemini + Google Sheets Automation","description":"\u003ch3\u003eTurn LINE study screenshots into automated feedback—Gemini + Google Sheets included\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives student study result images sent via the \u003cstrong\u003eLINE Messaging API\u003c\/strong\u003e, uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to extract key learning details, stores them in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, analyzes the student’s history for weaknesses, and then replies with targeted review advice back in \u003cstrong\u003eLINE\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives LINE messages\u003c\/strong\u003e through a POST \u003cem\u003ewebhook\u003c\/em\u003e when a user sends a message via the LINE Messaging API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects image messages\u003c\/strong\u003e and downloads the image content from LINE.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts study data with Google Gemini\u003c\/strong\u003e to capture: \u003cem\u003eSubject\u003c\/em\u003e, \u003cem\u003eTopic\u003c\/em\u003e, \u003cem\u003eScore\u003c\/em\u003e, \u003cem\u003eWeak Points\u003c\/em\u003e, and short \u003cem\u003eReview Advice\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves results to Google Sheets\u003c\/strong\u003e by appending a study record that includes the \u003cstrong\u003eLINE user ID\u003c\/strong\u003e and \u003cstrong\u003etimestamp\u003c\/strong\u003e to your chosen worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds learning history\u003c\/strong\u003e by looking up the same user’s past study records from Google Sheets and aggregating them into a single history payload.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnalyzes trends with Gemini\u003c\/strong\u003e to generate: learning trends, recurring weak points, review priorities, next actions, and \u003cstrong\u003ethree review questions\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReplies in LINE\u003c\/strong\u003e with the analysis and the generated review questions.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate review planning for students who submit quiz\/test result screenshots in LINE.\u003c\/li\u003e\n  \u003cli\u003eCreate an “AI Study Review Tracker” using Google Sheets as the single source of truth for study history.\u003c\/li\u003e\n  \u003cli\u003eHelp educators or SaaS operators deliver personalized practice prompts without manual note-taking.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLINE Messaging API\u003c\/strong\u003e: webhook entry point + authenticated image download and LINE reply requests (HTTP Header Auth \/ Bearer token).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini (PaLM)\u003c\/strong\u003e: extracts structured fields from the image and summarizes study history into actionable review content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: appends extracted study records and retrieves past records for each LINE user.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ building blocks\u003c\/strong\u003e: \u003cem\u003efilter\u003c\/em\u003e, \u003cem\u003ewebhook\u003c\/em\u003e, \u003cem\u003eaggregate\u003c\/em\u003e, \u003cem\u003esticky note\u003c\/em\u003e, \u003cem\u003eHTTP Request\u003c\/em\u003e, \u003cem\u003eGoogle Sheets\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eIdeal for n8n users, automation engineers, and SaaS operators looking for a practical \u003cstrong\u003eLINE + Gemini + Google Sheets automation\u003c\/strong\u003e that turns images into closed-loop study feedback.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46164182499507,"sku":"N8N-20508","price":11.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Xs5BaADlIUnYKAK_Vw1VZ_OA8UgAnm.png?v=1791277668","url":"https:\/\/buyflowscripts.com\/products\/line-study-image-analysis-with-gemini-google-sheets-automation","provider":"N8N Commerce","version":"1.0","type":"link"}