Do a Google Search on mapping customer addresses and you'll get all sorts of overly complicated ways to do it with third party stuff, etc.
Google Spreadsheets does it very easily "out of the box", well that is... in the cloud for free.
Follow these steps published by Google:
http://support.google.com/docs/bin/answer.py?hl=en&answer=91601 to use a gadget for mapping addresses from the rows of a Google Spreadsheet. Last column as tooltip is how you can show the customer name.
In our case we used a Google Apps Script to populate the rows of the Google spreadsheet instantly from our Norada Solve360 CRM using this:
http://goo.gl/DyV0F
So now with a few clicks we can display a real time map of our customer locations and refresh it instantly.
If you have a more complex reporting/spreadsheet need that might require Google Apps Script programming contact us at
Interlockit.com.
Enjoy!
This was a terrific tool!
ReplyDeleteUnfortunately, now that Google is deprecating gadgets for their spreadsheets, do you have any other suggestions?
Nevermind. I just found a great solution. Generate the address report from Solve360 as you suggest, then paste the addresses into http://batchgeo.com (I also pasted the person's name).
ReplyDeleteVery quick. Very elegant.