Your own CRM

A Google Sheets alternative for customers and deals: your AI agent builds the CRM and imports your data

If your customers and deals live in a spreadsheet, a Notion page or an old tool, a custom CRM replaces it without a migration project: contacts, organizations, opportunities and dated actions shaped around how you sell. Paste this template into your AI agent. It asks how you work, builds the CRM in Customermates and imports your data. You approve the plan before anything is built.

No credit card required. First 14 days free.

How it works

  1. Get a workspace

    Create a free Customermates workspace with this template preselected, or use your own self-hosted instance.

    Start free trial

  2. Paste the prompt into your AI agent

    Copy the prompt below into Claude, ChatGPT or Codex, connected to your workspace. It reads your workspace first and proposes the setup in plain words.

  3. Approve the plan

    Nothing is written until you say yes. The agent creates no sample records, sends nothing and tells you what exists when it is done.

The prompt

One self-contained prompt. Choose where your workspace runs, then copy it.

 

What the agent creates

Lists, fields, stages, views and dashboard widgets, as the plan your agent proposes. You can rename or drop any part.

  • 4 lists
  • 23 fields
  • 6 views
  • 8 dashboard widgets
  • 7 follow-up rules
  • Contacts

    The people you deal with.

    • Job title
    • Role
    • Language
    • Last contact
    • Consent to contact
  • Organizations

    Companies and other bodies.

    • Relationship
    • Owner
    • Source
    • Website
    • Address
    • Imported from
  • Opportunities

    One deal from lead to won or lost.

    • Stage
    • Owner
    • Expected close
    • Next step
    • Next step due
    • Lost reason
    • Weighted value
  • Actions

    One dated next step per open item.

    • Kind
    • Status
    • Due date
    • Owner
    • Outcome
  • Stage

    1. Lead
    2. Qualified
    3. Proposal
    4. Negotiation
    5. Won
    6. Lost

Views

  • Pipeline
  • All opportunities
  • No next step
  • All organizations
  • All contacts
  • All actions

Dashboard

  • Open opportunities by stage
  • Open value
  • Open weighted value
  • Lost reasons
  • Deals without a next step
  • Upcoming actions
  • Overdue actions
  • Recent activity

The Friday review of your CRM

The template builds the routine this work already has, so it keeps running after the setup.

  1. 1

    Open the pipeline board and look at each stage: what moved this week and what did not.

  2. 2

    Open the deals without a next step and give each one a dated next step, or close it.

  3. 3

    Check the deals with an expected close date in the coming month and move the dates that have slipped.

  4. 4

    Clear the overdue actions: do them, move them or drop them.

  5. 5

    Fix what the import left behind: duplicate contacts, a missing owner, a record without a next step.

Follow-up rules

  • Create a follow-up Action when an opportunity changes stage

    Runs through your agentDue after 3 days

  • Ask for a next step on every open opportunity that has none

    Runs through your agentDue the same day

  • Tell the owner when a next step is due

    Automation ruleDue the same day

  • Review an open opportunity the day after its expected close

    Automation ruleDue the same day

  • Run the weekly review every Friday

    Runs through your agentDue the same day

  • Create the contact, organization and opportunity from an inquiry form

    Automation ruleDue after 1 day

  • Create or update records from the old tool through an incoming webhook

    Automation ruleDue the same day

Knowledge pages it seeds

Outlines for your own Knowledge Base, filled in with your facts. They are starting points, not finished policies.

  • How we use this CRM

    • What goes in and who updates it
    • Stages and when a deal moves
  • Data entry rules

    • Names, emails and one record per person
    • A next step with a date on every open deal
  • Import notes: what came from where

    • Source tool and export date
    • What did not travel and why

Bring your data: switch kits

Your agent reads an export of the tool you use today and builds the same data in your workspace. Each kit says what moves, how to export and what stays behind.

Switch kit: Google Sheets and Excel

Replaces: A CRM kept in a workbook, with sheets for organizations, contacts, deals and interactions, or one flat list.

What moves
One sheet per list: organizations, contacts and deals map to lists, stage text to stage options, values and dates to fields. Interaction rows become dated Actions or notes, as you choose.
How to export
In Google Sheets open the File menu and save the workbook as Microsoft Excel (.xlsx). In Excel keep the .xlsx or save as CSV UTF-8. Customermates reads .xlsx directly, so one workbook with one sheet per list is the cleanest input.
What does not travel
Formulas arrive as values only. Conditional formatting, charts, dashboards, validation lists and macros do not travel.

Your agent never changes the tool you leave. It reads your export, shows how the columns map, waits for your confirmation and imports one list at a time. The import reads .xlsx and CSV files up to 10 MB and five thousand rows per sheet, and the Free plan holds 250 records.

Start free trialTemplateExport steps checked on November 12, 2026.

Switch kit: Notion

Replaces: A CRM in one or several databases, with status, select, person, number and relation properties.

What moves
Titles become names, status becomes stage options, select and multi-select become choice fields, people become team members, numbers and dates become fields. Page bodies come over only if you ask for them.
How to export
Open the database, choose the three-dot menu, then Export, then Markdown and CSV. You get a ZIP with the CSV and one Markdown file per page. Relations export as plain text, so the agent rebuilds the links by matching titles and lists what it could not match.
What does not travel
Views, relations as links, rollups and formulas as logic, templates and automations do not travel. Notion does not say whether uploaded files are in the export.

Your agent never changes the tool you leave. It reads your export, shows how the columns map, waits for your confirmation and imports one list at a time. The import reads .xlsx and CSV files up to 10 MB and five thousand rows per sheet, and the Free plan holds 250 records.

Start free trialTemplateExport steps checked on November 12, 2026.

