Automatic Pantry Inventory Refill & Email Notification - n8n Workflow

• Individuals or families using Notion for home organization and inventory tracking.


• Users seeking pre-built n8n templates for home automation.


• Automation experts who need a reliable, scheduled n8n trigger for daily tasks.


• Anyone who wants to prevent running out of household essentials by automating stock checks.

Keeping track of pantry inventory manually is tedious and often leads to running out of essential items. This robust n8n workflow solves this problem by providing a 'soft-stock refill' automation loop. Using a powerful n8n trigger, the system wakes up daily, checks your Notion pantry inventory database for items marked 'low stock,' compares this against your existing grocery list (also in Notion) to avoid duplicates, and then automatically creates new entries for needed items. Finally, it uses an Email Send n8n node to notify you of the required purchases, transforming a manual chore into a fully automated process. This specific n8n workflow is a fantastic example of using multiple n8n node types for complex data processing.

The entire process is initiated by the Daily Trigger n8n node, which acts as a scheduled n8n trigger.

1. Initialization: The n8n workflow starts with the Daily Trigger (a Cron n8n node), running on a set schedule.


2. Configuration: The User Config Set n8n node defines critical parameters like Notion database IDs and recipient email addresses.


3. Data Retrieval (Parallel): The workflow simultaneously queries two Notion databases using Notion n8n nodes: Get Pantry Items retrieves the full inventory (filtered for low stock), and Get Existing To Buy retrieves the current grocery list items.


4. Core Logic: The Compute To-Buy List Function n8n node is where the magic happens. It compares the two lists to determine which low-stock items are not yet on the grocery list, thereby eliminating duplicates. This logic step is crucial for efficiency in this specific n8n workflow.


5. Notion Update: The Create in Grocery List Notion n8n node adds the newly computed missing items to your Notion Grocery List database.


6. Notification Preparation: The Compose Email Function n8n node formats the list of newly added items into a readable email body.


7. Final Action: The Send Email n8n node delivers the summarized grocery list notification to the specified user, completing the daily automated check.

To deploy this n8n workflow template, follow these steps:

1. Import: Copy the provided JSON data and import it directly into your n8n instance via the 'Workflows' screen using the 'New' button and selecting 'Import from JSON'.


2. Notion Credentials: You will need to set up a Notion credential. This n8n workflow requires permissions to read and write to at least two Notion databases (Pantry Inventory and Grocery List).


3. Email Credentials: Configure the Send Email n8n node with the appropriate SMTP or custom email service credentials to allow n8n to send notifications.


4. Configuration Node: Update the User Config Set n8n node with your specific Notion database IDs and the email address where you want to receive notifications.


5. Activate: Ensure the Daily Trigger n8n trigger is configured to run at your desired time and then activate the n8n workflow.

Daily Trigger (Cron n8n node): This is the scheduled n8n trigger that dictates when the entire n8n workflow executes, ensuring daily inventory checks.
User Config (Set n8n node): Used to centralize configuration data, such as database IDs and email settings, making this n8n workflow highly reusable and easy to manage.
Get Pantry Items (Notion n8n node): Queries the main Notion database, filtering for items that have reached the predefined 'low stock' threshold.
Get Existing To Buy (Notion n8n node): Queries the target Grocery List Notion database to retrieve items already slated for purchase, preventing duplicate entries.
Compute To-Buy List (Function n8n node): This custom code n8n node runs the core deduplication logic, comparing incoming low-stock items with existing to-buy items to generate the final refill list.
Create in Grocery List (Notion n8n node): Creates new pages in the Notion Grocery List database for all items identified as needed by the previous Function n8n node.
Compose Email (Function n8n node): Prepares the output from the list creation into a clean, readable message body suitable for the final notification.
Send Email (EmailSend n8n node): The final action n8n node, responsible for sending the automated grocery list notification to the user.