Before you start
A prospect sheet, three texts and instructions so an AI chat drafts each morning's follow-ups. You approve every one before it goes out.
- Cost: $0.
- Time: 15 minutes to set up; 5 minutes each morning.
- Accounts: a free AI chat (ChatGPT, Claude or Gemini) and a spreadsheet (Google Sheets, Excel or Numbers). You send from your usual business phone.
- Files:
prospect-sheet.xlsxandinstructions-to-paste.md.
The sequence
| Text | When | Why |
|---|---|---|
| 1 · The question | 2 days after the quote | Clear up whatever stopped the decision |
| 2 · Something useful | 7 days after | One thing that helps them decide, no pressure |
| 3 · The friendly close | 14 days after | Close without pushing and leave the door open |
Three max. Anyone who says no, buys, texts STOP or doesn't answer the third comes off the list.
The 5 steps
- Open the sheet. Upload
prospect-sheet.xlsxto Google Sheets (File → Import) or open it in Excel. Look at the samples, then delete them. - Add everyone who asked for a quote. One row per person: name, what they asked for, price, quote date, what they said, and whether they agreed to get texts. If they didn't, you don't text them.
- Paste the instructions. In a new chat, paste the text from
instructions-to-paste.md(fill in the brackets) and, below it, the Prospects tab and today's date. - Approve every text. The chat shows who's due today and the text for each. Answer "yes," "no" or "change it like this." Whatever you approve, you send from your phone and add 1 to "Texts sent."
- Log the replies. If someone answers, paste the reply into the chat: it tells you which Status to set. "No thanks," "stop texting me" or STOP = Said no.
How to know it worked
With the sample sheet and "Today is 11/17/2026," it drafts texts only for Laura (1), Diego (2) and Carmen (3), and explains why Andrew, Rose and Tom don't get one. The sheet shows the same in the "Due today?" column.
If it fails, check this
- Texts someone who said no: that row's Status has to say exactly "Said no."
- Gets the days wrong: write today's full date (month/day/year) and keep the sheet's dates in the same format.
- Offers discounts or makes up urgency: paste the full instructions again; the HOW YOU WRITE section has to be there.
- "Due today?" is blank: make sure the quote date is a date, not text.
Before you automate the sending
This version is manual on purpose: the chat drafts, you send. Before you connect it to a texting platform, check the rules for business texting in the US (consent, opt-out with STOP, quiet hours): they vary and we haven't verified them for your state. Keep the approval step either way.
What it doesn't do
- It doesn't send anything: you approve and send.
- No discounts, no price changes, no promised dates.
- It never texts anyone who didn't agree to texts or who said no.
- Complaints or questions it can't answer: it hands them to you.
Did it work?
When it works, reply DONE to the message where you got this.
That one word tells us which material helps and which one needs to come down a rung.
Annex AInstructions to paste: follow up with everyone who said "let me think about it"
Copy everything inside the box and paste it into your AI chat. Replace what's in brackets. Below it, paste the Prospects tab from your sheet and today's date.
You are the follow-up AI employee for [your business name]. Your name is [name]. Your job: draft follow-up texts for people who asked for a quote and said "let me think about it." You don't send anything: [your name] approves every text and sends it.
WHAT I GIVE YOU EACH DAY
The prospects table (pasted below) and today's date.
WHO'S DUE TODAY
Only rows that meet all of this:
- Status = Open.
- OK to text? = Yes.
- Texts sent: 0, 1 or 2.
- Due by the sequence: text 1 two days after the quote, text 2 seven days after, text 3 fourteen days after. If that date has passed, they're due today.
Never text anyone who said no, bought, didn't agree to texts, texted STOP, or already got 3. If you're not sure, don't text them and ask me.
THE SEQUENCE
- Text 1, the question: ask if they have any questions about what they asked for. Offer something concrete (photos, measurements).
- Text 2, something useful: one thing that helps them decide, no pressure. Use the row's "Note" if it says something.
- Text 3, the friendly close: say you won't text again about it and leave the door open.
HOW YOU WRITE
- Short: two sentences max. Use their first name and name what they asked for.
- No discounts, no new prices, no "only a few left," no made-up urgency. Don't promise delivery dates.
- Introduce yourself once: "It's [name] from [your business name]."
HOW YOU HAND THEM TO ME
A list with: name, text number (1, 2 or 3), the text ready to copy, and the question "Send it? (yes / no / change…)". At the end, who doesn't get a text today and why, one line each.
When I answer "yes," tell me what to change in the sheet: add 1 to "Texts sent."
WHEN SOMEONE REPLIES
If I paste a prospect's reply, tell me which Status to set: "Replied" if they want to keep talking (and hand the case to me), "Said no" if they're not interested, ask not to be texted or text STOP, "Bought" if they bought. If they complain or ask something you don't know, hand it to me: don't answer it yourself.
PROSPECTS AND TODAY'S DATE
[paste the Prospects tab here]
Today is [date].
Test it with the sample sheet
Paste the sample table and write "Today is 11/17/2026". It should draft three texts:
| Person | Text | Why |
|---|---|---|
| Laura | 1 · the question | Quoted 3 days ago and hasn't gotten any. |
| Diego | 2 · something useful (mentions the color) | Got 1 text and it's been 8 days. |
| Carmen | 3 · the friendly close | Got 2 texts and it's been 15 days. |
And nothing for Andrew (said no), Rose (didn't agree to texts) or Tom (quoted yesterday: due 11/18).
Annex BFiles to download
Direct downloads. Sample data is fictional.
Blackcircuit Labs. Fictional sample data. Tested on Nov 17, 2026 on ChatGPT's free plan (temporary chat) with the sample sheet; sheet opened in Google Sheets (formulas check out).