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.
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 need![]()
Your CRM![]()
Your files
BoltTested 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