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
Rewrite a Sales Objection Response to Sound Empathetic
Use this prompt after reviewing the draft script and noticing that specific sections feel off in tone. Adapt it by swapping in the actual section or objection you want refined — this example targets a pricing objection that comes across as defensive rather than empathetic.
Build a Team Sales Script from Call Patterns
Run this prompt immediately after the pattern-extraction prompt, in the same conversation. It converts the identified patterns into a structured, table-format script that team members can scan and use mid-call without sales training.
Extract Sales Patterns from Call Transcripts
Use this prompt after pasting one or more transcripts from your best closed-won sales calls. It sets the AI up to analyze patterns across calls rather than just summarize them, surfacing the exact language and turning points that made each call successful.
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.