AutomationFlowsData & Sheets › Automatic Pantry Inventory Management with Notion and Email Notifications

Automatic Pantry Inventory Management with Notion and Email Notifications

ByShelly-Ann Davy @SheCodesFlow on n8n.io

Your pantry’s calm concierge. Each evening it checks your Notion Pantry for items at or below your Reorder Level, adds tidy rows to Grocery List, and sends a pretty summary email you can shop from. ✨🛒

Cron / scheduled trigger★★★★☆ complexity15 nodesNotionEmail SendError Trigger
Data & Sheets Trigger: Cron / scheduled Nodes: 15 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #7918 — we link there as the canonical source.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "name": "Pantry Soft-Stock Refill \u2014 Notion \u2192 Grocery List + Email",
  "nodes": [
    {
      "id": "1",
      "name": "Daily Trigger",
      "type": "n8n-nodes-base.cron",
      "position": [
        260,
        360
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "2",
      "name": "User Config",
      "type": "n8n-nodes-base.set",
      "position": [
        260,
        220
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "3",
      "name": "Get Pantry Items",
      "type": "n8n-nodes-base.notion",
      "position": [
        540,
        360
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "4",
      "name": "Get Existing To Buy",
      "type": "n8n-nodes-base.notion",
      "position": [
        540,
        540
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "5",
      "name": "Compute To-Buy List",
      "type": "n8n-nodes-base.function",
      "position": [
        820,
        450
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "6",
      "name": "Create in Grocery List",
      "type": "n8n-nodes-base.notion",
      "position": [
        1100,
        450
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "7",
      "name": "Compose Email",
      "type": "n8n-nodes-base.function",
      "position": [
        1380,
        450
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "8",
      "name": "Send Email",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        1640,
        450
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "9",
      "name": "Error Handler",
      "type": "n8n-nodes-base.errorTrigger",
      "disabled": true,
      "position": [
        260,
        700
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "10",
      "name": "## Description",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        100,
        60
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "11",
      "name": "## Setup Checklist",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        100,
        220
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "12",
      "name": "## Demo & Gallery",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        100,
        380
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "13",
      "name": "## QA / Test Plan",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        100,
        540
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "14",
      "name": "## Tags & Category",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        100,
        700
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "15",
      "name": "## Attribution & License",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        100,
        860
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {},
  "versionId": "1.0.0",
  "staticData": null,
  "connections": {
    "User Config": {
      "main": [
        [
          {
            "node": "Get Pantry Items",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get Existing To Buy",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Compose Email": {
      "main": [
        [
          {
            "node": "Send Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Trigger": {
      "main": [
        [
          {
            "node": "User Config",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Pantry Items": {
      "main": [
        [
          {
            "node": "Compute To-Buy List",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Compute To-Buy List": {
      "main": [
        [
          {
            "node": "Create in Grocery List",
            "type": "main",
            "index": 0
          },
          {
            "node": "Compose Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Existing To Buy": {
      "main": [
        [
          {
            "node": "Compute To-Buy List",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Your pantry’s calm concierge. Each evening it checks your Notion Pantry for items at or below your Reorder Level, adds tidy rows to Grocery List, and sends a pretty summary email you can shop from. ✨🛒

Source: https://n8n.io/workflows/7918/ — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Data & Sheets

Plan a full week of scroll-stopping pins in under two minutes! 🚀

Notion, Email Send, Error Trigger
Data & Sheets

A warm, reliable onboarding system for small businesses and studios. Captures a form submission via webhook, creates a Client record in Notion, sends a concierge-style welcome email (with scheduler +

Notion, Email Send, Telegram +4
Data & Sheets

Every Gumroad sale becomes a gentle, on-brand experience: instant delivery 💌, a Day-3 check-in 🌷, and a Day-7 1-click testimonial ⭐ — all saved to Notion for your “Wall of Love.” Install in \~15 minut

Notion, Email Send, Error Trigger
Data & Sheets

This n8n workflow automatically tracks assignment deadlines and sends reminders to students and teachers. It checks for upcoming assignments daily, organizes the data, and sends email notifications to

Notion, Email Send, Item Lists
Data & Sheets

This template is designed for social media managers, content creators, data analysts, and anyone who wants to automatically save and analyze their Meta Threads posts in Notion.

HTTP Request, Notion