Add a Contract Renewal Status Label to Your Spreadsheet
Use this prompt after building the Days Until Renewal column to add a plain-English status label to each client row, turning the spreadsheet into a scannable renewal dashboard.
The Prompt
In the same Google Sheet, write a formula for column F that returns: - "🔴 Renew Now" if Days Until Renewal (column E) is 30 or fewer - "🟡 Start Conversation" if Days Until Renewal is 31–60 - "🟠 Schedule Check-in" if Days Until Renewal is 61–90 - "✅ On Track" if Days Until Renewal is more than 90 - "⚠️ Lapsed" if Days Until Renewal is negative
From the guide
Using AI to build a simple contract renewal reminder system from your existing client list so nothing slips through without a follow-up →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.