This n8n workflow automates the monitoring of pharmacy inventory levels and expiry dates, ensuring timely alerts for low stock and near-expiry medicines. It triggers daily at 9 AM via a cron node, then fetches current stock data from a Google Sheet. The data is processed to identify medicines with stock levels below a defined threshold and those nearing expiry within 30 days. Alerts are summarized and stored back into the Google Sheet. Finally, an email notification is sent to the pharmacist detailing low stock items and near-expiry or expired medicines. This automation helps pharmacy staff maintain optimal inventory, prevent stockouts, and ensure drug safety.