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

  1. Download the kit, unzip it, and import lead-tracker.csv into a spreadsheet app.
  2. Start with your open inquiries. Enter when they arrived, the source, the contact’s preferred email, and what they’re asking for.
  3. 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.
  4. 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.

Example client inquiries
LeadSourceStatusNext actionDue
Alex, landing pageContact formWaitingAsk if the launch date is fixed23 Nov
Jo, brand refreshInstagram DMNewReply and ask for the project brief19 Nov

Keep your statuses simple

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.