google maps

Plan your sales route with Google Maps and OnePageCRM

If you’re in field sales and are constantly on the road, calling into potentially new/ existing customers, time is precious. To ensure you make the best use of your time, here’s an efficient way to plan your trip using your OnePageCRM contacts and Google Maps.

Traveling salesman problem

Great, so you’ve arranged a meeting with a potential new client, but they’re based in Los Angeles and you’re in San Diego. It’s within your territory but a long way for just one sales call. Well, why not make the most of your journey and drop into all of your existing clients along the route or in that area, just to say “hi, or try to set up other first meetings with new leads along the way?

Solution?

Here’s how to create a quick and easy way of mapping your contacts in the same area – Using OnePageCRM and Google Maps in 4 easy steps.

  1. Find the relevant contacts in OnePageCRM by running a filter for the City/ Area – say, “Los Angeles”. Please save this filter.
  2. Export the filtered contacts to Excel by going to Account and choosing Export
  3. Go to www.googlemaps.com, select My Places and Create Map. Then Create a new map and Import using Excel CSV
  4. Select the Companies and Addresses and there you go!

Just take a look below!

Sales_Route_2

 

Sales_Route_3

Sales_Route_4

Sales_Route_6

Now you have all your contacts shown conveniently on the map so you can plan your journey in advance to make the most of your time. And remember you can use your iPad to view it all!

Another time saving and pro-active benefit for your sales function from OnePageCRM. Now you access your contacts on the go with our native Android and iOS mobile apps.

You can download our OnePageCRM mobile app from Google Play or the App Store.

Mobile-banner_header_2mobile_banner_lower_2

 

 

 

 

Carmel Granahan
Carmel Granahan
Coming from a background in various industries like Insurance & Healthcare – main focus always been on Customer Satisfaction - Zappos style of course. Other interests include; taking part in outdoor activites, running & exploring new places.

4 Comments

  1. Russell says:

    I found this very useful. You do have to edit the columns in excel to remove special characters created by the quick export. I saved my map to Google Maps and named it. I then tried to open it in Google Maps App on my ipad. I could not figure out how to find a saved map after signing in on the app. I did however send the map link form my desktop to an email then opened the link on my ipad. That worked. I wish this functionality was seamless from the onepage CRM app on the ipad without this workaround.

  2. Carmel Granahan Carmel Granahan says:

    Hi Russell, thanks for your comments, good to hear you found it useful (even with the workaround). To be honest, I didn’t take the iPad into consideration when writing the above post, but I’ll be sure to check it out and revert back to you with my findings – if you could email your details to support@onepagecrm.com – I can pick it up there. Thanks again for the review! ^Carmel :)

  3. Maciej says:

    What if I have hundreds of contacts? Am I supposed to manually remove all the special signs for them? If you could just do it like pipedrive, it would be perfect for me.

    • Carmel Granahan Carmel Granahan says:

      Hi Maciej, I’m not 100% sure what you mean when you say special signs, but I’ll be sure to follow up with you via email. At the moment, you must remove any additional fields from the export before importing onto Google Maps or if you want to find a contact individually on the map, you can do so at a contact level within OnePageCRM. Keep the feedback coming! ^Carmel :)

Leave a Reply

Your email address will not be published. Required fields are marked *