You can build a useful CRM in Google Sheets if your team needs a shared contact list, a small deal pipeline, and a record of the next action. Start with separate Contacts, Deals, and Interactions tabs, give every contact a stable ID, and use dropdowns for stages and owners. A spreadsheet can be a practical first system. It does not automatically capture leads, alert a salesperson, or keep an activity history for you.
This guide shows a working layout and the point at which a dedicated CRM becomes easier to run. If most new enquiries come from Facebook or Instagram Instant Forms, connect those forms to Google Sheets with LeadSavvy Pro and keep the same leads in its contacts and pipeline. Google Forms has its own built-in Sheets response destination; it does not need LeadSavvy Pro.
When a Google Sheets CRM is enough
A sheet works best for one owner or a small team with a modest number of active opportunities and a simple follow-up process. You can decide exactly which fields matter, share the workbook with the right people, filter it, and export it later. The software may already be available to you, though team administration and Workspace features depend on your Google plan.
It becomes harder to manage when several people need different permissions, leads arrive from multiple systems, the same contact has several deals, or nobody is sure who followed up. Sheets does not provide a built-in sales activity timeline or a Kanban deal workflow. Scripts and add-ons can fill some gaps, but each introduces setup and maintenance. The right comparison is the time and cost of the complete workflow, not just the price of the spreadsheet.
Build three tabs before adding automations
Create a workbook called “Sales CRM” and add these tabs. Keep the first row for headers and freeze it so the field names remain visible when you scroll.
| Tab | Suggested columns | Purpose |
|---|---|---|
| Contacts | Contact ID, name, email, phone, source, date received, owner, status | One row per person; the stable ID connects activity and deals back to that person |
| Deals | Deal ID, Contact ID, opportunity, stage, value, next action date, owner, notes | One row per potential sale; one contact can have more than one deal |
| Interactions | Date, Contact ID, channel, outcome, next action | A separate record for each call, text, email, or meeting |
For a one-person business, a single lead tab with a “Next action” column may be enough initially. Separate tabs become useful when contacts return, deals repeat, or the team needs to review the history without overwriting the original enquiry. Use an ID that does not change when a name or email changes; do not depend on row numbers as permanent IDs because sorting and inserting rows changes them.
Keep stages and sources consistent
Choose a short list of stages such as New, Contacted, Qualified, Quote sent, Won, and Lost. In Google Sheets, select the Stage cells, then use Data → Data validation → Add rule to make a dropdown. Do the same for owner and lead source. Google documents the current dropdown setup. Consistent values make filters and counts reliable; “Quote sent” and “Quoted” should not accidentally become two categories.
Keep the original submission date and source. If a lead came from a Meta Instant Form, a useful source value is the actual Page, form, or campaign rather than just “Facebook.” Store phone numbers as text so leading zeros and international prefixes survive. Limit workbook access to people who need the data and review sharing permissions, especially when form responses contain personal details.
Make the pipeline visible
Give the Deals tab one row per opportunity and assign a real owner and next action date. Filter Stage = New to see uncontacted enquiries. Filter Next action date before today, excluding Won and Lost, to find work that is overdue. A team can use colour rules for this, but colour should reinforce a written stage or date rather than replace it.
For a small dashboard, if Stage is column D and Value is column E on Deals, these formulas count won deals and their total recorded value:
=COUNTIF(Deals!D2:D,"Won")
=SUMIF(Deals!D2:D,"Won",Deals!E2:E)Check that values in column E are numbers and that the stage wording matches your dropdown. A more useful weekly measure may be new enquiries followed up within your target time; that needs a timestamp for first contact, not just a count of rows. Avoid presenting an attractive chart as proof that follow-up actually happened.
Bring new leads into the sheet
The right connection depends on where the form lives:
- Google Forms: open the form, go to Responses, and select a new or existing spreadsheet as its response destination. Google explains the current steps in its Forms help. Test a response, then keep the linked response tab intact.
- Facebook or Instagram Instant Forms: Meta submissions do not arrive in Google Sheets merely because the sheet exists. Use a supported connector. Our Meta lead-to-Sheets guide covers selecting the Page and form, mapping fields, and checking a test lead.
- Other website forms: check the form provider's own Sheets destination or a connector that explicitly supports that provider. LeadSavvy Pro is focused on Meta Instant Forms, not a universal website-form connector.
Keep an untouched responses tab for automated imports, and do your owner, status, and reporting work in separate columns or tabs. If a connector maps into an existing sheet, confirm which columns it writes and test a submission after any form or header change. An automated row is the start of a workflow, not evidence that a lead was contacted.
A concrete Meta-lead workflow
Consider a home-services business running an “Arrange a quote” Facebook Instant Form. The owner wants every submission in a shared Google Sheet, but also wants to call leads while travelling. They connect the Meta Page and form in LeadSavvy Pro, choose Google Sheets export, and submit a test lead. They check the name, phone, form answer, and source in the sheet and in LeadSavvy Pro contacts.
The sheet remains useful for reporting and sharing a simple list. The owner can use LeadSavvy Pro's built-in contact and pipeline tools for follow-up, and an eligible user can receive a new-lead notification in the iPhone app, open the contact, call or text, and update the deal. That avoids building an Apps Script just to alert a salesperson or trying to make a spreadsheet behave like a mobile CRM. Starter includes two active lead sources and a basic pipeline; Grow has more sources, fuller pipeline features, and ongoing app access. Check the current plan comparison for your team size.
Know when to move beyond a DIY sheet
Upgrade the workflow when the team repeatedly misses new rows, owners overwrite each other's notes, a customer has multiple opportunities, or reporting requires a reliable sequence of contact and deal events. It is also time to reconsider the sheet if access control, customer privacy, and restoring accidental edits are becoming daily concerns. The decision does not have to be all-or-nothing: keep Google Sheets as a familiar reporting destination while managing contacts and deals in LeadSavvy Pro.
For organisations with many unrelated acquisition channels, complex email nurture, or enterprise data controls, compare a broader CRM as well. For Meta-lead-heavy small businesses, the most useful test is simple: submit a sample lead, see whether it appears in the sheet and contact list, confirm the intended person is notified, and record the follow-up outcome.
Google Sheets CRM questions
If you are deciding which kind of form to connect, start with the forms-to-Google-Sheets guide; the setup differs for native Google Forms and Meta lead forms.
Is a Google Sheets CRM free?
A DIY workbook can use the Google account and plan you already have. Connecting external lead sources, running third-party automations, using paid Workspace features, or adding a specialist CRM can introduce charges. LeadSavvy Pro offers a seven-day trial, then paid plans; it is not a permanently free CRM.
Can Google Sheets replace a CRM?
For a small, manual contact and deal list, it can be enough. It does not automatically supply ownership, notifications, activity history, a mobile sales pipeline, or reliable multi-user processes. Add those capabilities deliberately rather than assuming a spreadsheet provides them.
Can I keep the sheet if I adopt LeadSavvy Pro?
Yes. Google Sheets export is part of LeadSavvy Pro's current Meta lead workflow. You can keep a shared sheet while managing the same incoming Meta leads in LeadSavvy Pro contacts and pipeline. Compare plans or start the seven-day trial.