Build your own job and bid tracker
Build a small job and bid tracker with Claude Code that runs on your own computer, so you can drop a paid tracker you only use for lists and follow-up dates.
For solo trades and small shops that pay for a job tracker but only use it to list jobs, bids, statuses and follow-up dates · Claude Code · Intermediate
Researched, not run yetWhat that means
Copy the prompt
Fill in the [brackets] after you paste it.
Build a small job and bid tracker that runs only on this computer. Use a language and tools you can run here. Keep it simple.
What it must do:
- A web page I open in my browser, served only on this computer (localhost), so nobody else on the network can open it.
- One data file in this folder, in a format I can open in a spreadsheet (CSV is fine). All jobs live in that file.
- Each job has: customer name, phone, address, job type, status, bid amount, date bid sent, follow-up date and notes.
- Statuses: Lead, Bid sent, Follow up, Won, Lost, Done.
- Views: all jobs, a "Follow up today or overdue" list, and a search by name or address.
- Add, edit and delete a job, with a confirm step on delete.
- A button to export all jobs to a CSV, and a button that saves a dated backup copy of the data file.
- An import from a CSV with the same columns, which shows how many rows it will add before it adds them.
What it must not do:
- No sending of email, text or anything else. No internet access. No accounts or payments.
- No change to files outside this folder.
First load 5 made-up jobs so I can try it, for example "Pat Ortiz, 14 Birch Lane, furnace repair, Bid sent, 850, sent Nov 9, follow up Nov 16". Then tell me how to start it, and what to check. Before you run anything, say what you will do.Copied. Paste it into Claude Code next.
Free PDF
Get this setup as a PDF
Enter your email and a print-ready copy of this setup opens here, to save as a PDF. The free starter pack opens too. Tap confirm in the email that follows to get occasional new setups. Unsubscribe anytime.
Already a subscriber? Unlock it on this device
Free PDF
A confirmation email is on its way too: tap confirm in it to get new setups by email.
Three ways to run this setup
Free
Copy and paste it yourself
Copy the prompt above into ChatGPT, Claude or Grok. It drafts. You approve.
Go to the prompt$9 once
Complete Pack
One payment, no membership. Opens the pack pages: Bot Safety Checklist, Second Brain Starter Vault, Voice File Starter, Tested Grok Bot prompt pack, Write it as code prompts.
See the Complete PackFree to start, VIP $19 a month
Save it as a bot in the guided setup app
The app turns this setup into a bot with the draft-only rules. 3 setups build free; the rest are part of VIP. A human reviews a prompt or setup for you within 24 hours, up to 2 a month.
Build it in the app
Want this one tested next? Vote for it.
What you get back
Example written for this page with made-up details. Not from a test run.
- Created tracker.html, tracker.py and jobs.csv with 5 made-up jobs. Start it with python3 tracker.py, then open the address it prints. It listens on this computer only.
- Views: All jobs (5), Follow up today or overdue (2), Search. Buttons: Export CSV, Back up now, Import CSV.
- To check: add a job, change its status to Won, delete one (it should ask first), export, then run Back up now and look for the dated copy.
3 steps
- Copy the prompt.
- Paste it into Claude Code.
- Fill in the [brackets], then read the answer before you send or use it.
Quick answer
If the paid tracker is only a list of jobs, bids, statuses and follow-up dates, Claude Code can build a small local app for that: one page you open in your browser, with the data in one file on your computer. Write down what you really use, build it in a new folder in Manual mode, load made-up jobs, then import your real ones and compare the counts. Keep the old tool until the new one has covered a full cycle of jobs. It will not do invoices, payments or customer messages.
How do you set it up?
Skip this if
- You use the paid tool for invoicing, payments, crew scheduling or texting customers. This app does none of that.
- More than one person must use the same tracker from different places.
Done after day one
A working tracker on made-up jobs, a list of what you really use, and an export from the old tool waiting to be imported.
Tools
- Claude Code, in the terminal or the desktop app
- A new, empty folder for the app
- An export of your jobs from the paid tool, if it offers one
- A second place to keep backup copies of the data file
Steps
- Check whether the paid tool lets you export your jobs, usually as a CSV file. Do this first. If it does not, stop here and keep the tool.
- Write down what you actually use, in a short list: the fields on a job, the statuses, the views and the reminders. Anything not on the list stays out of the app. Invoices, payments and customer messages stay in the tool or in your usual process.
- Make a new folder and open Claude Code in it in Manual mode (cd into the folder, then claude --permission-mode manual). In Manual mode Claude Code stops and asks before most consequential actions, such as editing files or running commands, though not before every read. Newer versions start in auto mode by default, so check the mode indicator.
- Paste the prompt below with your fields and statuses. Read what Claude Code wants to do and approve each action.
- Start the app as Claude Code tells you. Load the made-up jobs, then check each view, the follow-up list, the search and the export.
- Check the network behavior. Look at the address the app is listening on and confirm it is the local address only, then try opening it from another device on the same network; it should not load. Do this before any customer data goes in.
- Import your real export only after those checks pass. Compare the number of jobs in the old tool with the number in the app, and spot-check a handful of jobs against the originals.
- Run both tools for a full cycle of jobs. Cancel the paid tool only after that, and keep the export file.
- Set up the backup. Copy the data file to a second place on a schedule you can keep, and try a restore once.
Where to paste this prompt
Claude Code → terminal, IDE extension, or web session in your project directory
More ways to run it
Which chat tools work with this prompt?
Paste the prompt into any of these assistants (free or paid tiers).
- Claude Code
How sure is this?
Last updated: · Last reviewed:
Before you use this
What it is allowed to do: Adds sheet rows. Adds rows to your own Google Sheet.
At a glance: time, cost and difficulty
At a glance
All outcome figures are estimates from cited sources, not independent verification by us.
- What it is allowed to do
- Adds sheet rows
Adds rows to your own Google Sheet.
- Time saved (estimate)
- Not measured yet
- Difficulty
- Intermediate
- Tools needed
- Claude Code
- Typical cost
- Claude Code needs a paid Claude plan (Pro, Max, Ultra, Team or Enterprise) or a Claude Console account. See claude.com/pricing. This only saves money if the paid tracker you leave costs more than the plan you already pay for.
Reviewed Nov 16, 2026
Basis (estimate): Not measured yet. No timing has been recorded for this setup.
What usually goes wrong?
Where agents tend to stall on this job. More patterns in Where AI gets stuck.
- Claude Code adds features you did not ask for. Say what to remove, and keep the "must not do" list in the prompt.
- The import adds rows twice. Check the row count before and after, and keep the old export untouched.
- The data file gets overwritten by a mistake. Back it up before every change, not only on a schedule.
- The app stops working after a computer update. Keep the prompt and the data file, and ask Claude Code to rebuild or repair it.
- The paid tool costs less than the plan you pay for Claude Code. Then this does not save money.
What tips make it smoother?
- Ask Claude Code for a short test list at the end, so you can check the app after any change.
- Keep the prompt. When you want a change, paste it again with the change, so the file format stays the same.
- Add features one at a time, and re-run the checks after each.
Where do the claims come from?
Summaries use public sources linked below, not independent verification. How setups are picked.
- Read Anthropic’s write-up (code.claude.com)
Anthropic: Claude Code quickstart (read Nov 16, 2026): install commands, plans that include it (Pro, Max, Ultra, Team or Enterprise, or a Claude Console account), start it with cd into a folder then claude.
- Read Anthropic’s write-up (code.claude.com)
Anthropic: Claude Code permission modes (read Nov 16, 2026): in Manual mode Claude Code stops and asks before most actions that edit files, run shell commands or reach the network; start in Manual with claude --permission-mode manual; auto mode is the built-in starting mode on current versions.
- Read Anthropic’s write-up (code.claude.com)
Anthropic: Best practices for Claude Code (read Nov 16, 2026): tell Claude what it cannot see and give it a check to run, which is why the prompt asks for made-up jobs and a list of things to check.
Common questions
- Can Claude Code really replace a paid job tracker?
- For a list of jobs, bids, statuses and follow-up dates, a small local app can do the job. It does not replace invoicing, payments, crew scheduling or customer messages.
- Do I need to know how to code?
- No. In Manual mode you paste the prompt and approve each action. It helps to read what Claude Code says it will do before you say yes.
- Is my customer data safe in the app?
- The prompt asks for an app that runs only on your own computer. That is an instruction, not a lock, and nothing here shows what was actually built. Before you import customer data, check the address the app listens on and that other devices on your network cannot open it. Back up the file and keep the computer locked.
Free kit by email
Get the free kit by email
The starter pack and the Portable AI Office, sent to your inbox. New setups by email after that. Unsubscribe any time.
What to do next
- Track the bids you sent and follow up
Build a one-sheet bid tracker with AI that flags which bids need a follow-up today, which are still waiting, and which you won or lost.
- Job emails to a sheet with Claude Code
Turn a pile of repair or job request emails into one spreadsheet with a small script, instead of a bot that reads your inbox all day.
- Track inventory in a spreadsheet with reorder alerts
Build a two-sheet inventory tracker where formulas compute stock on hand and flag reorders, with an optional daily email alert, all from free tools.
Have a setup that works? Submit it. We credit sources and write it up in plain language.