You can build a fully functional client tracker in Google Sheets without touching a single formula—just describe what you want to track, and let Gemini or ChatGPT do the building for you. Both tools can generate columns, structure, formatting, and even status dropdowns from a plain-English prompt, so the whole thing takes minutes instead of an afternoon.
If you’ve ever put off organizing your client list because you didn’t know where to start (or dreaded fighting with VLOOKUP), this is the fix. You don’t need to be a “spreadsheet person” anymore. You just need to know what to ask for.
Why AI Makes This So Much Easier Now
Google Sheets got a real upgrade to its built-in AI this year. Starting in late April 2026, Gemini can build and edit entire spreadsheets from scratch using plain, conversational language—no formula knowledge needed. You describe what you need, and Gemini handles everything from data retrieval to formatting. That’s a genuine shift from how spreadsheets have worked for decades.
This isn’t just marketing fluff, either. Google tested Gemini in Sheets on SpreadsheetBench, an independent, publicly available benchmark for evaluating AI spreadsheet manipulation, and it hit a 70.48% success rate—nearing human expert-level ability. In practice, that means when you ask it to build something like a client tracker, it’s genuinely good at getting the structure right the first time.
Google itself lists exactly the kind of thing you’re trying to do here as a core use case: “Create a table for a project tracker in Google Sheets with columns for task, assignee, deadline, and status.” Swap “project” for “client,” and you’re most of the way to your prompt.
Option 1: Build It With Gemini in Google Sheets
If you’re already in Google Sheets, this is the fastest path. Here’s how it works:
- Open a blank sheet. Open Google Sheets, and the side panel automatically opens with Build.
- Type your prompt. Type your prompt to edit or create a spreadsheet, optionally answer any clarification questions that come up, then review the plan and template outline Gemini provides.
- Approve and let it build. Gemini will construct the entire formatted spreadsheet for you—headers, formatting, and structure included.
A good starting prompt might sound like: “Create a client tracker with columns for client name, contact info, project status, last contact date, next follow-up date, and notes. Use a dropdown for status with options New, Active, On Hold, and Closed.” That’s specific enough for Gemini to run with.
One important detail: this feature works best with native Google Sheets files, so if you’re starting from an Excel file, save it as Google Sheets first. And access depends on your plan—it’s currently available for users with Business Standard and Plus licenses, though Google has also been extending it to other Workspace and Google AI subscribers as the rollout continues.
Once your tracker exists, you’re not locked into the initial layout. Gemini in Sheets can also create tables and charts, build organizational templates, analyze your data, and structure or clean up existing data—so if your client list is already a mess in another tab, you can ask Gemini to tidy it up rather than starting from scratch.
Option 2: Use ChatGPT If You’d Rather Stay There
Prefer ChatGPT? You’ve got two solid routes.
Route A: Copy and paste. Just describe your tracker in a ChatGPT chat—no add-ons needed. Setting up a tracking spreadsheet often involves a lot of manual column creation and formula guesswork, but ChatGPT can automate the whole process, from designing the structure to generating the layout, using conversational prompts. The key is being specific. As one guide puts it, a vague prompt like “make me a project tracker” gives you a generic result, so instead you should specify exact columns and status options you want. ChatGPT will hand you back a clean table you can copy straight into Sheets.
Route B: The ChatGPT add-on for Google Sheets. If you want ChatGPT working directly inside your spreadsheet, install the official add-on. You can install ChatGPT for Excel and Google Sheets from Extensions → Add-ons → Get Add-ons, then sign in with the OpenAI account tied to your ChatGPT plan. From there, prompts like “Build a project tracker with owners, deadlines, and status” work the same way, but you never have to leave the sheet.
What to Include in Your Prompt
The more specific you are up front, the less cleanup you’ll do later. Think through:
- Client name, company, and contact details
- Status (lead, active, on hold, closed—whatever fits your workflow)
- Key dates: signed date, last contact, next follow-up
- Project or service type
- Value or invoice amount, if you’re tracking revenue
- A notes column for anything that doesn’t fit elsewhere
Mention all of this in one prompt rather than adding it piece by piece. Both Gemini and ChatGPT do better with a full picture than with a string of small follow-up requests.
Don’t Stop at the First Draft
Treat the first version as a rough cut, not the finished product. You can keep talking to the AI after it builds your tracker—ask it to add conditional formatting so overdue follow-ups turn red, group clients by status, or reorganize columns. You can also just ask Gemini to build pivot tables, find and replace text, or apply conditional formatting rather than doing any of it by hand.
If something looks off, say so directly. “Move the notes column to the end” or “add a column for referral source” is all it takes. That back-and-forth is really the whole point of using AI for this—you’re not committing to a rigid template, you’re shaping something as you go, without ever needing to know what a formula even looks like.
A client tracker built this way isn’t going to replace a full CRM if your client list runs into the thousands. But for freelancers, consultants, and small teams juggling a manageable roster, it’s more than enough—and it took you minutes, not a weekend.
Hi! I use AI to help research and write posts on this site. I do my best to keep things accurate, but please double-check anything important — and nothing here replaces advice from a licensed or certified professional.
