{"product_id":"line-gemini-clean-plate-reward-bot-with-n8n-google-sheets","title":"LINE + Gemini Clean Plate Reward Bot with n8n \u0026 Google Sheets","description":"\u003ch3\u003eTurn Daily “Clean Your Plate” Into a Reward Streak—Automated with LINE, Google Gemini, n8n \u0026amp; Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThe \u003cstrong\u003eLINE + Gemini Clean Plate Reward Bot with n8n \u0026amp; Google Sheets\u003c\/strong\u003e automatically scores your child’s meal photo, generates an encouraging message, and tracks stamps + consecutive-day streaks in Google Sheets—powered end-to-end by an n8n webhook.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives LINE messages via a POST webhook\u003c\/strong\u003e from your LINE bot when a user interacts with the bot.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates message type:\u003c\/strong\u003e if the incoming LINE message is not an image, it replies with clear instructions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads the image from the LINE Messaging API\u003c\/strong\u003e so it can be analyzed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the photo to Google Gemini\u003c\/strong\u003e to judge whether it shows a plate, then:\n    \u003cul\u003e\n      \u003cli\u003ecalculates a \u003cstrong\u003escore\u003c\/strong\u003e for how much was eaten\u003c\/li\u003e\n      \u003cli\u003ecreates a short \u003cstrong\u003epraise message\u003c\/strong\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComputes today’s stamps + streak\u003c\/strong\u003e by reading prior entries from a Google Sheets \u003cstrong\u003e“Log”\u003c\/strong\u003e tab and building a \u003cstrong\u003estamp-card message\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites the result back to Google Sheets\u003c\/strong\u003e, appending: date\/time, score, leftovers, stamps earned, and the comment—then sends the final message back to the child in LINE.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eParents want a fun, consistent “clean plate” reward system without manual tracking.\u003c\/li\u003e\n  \u003cli\u003en8n users\/automation engineers need a practical example of LINE webhook handling + AI scoring + Google Sheets logging.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators building lightweight family or education bots that rely on Google Gemini and structured spreadsheet storage.\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 receiver (POST webhook) and image handling\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini (PaLM)\u003c\/strong\u003e integration to score plate cleanliness and generate praise\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e OAuth2 integration (uses a “Log” tab with columns: Date, Time, Child Name, Clean Plate, Score, Leftovers, Stamps Earned, Comment)\u003c\/li\u003e\n  \u003cli\u003en8n nodes used: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewebhook\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, \u003cstrong\u003ehttp request\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eGet set up\u003c\/strong\u003e by creating a LINE Messaging API channel (enable webhooks, add the Channel access token), adding Gemini and Google Sheets credentials to n8n, creating the “Log” tab sheet, and pasting the n8n webhook URL into the LINE Developers configuration.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45950126981299,"sku":"N8N-19152","price":51.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/qdO_dCWHcCIq9i0vdLly-_gRgAIKjz.png?v=1788513505","url":"https:\/\/buyflowscripts.com\/products\/line-gemini-clean-plate-reward-bot-with-n8n-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}