Inventory Check Automation.json

The Inventory Check Automation is an automated system designed to monitor stock levels weekly and use AI to send professional low-stock alerts to the procurement team.

1. Data Retrieval & Filtering

• Schedule: The workflow triggers automatically every Monday at 9:00 AM.
• Inventory Scan: It retrieves current stock data from a Google Sheet titled "Copy of Inventory_Data_Sample".
• Smart Filter: The system automatically filters for items where the current Stock is less than the pre-defined Threshold.

2. AI Analysis

• Data Aggregation: All low-stock items are grouped together and passed to an AI Agent powered by Google Gemini.
• Professional Formatting: The AI acts as an "Inventory Control Assistant" to format the data into a clear list. It specifically:
  • Identifies the item name, remaining stock, and the required threshold.
  • Recommends the specific Supplier for reordering.
  • Flags items as "Out of stock" if the quantity is zero.

3. Automated Notification

• Gmail Alert: Once the AI generates the summary, it uses a specialized Gmail tool to send a "Low stock alert!" email to the designated recipient (test@gmail.com).