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:

DatabaseOne row isKey properties
CompaniesA customer or prospectStatus, Area, Address, Visit day, Contact every (days), Discount
ContactsA person you talk toCompany, Role, Phone, Email
ActivitiesA visit, call or emailCompany, Type, Date, Status (Planned / Done), Outcome
Follow-upsSomething you promised to doCompany, Due, Done
Price ListA product you sellList price, Max discount, Cost
Quotes and OrdersAn offer, or an order you receivedCompany, 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.

Going cold list in Notion with customer health, days since contact, status, area and phoneGoing cold list in Notion with customer health, days since contact, status, area and phone
Going cold: everyone past their own contact interval

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.

Route planner in Notion with one row per working day, the number of stops, the planned visits and an Open route in Google Maps linkRoute planner in Notion with one row per working day, the number of stops, the planned visits and an Open route in Google Maps link
One route per day, opened in Google Maps

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.