Published on

How ChatGPT Helped Me Build My First Digital Product

Last night, I released my first digital product. And I couldn’t have done it without ChatGPT.

It’s not an ebook full of cliché phrases or vague, misleading statistics.

It’s not a piece of uncanny valley “artwork” with too many fingers and lines that lead to nowhere.

It’s a spreadsheet: The Freelance Service Package Pricing Worksheet. A simple calculator that helps freelancers and independent business owners package their services and determine how many packages they need to sell to meet their income goals.

Creating My Spreadsheet

To use my spreadsheet, a user fills in a table with their preferred hourly rate, the services they offer, and the time it takes to complete each service. Then, in separate tables, they build service packages by selecting the appropriate services from dropdown menus and entering the quantity of each service. The spreadsheet references the price chart and calculates the price of each item in a package based on the selected service, the quantity, and the price.

The Freelance Service Package Pricing Worksheet package builder

Where does ChatGPT come in? It helped me with the formulas.

Getting Help From AI

I searched forums for a formula that automatically pulls data from the price chart based on the corresponding dropdown selection, multiplies it by the entered quantity, and returns the product as the item’s service price. I’m still learning to use formulas in Google Sheets, and I was having trouble parsing the forum answers to determine if the provided formulas would do what I needed. So, instead, I explained to ChatGPT what I wanted my formula to do.

A prompt asking Chat-GPT for a formula for the Freelance Service Package Pricing Worksheet.

ChatGPT gave me this response:

Chat-GPT's response to the prompt.

I adjusted the formula to include the correct cell and sheet names and to return an empty cell if there was an error in the formula.

A Google Sheets formula for the Freelance Service Package Pricing Worksheet.

And it worked!

Cutting Through the Spreadsheet Coding Clutter

Generative AI may have a long way to go when it comes to copywriting, novel writing, basic algebra, art, and many, many other pursuits. But if I ever need help building a spreadsheet, I know where to go for a simple, thorough explanation of formulas.

You win this round, AI.

If you would like to move away from hourly pricing and build service bundles for your freelance business that help you charge for your value, expertise, and speed rather than your time, try my Freelance Service Package Pricing Worksheet.

Update cookies preferences