Thursday, April 26, 2012

Show your customer addresses on Google Maps

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!

2 comments:

  1. This was a terrific tool!

    Unfortunately, now that Google is deprecating gadgets for their spreadsheets, do you have any other suggestions?

    ReplyDelete
  2. 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).

    Very quick. Very elegant.

    ReplyDelete

Note: Only a member of this blog may post a comment.