What's inside
=INSTAMAP()=CITY()=DISTANCE()- →Use it on a tablet at the door: name, email, phone, home address.
- →The buyer map builds itself — where attendees cluster is where demand for this listing lives.
- →Distance-from-listing per visitor shows how far your marketing reached.
Set-up (60 seconds)
- Click "Make a copy" above — the template opens in your Google Sheets.
- Install the free InstaMaps add-on (100 lookups/day free; 1,000/day with a free email unlock).
- Turn the formulas on: in your sheet, open Extensions → InstaMaps → ⚡ Enable formulas (once per sheet). Any
#NAME?cells recalculate — reload the page if they linger. - Replace the sample rows with your data — every formula stays live.
Questions
Why capture the visitor's home address?
Mapping where attendees come from shows which neighbourhoods are shopping for this kind of listing — that is your next farming and mailing target.
Can I map the sign-in list automatically?
Yes — the =INSTAMAP() cell holds a live map of every visitor with an address, updating as people sign in.
Does it work offline at the open house?
Google Sheets works offline; the map and distance formulas resolve when you are back online.
More templates like this
Browse the full gallery →