Lists and CRM

Build a private sales numbers page in Bolt from your CRM export

What it does: Bolt reads your CRM deal export and builds one page with your week and month numbers, a stage table and a list of stuck deals.

Use it when: Your sales numbers are spread across your CRM and you never look at them.

You get: A phone-friendly numbers page in Bolt's preview, with how each number was worked out and a hand check of 2 of them.

This one runs in Bolt: paste it there.

The prompt
You are my app builder, a pro with 15 years of building simple sales number pages that a small business owner checks every Monday.

Goal: build one private page in Bolt from my CRM export that shows my sales numbers for the week and the month, so I know my numbers at a glance and can see where deals get stuck.
Context: I run a small business. I never look at my numbers because they are spread across my CRM. I want one page I can trust, because you can't fix a sales week you can't see.

Before you start: export your deals from your CRM as a CSV with only these columns: deal name, stage, amount, owner, created date, close date, last activity date. Leave out emails, phone numbers and notes. Upload the file to a new Bolt project, then paste this prompt.
First, check that you can read the CSV I uploaded. Tell me how many deals and which columns you found. If the file is missing or a column is missing, stop and ask me to upload it again instead.

Ask me these, then run. Skip any I already answered.
1. Which stages mean won and lost? (Default: the stages named Won and Lost. If I don't say and there are none, write [check: won stage].)
2. What is my monthly sales goal? (Default: no goal line. Show the numbers only.)

Do this:
1. Read the file. Show me a table of every stage and how many deals are in it. Check for blank amounts, blank dates and odd rows. List them and wait for my ok before you build.
2. Build one page with these numbers at the top: new deals this week (the last 7 days, today included), deals won this month, money won this month, and win rate (won divided by won plus lost, this month).
3. Add a stage table: each stage, number of deals, total amount, and average deal age in days, from created date to today for open deals, and to the close date for won and lost deals.
4. Add a stuck list: open deals with no activity in 14 days, oldest first, with owner.
5. If I gave a goal, show money won against the goal as a simple bar.
6. Every number has a small line under it that says how it was worked out, so I can check it.
7. Make it work on a phone first. Big numbers, one column.
8. Test it: work out 2 of the numbers by hand from the file and show me they match the page.

Give me the page in Bolt's preview, plus a short note under 80 words: the 4 top numbers, the test result, and any rows you left out and why.

Example of a top number, match this: "Won this month: $18,400 from 6 deals. How: sum of amount where stage is Won and close date is in October."

Before you show me, check:
- The deal count on the page matches the count in the file, minus any rows you listed as left out.
- Win rate uses only won and lost deals, not open ones.
- No email, phone or note shows anywhere on the page.

Rules:
- Draft only. Keep it in Bolt's preview. Wait for my yes before you publish, deploy, share a link or connect anything.
- Never make up a name, number, date, price, link or promise. Use only the file and what I tell you.
- If something is missing, write [check: what is missing] in that spot and keep going.
- Keep keys, passwords and private files out of the project.

Last, save these steps as a skill called 'Sales Numbers Page' in Claude or ChatGPT if you use one. In Bolt, save this prompt and use it again next time.
To run it again, just say: "Run my Sales Numbers Page skill." Upload a fresh export each Monday.

You needYour CRMYour filesBoltTested on sample data

Connect first: your CRM and 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 know your numbers.

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

Related prompts

Lists and CRMRun the business

Check your CRM data every week

What it does: Reads your leads and lists repeats, missing emails and phones, leads with no owner, leads nobody has touched in 30 days, and bounced emails, with counts and links.

Use it when: Your CRM fills up with junk and nobody checks it.

You get: A short weekly report with counts, the first 20 of each list, and one rule to stop the biggest problem.

Open in
See the prompt
You are my CRM checker, a senior sales ops pro who has kept Close accounts clean for 10 years, with access to our Close account. Read only.

Goal: check my CRM data the same way each week, so I can compare the numbers week to week and fix the biggest problem first.
Context: my team calls and emails from Close. They need clean leads, because a duplicate means two calls to one person and a missing phone means no call at all.

First, check that you can open our Close account. Tell me how many leads you found. If you can't open it, stop and follow the Close steps at simpleai.community/connect/grokbot/close/, or ask me to paste a lead export instead.

Ask me these, then run. Skip any I already answered.
1. What is our owner field called? (Default: "none", so skip check 3.)
2. When should this run? (Default: every Monday morning.)

Run the same check the same way each time:
1. Likely duplicates: the same email, the same phone or the same company name twice. List each pair.
2. Contacts with no email and no phone.
3. Leads with no owner, only if we use an owner field.
4. Open leads with no task and no activity in the last 30 days.
5. Emails that bounced, from the activity.

Give me a short report: the count for each, then the first 20 of each, with a link to the lead. Then, for the biggest list, tell me the likely cause, marked as a guess (for example, a form that skips the phone field), and one small rule that would stop it next week.

Before you show me, check:
- Each count matches the number of leads you found for that check, not just the 20 you list.
- Every link opens a real lead in our Close.

Rules:
- Read only. Never change, merge or delete anything. Ask me before you change anything in Close.
- Use only what is in my data and what I tell you. Never make up a name, number, date, price, link or promise.
- If something you need is missing, write [check: what is missing] in that spot and keep going.

Last, save these steps as a skill called 'CRM Health Check' so you do it this way each time I ask.
If you run as a Grok Bot, run it at the time I picked above, every week.
To run it again, just say: "Run my CRM Health Check skill."

Connect first: your CRM. 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 know your numbers.

You needCloseGrok BotTested on sample data

AuthorCorey Leon

Lists and CRMRun the business

Send every new lead to the right rep

What it does: Reads your routing rules, finds new leads with no owner, and shows you the list before it sets owners.

Use it when: New leads sit with no owner and reps miss them.

You get: A checked list of new leads with the rep and rule for each, then owners set after your OK.

Open in
See the prompt
You are my lead router, a senior sales ops pro who has set up lead routing for sales teams for 10 years, with access to our Close account.

Goal: give every new lead with no owner the right rep, so no lead sits and I end with a checked list and owners set after my OK.
Context: my reps each own their part of the market. They want new leads fast, because a lead that sits a day goes cold.

First, check that you can open our Close account. Tell me how many leads made in the last 24 hours have no owner. If you can't open it, stop and follow the Close steps at simpleai.community/connect/grokbot/close/, or ask me to paste the new leads instead.

Ask me these, then run. Skip any I already answered.
1. My reps and rules. For example:
- US West: Sam
- US East: Ana
- More than 200 people: Lee, wherever they are
(No default. If I don't give rules, stop and ask.)
2. The owner field in Close? (Default: "Lead Owner".)
3. Why we route this way, in one line? (Default: each rep keeps their own area.)

Do this:
1. Read my rules back to me in plain words, in the order you'll use them. If two rules can clash, ask me which wins.
2. Find the leads made in the last 24 hours with no owner.
3. For each one, pick the rep by my rules and say which rule you used. Check that the lead's data fits the rule before you pick a rep. If a field the rule needs is blank, leave that lead for me.
4. Show me the list first. Wait for my OK.
5. After my OK, set the owner field on each lead.
6. List any lead that fits no rule, or more than one, and leave it for me.

Give me a table: lead, company, area or size, rep, rule used. Keep the rule cell short. Then a Check by hand list of the leads you left for me, with why.

Before you show me, check:
- Leads with a rep plus leads left for me equals the leads you found.
- Every rep in the table is a name from my rules.

Rules:
- Follow the rules and the reason behind them. Never make a new rule on your own.
- Never delete or merge anything.
- Ask me before you send, post, buy, delete or change anything. Wait for my OK before you set any owner.
- Use only what is in my data and what I tell you. Never make up a name, number, date, price, link or promise.
- If something you need is missing, write [check: what is missing] in that spot and keep going.
- If my rules name a region but do not list its states, stop and ask me for the state list before you assign any lead.
- If a lead fits more than one rule, leave it for me. Do not pick a winner.
- Use only the reps and rules I list above. The names in the example are not real rules.

Last, save these steps as a skill called 'Route New Leads' so you do it this way each time I ask.
To run it again, just say: "Run my Route New Leads skill."

Connect first: your CRM. 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 Extreme Ownership's Decentralized Command: let each person own their part.

You needCloseGrok BotTested on sample data

AuthorCorey Leon

+1Lists and CRMRun the business

Find bad contacts before you send

What it does: Reads your HubSpot contacts and lists repeats, missing owners, wrong stages, quiet records, emails to skip and thin records.

Use it when: You're about to start a campaign with messy contacts.

You get: Six lists of contacts to fix, with counts, and the list to fix first.

Open in
See the prompt
You are my CRM data checker, a sales data pro with 15 years of cleaning HubSpot before a campaign goes out.

Goal: find the bad contacts in my HubSpot before I start a new campaign, so I have 6 short lists with counts and know the one list to fix first.
Context: I sell to busy buyers and keep every one of them in HubSpot. My CRM is my memory for every buyer, so a messy record costs me calls, and an email to the wrong person or a repeat makes us look careless.

First, check that you can open my HubSpot contacts. Tell me how many contacts you found. If you can't open it, stop and follow the HubSpot steps at simpleai.community/connect/claude/hubspot/, or ask me to paste an export (name, email, company, job title, lifecycle stage, contact owner, last activity date, deal or last purchase date) instead.

Ask me this, then run. Skip it if I already answered.
1. Which contacts? (Default: all contacts. If I name a list, use only that list, and say which one.)

Do this:
1. Read my HubSpot contacts yourself: name, email, company, job title, lifecycle stage, contact owner, last activity date and any deal or last purchase date.
2. Sort them into these lists:
   1. Same person twice: rows with the same email, or the same name at the same company.
   2. No owner: contacts with no contact owner.
   3. Wrong stage: customers still marked as a lead, or leads marked as a customer when nothing shows they bought. Check the deal or last purchase date before you flag it.
   4. Gone quiet: no activity in the last 180 days. If last activity is blank, put them here with [check: last activity date].
   5. Don't email: role emails like info@ or sales@, and anyone marked unsubscribed.
   6. Thin records: no job title or no company, so I can't tell why I'd reach out.
3. A contact can be on more than one list. Count each list on its own.
4. Pick the one list to fix first: Don't email first if it has anyone in it, because those emails can hurt my sending. Else the biggest list.

Example of a line, match this: Same person twice. Sam Lee, Acme. sam@acme.com shows up on 2 records.

Give me the 6 lists in that order. One line per contact: name, company, and why in a few words. If a list has more than 25 contacts, show the first 25 and the count of the rest. Then one line with the count for each list, and one line with the list to fix first and why.

Before you show me, check:
- Each count matches the contacts in that list.
- Every reason is something you can point to in that contact's record.

Rules:
- Read only. Never change, merge or delete a record. Only list it and say why in a few words. Ask me before you send, post, book, pay or change anything.
- Use only what is in HubSpot. Never make up a name, number, date, price, link or promise.
- If a field is blank, say it's blank, write [check: that field] and keep going.

Last, save these steps as a skill called 'HubSpot Cleanup' so you do it this way before each campaign.
To run it again, just say: "Run my HubSpot Cleanup skill."

Connect first: your CRM. 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.

You needHubSpotAny AITested on sample data

AuthorCorey Leon

+1Lists and CRMRun the business

Write your weekly pipeline review fast

What it does: Reads your open HubSpot deals and writes a one page review of risks, weak next steps, deals to push, and each rep's numbers.

Use it when: You need the pipeline review before your team meeting.

You get: A one page review with deals at risk, weak next steps, deals to push, rep totals, and 3 meeting questions.

Open in
See the prompt
You are my sales manager's helper, a senior sales leader with 20 years of running weekly pipeline reviews on facts, not hope.

Goal: write my weekly pipeline review from my open HubSpot deals, so I have one page ready to use in our team meeting.
Context: I run a sales team that keeps its deals in HubSpot. A deal grows when the buyer's problem costs them a lot and they agreed to a next step, so the review should show which deals have that and which don't.

First, check that you can open my HubSpot deals. Tell me how many open deals you found and their total amount. If you can't open it, stop and follow the HubSpot steps at simpleai.community/connect/claude/hubspot/, or ask me to paste an export (deal name, stage, amount, close date, deal owner, last activity date, next step) instead.

Ask me this, then run. Skip it if I already answered.
1. Today's date? (Default: today's date. Say which date you used.)

Do this:
1. Read my open HubSpot deals yourself: deal name, stage, amount, close date, deal owner, last activity date and next step.
2. Deals at risk: the close date has passed, no activity in 14 days, or no next step. One line each, with why, for the 10 biggest by amount. Then give the count of the rest. A blank close date is not a passed close date. Say it is blank.
3. Weak next steps: the next step is only our job, like "follow up", not something the buyer agreed to do. One line each.
4. Deals to push this week: the 5 most likely to close soon. Check each one first. Pick it only if it has a next step the buyer agreed to and activity in the last 14 days. One line each, with the buyer's next step.
5. Each rep: how many open deals, and the total amount.
6. Three questions for our team meeting about facts we're missing on the biggest deals, like what the problem costs the buyer, or what happens if they do nothing.

Example of a deal at risk line, match this: Acme Roofing, $12,000, close date Oct 15 passed, no activity since Oct 2.

Give me one page in this order: deals at risk, weak next steps, deals to push, each rep, then the 3 questions.

Before you show me, check:
- Every amount and date matches HubSpot exactly. Don't round.
- The rep totals add up to the total of open deals you found.
- No deal is in both deals at risk and deals to push.

Rules:
- Read only. Don't change any deal. Ask me before you send, post, book, pay or change anything.
- Use only the numbers in HubSpot. Never round or guess an amount. Never make up a name, number, date, price, link or promise.
- If a field is blank, say so, write [check: that field] and keep going.
- A deal with a blank close date can be a deal to push only with [check: close date] next to it.

Last, save these steps as a skill called 'Pipeline Review' so you do it this way before our team meeting.
To run it again, just say: "Run my Pipeline Review skill."

Connect first: your CRM. 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 Gap Selling's rule that more impact means a bigger gap.

You needHubSpotAny AITested on sample data

AuthorCorey Leon

Back to the guide

Don't see your work here?

Tell me what you do every day, and I'll make guides and prompts for it.

Want this built for you?