Google Apps Script Email Alert for Low Stock Items
Use this prompt to generate the Google Apps Script code that sends a daily email alert listing any SKUs at or below their reorder point. Replace [your email address] with your actual email before pasting the returned code into the Apps Script editor.
The Prompt
Write a Google Apps Script function for a Google Sheet named "Inventory Reorder Tracker." The sheet has columns in this order: A = SKU Name, B = Current Stock, E = Reorder Point, F = Alert Status. The function should: (1) loop through all rows with data starting at row 2, (2) check if the value in column B is less than or equal to the value in column E, (3) if true, collect those SKU names and stock levels, and (4) send a single summary email to [your email address] with a list of all items needing reorder. Include a trigger setup so this runs every morning at 8am.
From the guide
Using AI to build a simple inventory reorder alert system from your spreadsheet so you stop running out of stock at the worst time →Related Prompts
Turn Your Rate Card Into a Client Proposal
Use this as your master reusable proposal prompt after every sales call. Paste your rate card and five post-call notes into the bracketed fields to generate a complete, client-ready proposal draft in under two minutes.
Fix Unclear Task Names in AI Digest Output
Add this line to your weekly digest prompt when your task data includes internal shorthand, ticket IDs, or abbreviations that the AI may misread or misrepresent in the output.
Generate a Weekly Team Task Digest Email
Use this prompt after exporting your task list from a project tool like Asana, ClickUp, Trello, or a Google Sheet. Paste the task data above this prompt, then run it in ChatGPT, Claude, or Gemini to generate a formatted weekly team digest email ready to send before Monday morning.
Format Rough Shift Notes Into a Clean Handover Message
Use this prompt at the end of every shift to convert a manager's rough, unstructured end-of-shift notes into a clean, categorised handover note that matches your template. Takes under 90 seconds and produces an auditable, readable note ready to send to the incoming team.