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
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.