Automatic Pantry Inventory with Notion & Email Alerts

This workflow acts as a smart pantry manager, running daily via Cron at 6pm to scan your Notion 'Pantry' database for items at or below their Reorder Level. It calculates the required quantity to replenish (ReorderLevel - Quantity, min 1), adds new entries to your 'Grocery List' database with status 'To Buy', and compiles a polished email summary listing items needed or confirming full stock.

Perfect for busy households, home managers, or small business owners tracking supplies, it eliminates manual checks and surprise shortages. Integrates seamlessly with Notion for structured data and email for actionable notifications, saving hours weekly on inventory tasks.

Setup requires Notion databases for Pantry (Name, Quantity, ReorderLevel, Notes) and Grocery List (Item, Qty, Status, Source, Notes), plus n8n credentials. Customize Cron timing, add CCs, or extend with Telegram for urgents. Test with a low-stock item to verify grocery row creation and email delivery.

Benefits include proactive restocking, automated tracking with 'Source: Auto', and a clean, readable email checklist—turning chaotic pantries into self-managing systems.