Inventory Check Automation

An automated weekly inventory auditing system built with n8n, Google Gemini, and Google Sheets. This workflow checks stock levels, identifies items below their threshold, generates an AI‑crafted alert message, and emails a consolidated low‑stock report. It removes manual review, reduces errors, and ensures timely restocking decisions.

---

Features

• Automated weekly inventory checks (every Monday at 9 AM)
• Google Sheets integration for real‑time inventory data
• AI‑generated low‑stock alert message using Google Gemini
• Consolidated reporting for all low‑stock items
• Gmail integration for automated email delivery
• Clean, modular workflow built entirely in n8n

---

Workflow Overview

The system consists of:

1. Schedule Trigger – Runs weekly at a set time
2. Get Rows from Google Sheets – Retrieves inventory data
3. Filter – Keeps only items where stock < threshold
4. Aggregate – Combines all low‑stock items
5. AI Agent – Generates a structured alert message
6. Google Gemini Chat Model – LLM processing
7. Simple Memory – Short‑term context
8. Gmail Node – Sends the final alert email

Full documentation is available in:
docs/workflow-overview.md

---

Project Structure

inventory-check-automation/
  docs/
    workflow-overview.md
  workflows/
    inventory-check-automation.json
  assets/
    inventory-demo.mp4
    inventory-check-automation.png
    low_stock_alerts.png
  .gitignore
  README.md

---

Requirements

• n8n
• Google Gemini API key
• Google Sheets OAuth2 credentials
• Gmail OAuth2 credentials
• A Google Sheet containing:
  • Item
  • Stock
  • Threshold
  • Supplier

---

Setup Instructions

1. Import the workflow JSON into n8n
2. Reconnect your Google Sheets credentials
3. Reconnect your Gemini API key
4. Reconnect your Gmail OAuth2 credentials
5. Update the spreadsheet ID and sheet name if needed
6. Activate the workflow

---

Example Output

⚠️ Low Stock Alert:
- Tomato Sauce: 2 left (need 5). Recommend reordering from FreshFoods Co.
- Napkins: Out of stock (need 20). Recommend reordering from SupplyHub.

---

License

MIT License

---