Manage fridge inventory and expiry alerts with LINE, Google Sheets and Gemini
Ready for 3.0What 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).
- Fetch LINE Image (HTTP Request): calls an HTTP API
- Read Inventory in Sheets (Google Sheets): uses Google Sheets
- Food Info Extraction Agent (AI Agent): runs an AI agent, with model: Gemini Image Reading Model
- Filter: keeps only the items that match a condition
- Append Food to Sheets (Google Sheets): append
- Collect Expiring Ingredients (Aggregate): combines items into one
- Reply to LINE Registration (HTTP Request): calls api.line.me (POST)
- Meal Suggestion Agent (AI Agent): runs an AI agent, with model: Gemini Meal Suggestion Model
- Notify LINE on Expiry (HTTP Request): calls api.line.me (POST)
Services it uses
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)
- Webhook
n8n-nodes-base.webhook - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Filter
n8n-nodes-base.filter - Aggregate
n8n-nodes-base.aggregate - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini
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…