How to Build a Free CRM in Google Sheets with AI

You can build a working CRM in one afternoon with Google Sheets and an AI assistant, without paying for any software. Ask the AI to design the table, add formulas that flag leads who go quiet, connect a Google Form so every new inquiry lands as a new row on its own, add a short script that emails you the leads to call each morning, and once a week ask the AI which deals are closest to closing. The short video below walks through all five steps.

What do you need before you start?

Only two things: Google Sheets and an AI assistant. There is no CRM subscription to buy and nothing to install. The AI does the design and formula work that used to make a spreadsheet CRM a weekend project, and the sheet stores your leads and deals.

Step 1: How do you design the CRM table?

Ask the AI to design your CRM table: the columns, the deal stages, and the dropdowns. Then paste what it gives you into Google Sheets. Starting from a design matters, because a sheet built with no plan turns into a list nobody trusts within a month.

As an illustration, a prompt for this step could be: design a CRM table for my small business, with columns for each lead, deal stages from first contact to closed, and dropdown values for the stage column. Read the answer before you paste it. If a column does not match how your business works, ask the AI to change it now, while the sheet is empty.

Step 2: How do formulas flag leads that go quiet?

Next, ask the AI for formulas. The two that matter most in the video are a count of days since last contact, and a rule that turns a lead red after a week of silence. The first tells you how long each lead has been waiting. The second makes the waiting visible, so a quiet lead stands out instead of blending into the rows around it. Most lost deals go quiet one day at a time, in a sheet nobody rechecked. The red flag gives you a reason to act while the lead still remembers you.

Step 3: How do new inquiries get into the sheet on their own?

Connect a Google Form to the sheet. Every new inquiry then lands as a new row on its own. Nobody copies a name from an email into the CRM by hand, and no inquiry sits in an inbox waiting to be remembered.

For example, a service business can put a short inquiry form on its website. Each submission arrives in the sheet with the same columns as every other lead, ready for the stage dropdown and the follow-up formula. The sheet becomes the one place where every lead lives.

Step 4: How do you get a daily list of leads to call?

Ask the AI to write a short script that emails you every morning with the leads to call today. This step turns a passive sheet into a daily habit: you open one email and start calling.

The list works because of the earlier steps. The script reads the same sheet, uses the last contact dates and stages you already track, and surfaces the leads that need attention first, including the ones your red flag caught. Check the first few emails against the sheet until you trust the list.

Step 5: How do you know which deals are closest to closing?

Once a week, give the sheet to the AI and ask which deals are closest to closing. The AI reads the stages and how recently each deal moved, then gives you a short answer you can act on. Instead of scanning every row, you focus on the deals most likely to finish.

Treat the answer as a priority list, not a promise. If a highly ranked deal has a problem the sheet does not show, note it in the sheet. The next weekly answer gets better because the record got better.

What this means for your business

A spreadsheet CRM built this way covers the jobs that actually lose small businesses money: leads in one place, quiet leads flagged before they go cold, new inquiries added without manual copying, a clear call list every morning, and a weekly view of what is close to closing. None of that needs paid software. It needs one afternoon, a designed sheet, and the habit of acting on the flags the sheet raises.

When should you move from a sheet to a real CRM?

When your team grows, move to a real CRM. That is the honest limit in the video, and it is the right one. A sheet works while one person, or a very small team, owns the follow-up. Once several people sell at once and leads get handed over often, the sheet starts to strain. By then you will know exactly which columns and stages you need, because you have been using them. Moving that design into a real CRM is far easier than guessing at it on day one.

Frequently asked questions

How can I build a free CRM in Google Sheets with AI?

Follow the five steps in the video: ask the AI to design the table with columns, deal stages and dropdowns, and paste it into Google Sheets. Ask for formulas that count days since last contact and turn a lead red after a week of silence. Connect a Google Form so new inquiries land as rows on their own. Ask the AI for a script that emails you the leads to call each morning. Once a week, ask the AI which deals are closest to closing.

What should the CRM table include?

Whatever the AI designs for your business from your prompt: columns for each lead, clear deal stages, and dropdowns so stages are picked from a list instead of typed differently each time. Remove any column you will not actually fill in.

How does the sheet flag a lead I have not contacted?

With two formulas the AI writes for you: one counts the days since last contact, and one turns the lead red after a week of silence. You see problem leads at a glance instead of finding them after they have gone cold.

Can a Google Form really add leads to the sheet by itself?

Yes. Connect a Google Form to the sheet and every new inquiry lands as a new row on its own, with no copying from email by hand. That row then gets the same stage dropdown and follow-up formulas as every other lead.

When should I switch from a spreadsheet to a real CRM?

When your team grows. A sheet is perfect to start, but once several people are selling and handing leads to each other, a real CRM handles the sharing better. Your sheet design and stages move over with you.