Parse a Client List into a Renewal Tracker Table
Use this prompt at the start of building your renewal tracker to transform a messy client list — from an email, spreadsheet export, or typed notes — into a clean, structured table ready to paste into Google Sheets.
The Prompt
Here is my client list. Please extract the following fields for each client and return them as a table I can paste into Google Sheets: - Client name - Contract start date - Contract length (in months) - Contract renewal date (calculated from start date + length) - Monthly contract value (if mentioned) - Notes (anything relevant about the account) If any field is missing or unclear, leave it blank and flag it with [MISSING] so I can fill it in manually. Here is my data: [PASTE YOUR CLIENT DATA HERE]
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.