{"product_id":"line-fridge-inventory-expiry-alerts-with-n8n-sheets-gemini","title":"LINE Fridge Inventory \u0026 Expiry Alerts with n8n, Sheets, Gemini","description":"\u003ch3\u003eRegister fridge items in LINE—then get AI meal ideas for what expires soon\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow lets users snap a food\/package image in LINE, automatically extracts the item details with Google Gemini, saves them to Google Sheets, and sends a daily LINE notification with short Japanese meal suggestions for items expiring within the next three days.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eReceives LINE webhook events:\u003c\/b\u003e When a user sends a message containing a food package image, n8n handles the incoming POST webhook from the \u003cb\u003eLINE Messaging API\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDownloads the image from LINE:\u003c\/b\u003e The workflow retrieves the image content using the LINE endpoints configured via HTTP Header Auth.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eExtracts inventory details with Google Gemini:\u003c\/b\u003e The image is sent to \u003cb\u003eGoogle Gemini\u003c\/b\u003e to extract a fixed text set of fields, including \u003cb\u003efood name\u003c\/b\u003e, \u003cb\u003eexpiration date\u003c\/b\u003e, \u003cb\u003estorage location\u003c\/b\u003e, and \u003cb\u003enotes\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSaves to Google Sheets inventory:\u003c\/b\u003e The extracted details are appended to a Google Sheets table with \u003cb\u003eIn Stock\u003c\/b\u003e status, a registration timestamp, and the originating \u003cb\u003eLINE user ID\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eConfirms registration in LINE:\u003c\/b\u003e The workflow replies back in LINE, confirming the registration and echoing the stored item details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns daily expiry checks (09:00):\u003c\/b\u003e Every day at \u003cb\u003e9:00\u003c\/b\u003e, it reads the sheet, filters \u003cb\u003eIn Stock\u003c\/b\u003e items expiring between today and the next three days, aggregates the results, and uses \u003cb\u003eGoogle Gemini\u003c\/b\u003e to generate short \u003cb\u003eJapanese meal suggestions\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends push notifications in LINE:\u003c\/b\u003e The suggestions are delivered via a LINE push notification.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003ePersonal fridge management: keep track of what you have without manual entry.\u003c\/li\u003e\n  \u003cli\u003eShared household inventory: notify family members in LINE when food is nearing expiry.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators and automation engineers: demonstrate AI-assisted inventory + reminders using n8n, Sheets, and Gemini.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003en8n nodes\/workflow components:\u003c\/b\u003e webhook, http request, google sheets, filter, aggregate, sticky note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations:\u003c\/b\u003e \u003cb\u003eLINE Messaging API\u003c\/b\u003e (reply + push endpoints), \u003cb\u003eGoogle Gemini\u003c\/b\u003e, and \u003cb\u003eGoogle Sheets\u003c\/b\u003e (OAuth2).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCore scheduling:\u003c\/b\u003e daily execution at \u003cb\u003e09:00\u003c\/b\u003e to evaluate expirations and trigger notifications.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46066356125875,"sku":"N8N-19754","price":37.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/41OuZjGDn77yu9yKjvtuc_ubG2hRTK.png?v=1789894935","url":"https:\/\/buyflowscripts.com\/products\/line-fridge-inventory-expiry-alerts-with-n8n-sheets-gemini","provider":"N8N Commerce","version":"1.0","type":"link"}