Filter Inactive Customers in Google Sheets
Use this when you have a customer list exported from your sales or booking system and need to isolate customers who haven't purchased in the last six months, without knowing how to write spreadsheet formulas yourself.
The Prompt
I have a spreadsheet in Google Sheets with customer names in column A and last purchase dates in column D. Show me step-by-step how to filter so I only see customers whose last purchase was more than 180 days ago.
From the guide
Using AI to build a simple re-engagement campaign for customers who haven't bought from you in six months or more →Related Prompts
Revise a Scope of Work After Filling In Gaps
Use this as a follow-up prompt in the same conversation after reviewing the ambiguities list the AI returned in the first pass. Paste in your answers to each flagged gap before finalizing the SOW draft.
Draft a Client Scope of Work from a Raw Brief
Use this prompt at the start of a new client project to generate a full scope of work document from a raw client email or brief. Paste it into Claude or ChatGPT after collecting your client inputs, verbal notes, and standard terms.
Extract Action Items from Recurring Team Meeting Transcripts
Use this enhanced version of the extraction prompt for recurring meetings like weekly standups or client check-ins. The added context line prevents completed tasks from last week from being re-listed as new assignments, and the extra rule biases uncertain decisions toward Unresolved Items.
Extract Action Items and Decisions from Meeting Transcript
Use this prompt after exporting a speaker-labeled transcript from Zoom, Fathom, or any meeting recording tool. Paste this prompt at the top of a new chat, then paste the full transcript immediately below it to extract structured action items, decisions, and unresolved items.