Templates / Manage fridge inventory and expiry alerts with LINE, Google Sheets and Gemini

Manage fridge inventory and expiry alerts with LINE, Google Sheets and Gemini

Ready for 3.0

by AKIKO SASAKI ✓ · 16 views · created 2026-09-20 · Personal Productivity, AI Chatbot

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 13 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Google Sheets and Google Gemini Chat Model. It also calls api.line.me over HTTP.

How it runs

Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).

  1. Fetch LINE Image (HTTP Request): calls an HTTP API
  2. Read Inventory in Sheets (Google Sheets): uses Google Sheets
  3. Food Info Extraction Agent (AI Agent): runs an AI agent, with model: Gemini Image Reading Model
  4. Filter: keeps only the items that match a condition
  5. Append Food to Sheets (Google Sheets): append
  6. Collect Expiring Ingredients (Aggregate): combines items into one
  7. Reply to LINE Registration (HTTP Request): calls api.line.me (POST)
  8. Meal Suggestion Agent (AI Agent): runs an AI agent, with model: Gemini Meal Suggestion Model
  9. Notify LINE on Expiry (HTTP Request): calls api.line.me (POST)

Services it uses

Google SheetsGoogle Gemini Chat Model

HTTP calls to: api.line.me

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (8)

From the author

Quick overview This workflow lets users register fridge items by sending images to LINE, uses Google Gemini to extract item details, saves them to Google Sheets, and runs a daily check to notify users in LINE with AI-generated meal ideas for items expiring…

Excerpt from AKIKO SASAKI's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.