A field sales rep's week looks nothing like an inside sales rep's. You have a territory, regular customers you visit on fixed days, prospects you drop in on between appointments, and a price list you quote from while standing at the counter. Desk CRMs are built around email sequences and call queues. What you need is closer to a route sheet with a memory.
Notion is a good fit for this if you work alone or in a small team: it's flexible, it works on your phone, and the free plan covers everything below. This guide walks through the databases, the few formulas that do the heavy lifting, and the views you open every morning.
The short version
- Companies get a visit day, an area, an address and a "Contact every (days)" number.
- Activities is your visit and call log. Last contact for each company is calculated from it, so you never update it by hand.
- A health formula compares days since last contact with the company's own interval, and a Going cold view lists everyone who's overdue.
- Route days collect the day's visits in driving order and join their addresses into one Google Maps link.
- Price List, Quotes and Orders turn a visit into an offer with the client's discount applied, and track what they actually buy.
The databases you need
Start small. Six databases cover most field sales work, and each one has a single job:
| Database | One row is | Key properties |
|---|---|---|
| Companies | A customer or prospect | Status, Area, Address, Visit day, Contact every (days), Discount |
| Contacts | A person you talk to | Company, Role, Phone, Email |
| Activities | A visit, call or email | Company, Type, Date, Status (Planned / Done), Outcome |
| Follow-ups | Something you promised to do | Company, Due, Done |
| Price List | A product you sell | List price, Max discount, Cost |
| Quotes and Orders | An offer, or an order you received | Company, lines (product + quantity), Total, Status |
Link everything to Companies with relations. The company page then becomes the client's file: who works there, every visit, open follow-ups, quotes and order history in one place.
Step 1: Give every company a rhythm
The single most useful property in a field CRM is Contact every (days). A key account might need a visit every 7 days, a small shop every 30. Add a Visit day (select: Monday to Friday) for customers you see on a fixed day, and an Area so you can group the territory.
Fill in the full address in one text property. You'll use it for the route link later, so write it the way you'd type it into Google Maps: street, number, city.
Step 2: Let the visit log set Last contact
Updating "Last contact" by hand is the first thing that slips on a busy day. Instead, log each visit or call in Activities and let a formula on the company find the most recent one that's Done:
prop("Activities")
.filter(current.prop("Status") == "Done")
.map(current.prop("Date"))
.sort()
.last()
Filtering on Done matters: planned visits for next week shouldn't count as contact. Then add Days since contact:
if(empty(prop("Last contact")), "",
dateBetween(now(), prop("Last contact"), "days"))
Step 3: Customer health and the Going cold list
Now compare days since contact with each company's own rhythm. A text formula keeps it readable on a phone:
if(empty(prop("Last contact")), "No contact yet",
if(prop("Days since contact") > prop("Contact every (days)"), "Overdue",
if(prop("Days since contact") >= prop("Contact every (days)") - 2, "Due soon",
"On track")))
Create a table view of Companies called Going cold, filtered to Health is Overdue and sorted by Days since contact, highest first. This is the list you scan when an appointment cancels and you have an hour free in the area.


Step 4: Today's route and a Google Maps link
For customers on fixed days, add a formula Is today to Companies:
prop("Visit day") == formatDate(now(), "dddd")
A view filtered to Is today = checked shows today's regulars with their address, phone and health. For everything else, create a Route Days database: one row per working day, related to the planned visits in Activities, in the order you want to drive them.
Google Maps accepts a directions link made of addresses separated by slashes, so a formula can turn the day into one tap:
link("Open route in Google Maps",
"https://www.google.com/maps/dir/" +
prop("Visits").map(current.prop("Address")).join("/"))
Notion doesn't reorder stops for you; the link follows the order of the visits on the page. Add a "Start from" address in front of the list if you start from a warehouse or office every morning. Very long days may hit the number of stops Google Maps accepts in one link, so split them into two route days.


Step 5: Quotes from your price list
Quoting at the counter is where a spreadsheet usually comes out. In Notion, give each product a List price and a Max discount, and each company a Discount. A quote is a page with one related row per product line, and each line uses the smaller of the two discounts:
min(prop("Client discount"), prop("Max discount"))
Line total is list price × quantity × (1 − that discount), and the quote's Total is a rollup sum of its lines. If you also enter what the client pays today, a "Client saves" rollup shows the difference, which is a strong line to read out when you're switching someone from another supplier.
Skip the setup
Field Sales CRM has all of this built and connected: visit days, the visit log, Going cold, route days with Google Maps, the price list, quotes, pipeline, orders and a dashboard that works on the free Notion plan.
See Field Sales CRM →Step 6: Follow-ups you actually see
Every visit ends with either a next step or nothing. If there's a next step, add it to Follow-ups with a due date before you start the car. On the CRM home page, show one view: not done, sorted by due date. Overdue items at the top are your first calls in the morning.
Using it on the road
- Pin the home page in the Notion mobile app. Today's route, Follow-ups and Going cold should all be on it, nothing else above them.
- Log the visit before you drive off. Type, outcome, a one-line note. Thirty seconds now saves the Friday evening catch-up.
- Keep phone numbers on the company row as a phone property, so calling is one tap from any view.
- Plan the week on Friday. Create next week's route days and drag the planned visits in. Monday morning starts with a link, not a decision.
Start free, upgrade when you need more
If you only need a customer list with next steps, Simple CRM Lite is free: companies, contacts and follow-ups on one page, sorted by last contact. When you want routes, quotes and a dashboard, Field Sales CRM adds them in six colors for a one-time price.
Bottom line
A field sales CRM in Notion comes down to three things: a contact rhythm for every company, a visit log that keeps last contact honest, and views built for the car rather than the desk. Get those right and the rest, routes, quotes and orders, slots in around them. If you like to review your week before planning the next one, our guide to the weekly review in Notion pairs well with Friday route planning.
Frequently asked questions
Can Notion work as a CRM for a sales rep?
Yes, for one rep or a small team. Notion databases with relations cover companies, contacts, visits, follow-ups, quotes and orders, and formulas can calculate last contact and customer health. It does not dial phones, sync email or optimise routes, so it suits reps who want one organised place rather than automation.
Does a Notion CRM work on the free plan?
Yes. Databases, relations, rollups and formulas all work on the free Notion plan. Only Notion's chart views are limited on the free plan, so build your dashboard numbers with formulas instead.
Can Notion plan a route in Google Maps?
Notion cannot optimise a route, but a formula can join the addresses of the day's visits into one Google Maps directions link in the order you choose. Open it on your phone and Google Maps calculates the drive.
How do I see which customers I haven't visited in a while?
Give every company a Contact every (days) number and a Last contact date calculated from your visit log. A formula compares the two and a filtered view called Going cold lists every customer past their interval.