Switch kit: Airtable

Replaces: A base such as a sales CRM with accounts, contacts, interactions and opportunities.

What moves
One CSV per table becomes one list. Single select becomes a choice field, collaborators become team members, and linked-record columns become relationships that the agent creates after the import. Formula and rollup columns arrive as values.
How to export
Open the view menu and choose Download CSV. Each table is downloaded separately, and filters in the view limit the rows. Attachment fields export as links that expire after about two hours, so download the files promptly.
What does not travel
Views, interfaces, automations, forms, formulas as logic and the attachment files themselves do not travel.

Your agent never changes the tool you leave. It reads your export, shows how the columns map, waits for your confirmation and imports one list at a time. The import reads .xlsx and CSV files up to 10 MB and five thousand rows per sheet, and the Free plan holds 250 records.

Start free trialTemplateExport steps checked on November 12, 2026.

Switch kit: Trello

Replaces: A board where lists are stages and cards are leads or deals.

What moves
List names become stage options, card names become deal names, labels become choices, due dates become next-step dates, descriptions become notes and members become team members. Your agent first asks what a card is: a person, a company or a deal.
How to export
Every board member can export a board to JSON, which also holds the most recent comments. CSV needs a Premium workspace and leaves out comments. Neither format can be imported back into Trello.
What does not travel
Butler automations, power-ups, cover images and template cards do not travel.

Your agent never changes the tool you leave. It reads your export, shows how the columns map, waits for your confirmation and imports one list at a time. The import reads .xlsx and CSV files up to 10 MB and five thousand rows per sheet, and the Free plan holds 250 records.

Start free trialTemplateExport steps checked on November 12, 2026.

Switch kit: Smartsheet

Replaces: A client tracker or CRM sheet with a deal stage dropdown.

What moves
The exported sheet becomes a list, dropdown text becomes choice options, and contact columns become team members or contact names. Grouped parent and child rows are flattened, which the agent asks you about.
How to export
Save the sheet as an Excel workbook from the file menu. Owners, admins and editors can do this on paid plans. Comments and the sheet summary come on separate tabs.
What does not travel
Formulas, groupings, summary rows, attachments, dashboards and workflows do not travel.

Your agent never changes the tool you leave. It reads your export, shows how the columns map, waits for your confirmation and imports one list at a time. The import reads .xlsx and CSV files up to 10 MB and five thousand rows per sheet, and the Free plan holds 250 records.

Start free trialTemplateExport steps checked on November 12, 2026.

Switch kit: ClickUp

Replaces: A CRM list with many statuses and custom fields for contact name, email, sales stage and service.

What moves
Task names become deal or organization names, depending on the CRM item type, which the agent uses to split one export into several lists. The many statuses collapse into the four to six stages from your interview.
How to export
Use Export Items in the workspace settings for a CSV of all tasks, or export a list or table view as CSV or Excel. Menu names change, so check them in the current app.
What does not travel
Views, dashboards, automations, docs, time tracking, dependencies and Gantt charts do not travel.

Your agent never changes the tool you leave. It reads your export, shows how the columns map, waits for your confirmation and imports one list at a time. The import reads .xlsx and CSV files up to 10 MB and five thousand rows per sheet, and the Free plan holds 250 records.

Start free trialTemplateExport steps checked on November 12, 2026.

What it does not do

Know the limits before you start.

  • It is not a no-code app builder. There are no custom screens, customer portals or scripts: you get lists, relationships, table, board and calendar views, dashboards and your agent. If you need an app builder, use one.
  • It is not a free-form workspace. Notion and Airtable stay better for pages, wikis and data that has nothing to do with customers.
  • There is no two-way sync with your old tool and no undo for an import. The import is a one-way copy after you have checked the mapping, and nothing in the source is changed or deleted.
  • There are no Gantt charts, resource planning or timelines. Project tools keep that job.
  • There are no field-level permissions. If some columns must stay hidden from colleagues, put them in a separate list with its own access.
  • Reminders come from automation rules and notifications, or from a routine your agent runs on a schedule. The template proposes them and you decide which ones to switch on.

Frequently asked questions

How do I move from Google Sheets or Excel to a CRM?
Tell the agent which columns you really use. It proposes lists and fields, checks a sample of rows for duplicates and unknown values, and imports once you have approved the mapping. Customermates imports Excel and CSV files through a column-mapping wizard, and your agent can import records through MCP. The import is a copy: your sheet stays as it is until you decide to stop using it.
When is a spreadsheet no longer enough for customers and deals?
CRM vendors' guides put the limit somewhere between 25 and 200 contacts, or at the moment several people edit the same file or nobody is reminded of a follow-up. A CRM helps then: contacts are linked to organizations and deals, next steps are dated actions and the conversations sit next to each record.
Do I have to design the CRM myself?
No. The agent interviews you first: what you sell, the real stages from first contact to done, what you check every morning and every Friday, who else uses it, where your data lives today and what stays in another tool. It proposes the model and builds it after you approve. You can change stages, fields and views later by asking.
What does not come across from my old tool?
The import copies records. Automations, forms, views, comments and attachments do not travel, and relations that your old tool exported as plain text have to be rebuilt. The agent notes where each imported record came from, so you can trace it later.
How is this different from a bespoke CRM built by an agency?
Agencies that build a custom CRM quote several months. Here the CRM already exists, with roles and access per list, and only its content is yours: the stages, fields and views. A first working pipeline can come out of one conversation, and you read it back yourself before you rely on it.

Sources

The practice behind this template comes from these pages.

Customermates

Start your Custom CRM today

Start a free trial, paste the prompt and approve the plan.

No credit card required. First 14 days free.