CAPTURE

Build a client intake system

A practical Tally and Google Sheets workflow for your next client inquiry.

Give each inquiry one home

Create a Tally form with four required fields: name, email, the service they need, and a short description. Add optional fields for timeline and budget range if they change how you respond. For inquiries that arrive by email or DM, create a row manually in the same tracker.

Use these five client intake form questions to get started.

Connect the form to your tracker

  1. Import the lead tracker CSV into a private Google Sheet. Keep its tab as your working queue.
  2. Open your published Tally form, go to Integrations, and connect Google Sheets. Choose your spreadsheet. Tally creates a response tab. Submit a test inquiry and confirm its fields appear there.
  3. At first, move new entries into your working queue during one daily inbox review. Add a status and one dated next step for each open lead.
  4. When the manual handoff becomes repetitive, create a Make scenario with Tally Watch New Responses and Google Sheets Add a Row. Map the form fields and keep the response ID in the working queue. Before creating a row, look up the response ID so a retried run can be ignored. If duplicate deliveries are possible, use sequential scenario processing for the lookup and insert.

Send a short acknowledgment

Say what you received and when you expect to reply. Put the same expectation on the form’s confirmation screen. If you automate the email, try it with a dedicated test address before switching it on for clients.

Official setup docs from Tally for Google Sheets, Tally for Make, and Make's Tally integration.

New to tracking leads? Start with the free client inquiry tracker.

Download the free intake kit