Build an AI tool today
How I build a small AI tool in one afternoon
You can build a working AI tool with a prompt, a spreadsheet and a short script. Here is the exact recipe I use for client work.
People assume you need to be a programmer to build an AI tool. You need to be a clear thinker. The programming part is now mostly done for you.
Here is the recipe I use. I have built a dozen small tools this way for my agency.
Step one. Pick one boring, repeated job. Mine was writing product captions. A client has a long list of products and needs a short caption for each, in the same tone, every month. Doing it by hand is dull. Doing it in one big chat is messy, because the tone drifts after the tenth caption.
Step two. Write the instructions as if for a person. One page. What the caption is for. The tone. The length. Two good examples. Three mistakes to avoid. Save it as a text file called the prompt.
Step three. Put the inputs in a spreadsheet. One row per product. Columns for name, key feature, price. Save it as a CSV file, which is just a plain text version of a spreadsheet.
Step four. Ask an AI to write the script. Yes, really. I open a coding assistant and say: "Write a small Python script. It reads this CSV. For each row it sends the prompt file plus the row to the model. Then it saves the answer in a new column." I paste the prompt file so it knows the shape. The script comes back in a minute. I run it. It usually fails once on something small, I paste the error back, and it fixes itself.
Step five. Run it on five rows. Read the output. Fix the prompt, never the script. Run it again. When five are good, run all of them.
That is the whole tool. A prompt, a spreadsheet, and a script that connects them.
The surprise for me was where the time goes. About ten percent writing the script. About ninety percent improving the prompt and the examples. The tool is only as good as the instructions, which is the same rule as every other job.
Two practical notes. Keep your API key, which is the password for the AI service, in a separate file that you never share. And add a cost cap at the service, so a mistake in a loop costs you a few dollars instead of a few hundred.
Once you have built one, the second one takes an hour. By the fourth, you start seeing every repeated task in your business as a candidate.
