Auto-Email Inventory Reorder Alerts from Google Sheets
Use this prompt to generate a working Google Apps Script that automatically emails you when any inventory item falls below its reorder point. Paste it into Claude, ChatGPT, or Gemini after setting up your spreadsheet columns.
The Prompt
I use Google Sheets to track inventory. My spreadsheet has these columns: Column A = Product Name, Column B = Current Stock (number), Column C = Reorder Point (number), Column D = Supplier. I want a Google Apps Script that checks every row starting at row 2. If the value in Column B is less than the value in Column C, I want it to send an email to [your email address] with a subject line of "Reorder Alert" and a body that lists each product name and current stock level that triggered the alert. Please write the complete script, ready to paste into Google Apps Script.
From the guide
Using AI to build a simple inventory reorder alert system from a spreadsheet you already use →Related Prompts
Calculate Safety Stock from Supplier Delivery Records
Use this prompt when you have historical supplier delivery dates and want to calculate a more accurate safety stock figure based on real lead time variability rather than averages. Paste your actual order and delivery date records into the chat along with this prompt.
Write a Staff Process Guide from a Brain Dump
Use this prompt after recording and transcribing a spoken brain dump of a recurring task. It converts raw, unstructured notes into a formatted, staff-ready process guide with all seven sections including common mistakes and a completion definition.
Add a Grace Clause to Your Cancellation Policy
Use this follow-up prompt to add a human exception clause to your policy, making it feel fair and judgment-based rather than rigid — which can actually increase client acceptance.
Write a Deposit Request That Sounds Professional Not Punishing
Use this prompt to generate deposit-request language that can accompany your cancellation policy, framing the deposit as normal professional practice rather than a penalty.