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
Get a workspace
Create a free Customermates workspace with this template preselected, or use your own self-hosted instance.
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.
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
- Lead
- Qualified
- Proposal
- Negotiation
- Won
- 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.
Open the pipeline board and look at each stage: what moved this week and what did not.
Open the deals without a next step and give each one a dated next step, or close it.
Check the deals with an expected close date in the coming month and move the dates that have slipped.
Clear the overdue actions: do them, move them or drop them.
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?
When is a spreadsheet no longer enough for customers and deals?
Do I have to design the CRM myself?
What does not come across from my old tool?
How is this different from a bespoke CRM built by an agency?
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.