AI for Solopreneurs: A Simple Client Inquiry Tracking System

A simple system can help a solo business owner keep track of the next step.

Quick answer: A spreadsheet can help you record inquiries, their current status, and the next action. An AI assistant can suggest a reply using information you provide. Neither tool guarantees clients or sends reminders automatically in the setup described here.

When you run a business alone, an inquiry might arrive through email, a contact form, or a freelance platform. If the conversation pauses while you wait for more information, it can be easy to forget the next step.

This guide shows how to create a basic inquiry tracker in Google Sheets and use AI to help draft a response. The examples are fictional. You remain responsible for deciding what to send and protecting customer information.

What This System Does

The tracker gives you one place to note:

• What the potential client requested.
• Whether the conversation is new, waiting, quoted, or closed.
• What you need to do next.
• Whether a follow-up date has passed.

This is a manual system. It does not send messages, create calendar reminders, or guarantee that an inquiry becomes a sale. You need to open the sheet and update it yourself.

Step 1: Create an Inquiry Tracker

Open Google Sheets and create a blank spreadsheet. Add these headings in the first row:

Cell	Heading	Purpose
A1	Inquiry ID	A short reference, such as EX-01.
B1	Request	A brief description of the work.
C1	Stage	Where the conversation stands.
D1	Next action	What you plan to do next.
E1	Follow-up date	A date you enter when needed.
F1	Follow-up status	A formula that checks the date.

For a real inquiry, keep only the information you need and are permitted to store. You can use a reference to find the original conversation in your inbox rather than copying its full contents into every tool.

Step 2: Add Two Fictional Inquiries

Use the following examples to test the layout. They do not describe real clients.

Row	Inquiry ID	Request	Stage	Next action
2	EX-01	Newsletter draft	Waiting	Confirm audience and deadline
3	EX-02	Spreadsheet review	Closed	No follow-up needed

Leave the follow-up dates blank for now. You can use these stages consistently in column C:

• New: The inquiry needs an initial review.
• Waiting: You need information or are waiting for a response.
• Quoted: You have sent a price or proposal.
• Closed: No further follow-up is needed. This does not necessarily mean a sale occurred.

You can type the stages yourself or use a dropdown in Sheets. If you create a dropdown, make sure its labels match the words used in the formula below.

Step 3: Show When a Follow-Up Is Due

Select E2:E20 and choose Format → Number → Date. Enter actual follow-up dates in that column when you need them.

In F2, enter this formula:

=IF(A2="","",IF(C2="Closed","Closed",IF(E2="","No follow-up date",IF(E2<TODAY(),"Overdue",IF(E2=TODAY(),"Due today","Upcoming")))))

Copy the formula from F2 down through F20. For each row, it displays:

• Closed: The stage in column C is Closed.
• No follow-up date: The inquiry is open, but column E is empty.
• Overdue: The entered date is before today.
• Due today: The entered date is today.
• Upcoming: The entered date is after today.

A row without an inquiry ID in column A stays blank. Enter real dates rather than text that only looks like a date. The displayed result also depends on the spreadsheet’s date and time-zone settings.

Formula tip: Some spreadsheet locales use semicolons instead of commas between arguments. If the formula produces a parse error, check the spreadsheet’s locale and try replacing the argument commas with semicolons.

Test it before adding real work

1. With E2 empty and C2 set to Waiting, F2 should show No follow-up date.
2. Enter today’s date in E2; F2 should show Due today.
3. Change C2 to Closed; F2 should show Closed.
4. Check that an empty row does not display a status.

This formula displays a status inside the sheet. It does not send notifications. If you need an alert, arrange a separate reminder in a calendar or another suitable tool.

Step 4: Draft a Reply With AI

An assistant can help you organize a response when you know what you want to ask. Start with a fictional example or information you have permission to share.

I am a freelance writer responding to a fictional inquiry.

The person wants one newsletter draft. I still need to know:
- Who the newsletter is for
- The preferred deadline

Draft a short, polite reply asking those two questions.

Do not invent a company name, price, discount, delivery date, or previous client results. Do not send the message.

Read the draft before using it. Make sure it asks the right questions and does not promise a price or deadline you have not agreed to.

For help comparing assistants on the same task, see our ChatGPT vs Claude comparison. The choice of tool does not remove the need to review its answer.

Step 5: Review the Tracker Regularly

Choose a time that fits your workload to open the sheet and review open inquiries. For each one:

1. Read the latest message in the original conversation.
2. Check whether the stage and next action are still accurate.
3. Decide whether a follow-up is appropriate.
4. Update the row after you take action or close the inquiry.

A follow-up should respect the other person’s preferences and the platform’s rules. Do not send repeated unsolicited messages simply because a tool can draft them quickly.

Protect Customer Information

A tracker can contain sensitive information, even when it uses reference numbers instead of names. Limit access to the sheet and follow the privacy requirements that apply to your business.

• Do not paste passwords, login codes, or private keys into an AI tool.
• Do not upload a client’s private messages or files without the necessary permission.
• Review sharing settings before giving another person access to the sheet.
• Keep an appropriate backup of important business records.
• Use fictional data when testing a new prompt or workflow.

Removing a name does not necessarily make a message anonymous. Other details can still identify a person or business.

Should You Automate the Follow-Up?

You might eventually connect a form, spreadsheet, or email service, but automation is optional. Not every automation requires AI, and each connection introduces settings that need to be checked.

If you decide to test one, start with fictional data, review its permissions, and make sure you know how to stop it. Keep human approval for messages containing prices, deadlines, or other commitments unless you have designed an appropriate process.

Also compare any subscription and setup costs with the time the system actually saves. Time saved is not automatically money earned, and a paid tool is not necessary for the basic tracker above.

Frequently Asked Questions

Will this sheet remind me automatically?

No. The formula displays a status when you open the sheet; it does not send an email or notification.

Do I need a paid AI subscription?

No. The tracker can be used without AI. Consider an assistant only if it helps with a task and its current terms and cost suit you.

Can this system guarantee more clients?

No. It can help organize your follow-up, but getting paid work depends on your service, potential clients, and many other factors.

Can I paste a customer’s message into an AI tool?

Only when you have the necessary permission and understand the provider’s data-handling terms. Use a fictional example when practicing.

Final Thoughts

A useful one-person system does not need to be complicated. Start with a list you can maintain, keep the next action clear, and use AI only where it helps you do the work responsibly.

Bottom line: Track inquiries, review your replies, and protect the information people share with you. The system supports your decisions; it does not replace them.

For help with spreadsheet menus and settings, visit the Google Docs Editors Help Center.