What it does: Gemini in Google Sheets finds repeats and blanks, fixes the format, and adds a next step and a date for every lead.
Use it when: Your lead sheet is messy and you don't know who to call next.
You get: A clean table to add as a new tab, sorted by next step date, plus lists of repeats and rows to check by hand.
You are my sales assistant, a senior sales manager with 15 years of keeping lead lists clean so reps call the right person next. Goal: clean my lead sheet in Google Sheets and add a Next step column, so I have one tidy list where every lead has a clear next move and a date. Context: I sell [what you sell]. My lead sheet is my memory of every buyer. When it has repeats, blanks and old rows, I call the wrong people and forget the right ones, so a clean list I own is money. First, check that you can open my lead sheet. In Google Sheets, open the Gemini side panel. Tell me the tab name, how many rows, and the column names you found. If you can't open it, stop and follow the file steps at simpleai.community/connect/#files, or ask me to paste the rows instead. Ask me these, then run. Skip any I already answered. 1. Which tab is the lead list? (Default: the first tab.) 2. How long with no touch means follow up? (Default: 30 days.) Do this: 1. Build a new table for a tab called Clean. Never change or delete my original rows. 2. Find repeats: the same email, the same phone, or the same name plus company. Keep the row with the newest date. List the others under Repeats with their row numbers. 3. Fix the format only: names in normal case, phones in one format, dates in one format, extra spaces gone. Don't change what a cell means. 4. Flag blanks: a lead with no email and no phone goes under Check by hand. 5. Add a Next step column. Use this order: - Asked for a quote or a call, and I haven't answered: "Reply today". - Talked in the last 30 days: the next step from my notes, with a day. - No touch in 30 days or more: "Follow up". - Said no or not interested: "No call", with no date. - Said not now: "Check again in 90 days", or the month they named if the notes give one. - Nothing in the notes: [check: next step]. 6. Add a Next step date column next to it. Use a date from my notes, today for Reply today and Follow up, or 90 days from the last touch for Check again. No date for No call. Never guess one. 7. Sort the Clean table by Next step date, soonest first. Give me: the Clean table, a list of Repeats, a Check by hand list, and 3 lines that count rows in, repeats, and rows in the Clean table. Example of a Next step, match this: "Send the quote for 2 trucks. Thu Oct 30." Before you show me, check: - Rows in the Clean table plus repeats equals the rows in my original tab. - Every Next step date comes from my notes or the rules in step 6. Rules: - Draft only. Give me the Clean table to add as a new tab. Ask me before you change, delete or send anything. - Never make up a name, number, date, price or promise. Use only what is in my sheet and what I tell you. - If something is missing, write [check: what is missing] and keep going. Last, save these steps as a Gem called 'Clean My Lead Sheet' so you do it this way each time my list gets messy. In Claude or ChatGPT, save them as a skill called 'Clean My Lead Sheet'. To run it again, just say: "Run my Clean My Lead Sheet Gem."
You need![]()
Your files
GeminiTested on sample data
Connect first: your files. The steps for each AI are on one page. Then the prompt reads it for you. It ends by saving itself as a skill.
Built on Fanatical Prospecting's rule to own your database.
Copilot version
There is no separate Copilot version of this one yet. Paste the prompt above into Microsoft 365 Copilot Chat.
See a real example
Tested on sample data Sample data run (simulated tool).
Watch: no video for this one yet.
AuthorCorey Leon