Google Maps lead tracker templateThe exact columns, then fill it in seconds
Copy this simple lead tracker layout, then skip the typing: capture businesses with the free Vonsel Chrome extension and export a file that already fits every column.
Chrome Extension··7 min read
Key takeaways
A good tracker has 11 columns: name, category, address, phone, website, email, rating, review count, status, next action, and notes
Do not type rows by hand. Capture a Google Maps search with the free Vonsel Chrome extension and export a file that already matches these columns
The spreadsheet is the start. The Vonsel dashboard turns the same data into a mapped CRM with review and email intelligence you can sell from
The layout
The lead tracker template, column by column
A lead tracker only works if it has the right columns: enough to act on a lead, not so many that nobody keeps it updated. Here is a layout that has held up across thousands of local prospecting lists. Recreate it in Google Sheets, Excel, or any spreadsheet you already use.
The trick is to split the columns into two groups. The first group is captured data that comes straight from Google Maps and should never be typed by hand. The second group is your working fields: the status, the next step, and the context that turns a raw listing into a real sales lead.
Column
What it holds
Source
Business name
Exact name as listed
Captured
Category
Primary Google Maps category
Captured
Address
Full street address
Captured
Phone
Public listed number
Captured
Website
URL, or blank if none
Captured
Email
From website enrichment
Captured
Rating
Star average (1 to 5)
Captured
Review count
Number of reviews
Captured
Status
New, contacted, replied, won, lost
Yours
Next action
Call back, send email, visit
Yours
Notes
Context, pain point, owner name
Yours
That is it. Eleven columns keep the sheet scannable. If you want a full pipeline layout with stages and dates, our sales pipeline template extends the same idea. For now, keep it lean so the sheet actually gets used.
Fill the template without typing
Capture a whole Google Maps search into these exact columns with the free extension. Free download. No trial, no credit card.
The reason most lead trackers die is data entry. Copying a business name, address, phone, and rating from Google Maps takes about a minute per listing, and a single search can return more than a hundred results. Nobody keeps that up past the first afternoon.
The free Vonsel Chrome extension removes that step entirely. You run a normal search on Google Maps, for example dentists in Austin or roofers near me, open the Vonsel pop-up, and it captures the visible results into a structured list. It even runs quiet website enrichment to pull public emails and social profiles that never appear on the map card itself.
When the capture finishes, export to CSV or XLSX and the columns already line up with the template above. You paste one file instead of copying dozens of listings by hand. For the end-to-end version of this, see the search-to-CRM workflow.
11
columns cover every field you actually need to work a lead
1
export replaces an afternoon of manual copy and paste
$0
to install and use the extension: no trial, no credit card
Working the list
How to actually use the status and notes columns
The captured columns are static. The three you own are where deals are made. Keep the rules simple so the sheet stays honest.
Status: one word, always current
Use a short set: New, Contacted, Replied, Meeting, Won, Lost. A drop-down list keeps it consistent so you can filter and count at a glance.
Next action: a verb and a date
"Call Tue" beats "follow up." Every open row should carry the single next step, so a glance down the column becomes your task list for the day.
Notes: the hook, not a diary
Record the reason this business is a fit: no website, weak rating, a recurring complaint in reviews, the owner's name. That context is what personalizes outreach.
Sort by review count and rating
The rating and review columns you captured double as a scoring signal. A busy business with a slipping rating is often a warmer lead than a quiet perfect one.
Follow-up discipline matters more than list size. Sales research has long shown that most reps stop after a couple of attempts while most conversions happen later in the sequence, which is exactly why the next action column earns its place. See HubSpot's free CRM if you later outgrow a flat sheet and want reminders baked in.
A spreadsheet is a great place to store leads and a poor place to sell from. It cannot show you where your leads cluster on a map, score them by the pain points hiding in their reviews, or draft a first email for each one. That is the line between a tracker and a working pipeline.
Beyond the spreadsheet
When the tracker should become a mapped CRM
A flat sheet is fine for your first fifty leads. It starts to strain the moment you are managing territories, chasing follow-ups, and trying to figure out which twenty rows to call first out of five hundred.
That is the point of the Vonsel dashboard. The same capture that filled your spreadsheet also loads into a mapped CRM, so every lead appears as a pin you can filter, cluster, and route between. You can track status on the map instead of scrolling a status column, and divide a city into zones for a field day.
On top of that sit the intelligence layers. Reviews Intelligence reads each business's reviews and surfaces the recurring complaints, which is a ready-made hook for your notes column. Email Intelligence drafts a tailored first email per business using that context. You can also reopen an earlier capture and add more results to it, or attach fresh reviews to businesses you already saved, without starting a new sheet. Explore the full set on the features page.
The extension gets the data in. The dashboard is where the data becomes revenue. The template in this post is simply the on-ramp: start with it today, and graduate to the CRM when the list outgrows the grid. If you capture in batches, scrape history keeps every run labeled and reopenable.
Turn the template into a pipeline
Capture once, then work leads on a map with review and email intelligence. Free download. No trial, no credit card.
Freeze the header row and turn on filters so you can sort by status, category, or rating in one click. Add a simple color rule: red for Lost, green for Won, so the sheet reads at a glance.
Deduplicate before you import. If you capture the same city twice, a listing can appear in both files. Sort by phone or address and remove repeats so your counts stay real. Note that Google Maps caps a single search near 120 results, which is why capturing by neighborhood or category and stacking the exports beats one giant query.
Finally, keep the captured columns and the working columns visually separate. A thin divider or a color band between "Review count" and "Status" reminds everyone that the left side is facts and the right side is your judgment. Browse more setup guides in the Chrome Extension hub.
A template stores rows. A mapped CRM closes them
Ready to fill your tracker in one click?
Add the free extension, capture a Google Maps search, and export straight into these columns. Free download. No trial, no credit card. Explore features or read more guides.
What columns should a Google Maps lead tracker have?
A useful tracker has business name, category, address, phone, website, email, rating, review count, status, next action, and notes. The first eight come straight from a Google Maps capture. Status, next action, and notes are the fields you own and update as you work each lead.
How do I fill a lead tracker template quickly?
Typing rows by hand is slow and error prone. Instead, run a search on Google Maps, capture the results with the free Vonsel Chrome extension, and export a clean CSV or XLSX that already matches these columns. You paste one file instead of copying dozens of listings one at a time.
Is a spreadsheet enough to track leads from Google Maps?
A spreadsheet works for a first list, but it does not show leads on a map, score them by review pain points, or draft outreach. The Vonsel dashboard turns the same captured data into a mapped CRM with review and email intelligence, so the tracker becomes a place to sell from, not just a place to store rows.
Add Chrome Extension