Client workflows
Free client inquiry tracker for freelancers
A spreadsheet for the moment a client says hey, right through to your next reply.
If client inquiries come in through both email and DMs, start with one row per inquiry and a date for the next step. The aim is to open the tracker tomorrow and instantly know who needs to hear from you.
Download the free tracker and reply templates
Set up the tracker in five minutes
- Download the kit, unzip it, and import
lead-tracker.csvinto a spreadsheet app. - Start with your open inquiries. Enter when they arrived, the source, the contact’s preferred email, and what they’re asking for.
- Assign every open row one status, one next action, and a date. If the next action reads “follow up,” add what you need to ask or offer.
- Filter out closed rows, then sort by Next action due so the oldest dates appear first.
What a useful row looks like
Here are two fictional examples. The notes explain the next step without copying the entire conversation into the sheet.
| Lead | Source | Status | Next action | Due |
|---|---|---|---|---|
| Alex, landing page | Contact form | Waiting | Ask if the launch date is fixed | 23 Nov |
| Jo, brand refresh | Instagram DM | New | Reply and ask for the project brief | 19 Nov |
Keep your statuses simple
- New means an inquiry still needs a first reply.
- Waiting means you’ve written back and set a date to check for a response.
- Active means a call, estimate, or other concrete step is underway.
- Closed means no action is due. Clear the old reminder when you close the row.
When is it worth automating intake?
Start by entering leads manually. Once transcribing form submissions becomes the step you routinely skip, connect your intake form to your tracker. Keep the daily review while you learn which follow-ups benefit from a human reply.
When an inquiry goes quiet, use the examples in our client follow-up guide.
