The Official Salesforce Blog

The Official Salesforce Blog

Integrating Google Maps with Salesforce.com

Jamie Grenney Feb 11, 2005

Googlemaps_2From: Benji Jasik

For those of you who haven't seen google maps yet, it's really amazing. 

Here's a WIL that works on contacts:

 

Here's one from Matt Browning that gives directions from the user’s address to the contact’s address.

Doing a search on a custom homepage might also be useful.

How about using maps to do data cleansing? If you don't have the zip, it figures it out, then somehow we write it back? They have an XML interface where maybe we could consume that info with an scontrol? 

I'm sure you could also build a web link that would take the user's home address, and immediately route the directions from the user's address to the contact address.

Other ideas for how this could be used? -B

 

31 Comments

That's a really great WIL addition. It's actually much better than the Yahoo WIL that comes out of the box in salesforce.com. Since I work in French Canada (Quebec), all the French street names with accents weren't working properly but they do in Google Map.

Thanks for sharing this tool.

Yvan

I've found an issue with the "Directions" WIL. It seems that if my destination address contains a "suite", ex: 4444 Johnson street, Suite 200. Google won't be able to map directions to that location, where a simple map of that same address will pinpoint the exact location of the building. Anyone has been across this issue yet?

Integrating Google Maps is a great idea, but for data cleansing Salesforce should integrate with AutoAddress from Avalara. AutoAddress is a product designed to insure accuarate addresses and validates them using the latest technologies.

Here is our Blog

This is a terrific new Google feature, and a nice WIL. Is there a list or directory of WILs that other users have created which could be shared? If not, can someone create a topic on this blog dedicated to sharing clever WILs that users have created?

I've also discover that you can utilize the other Google features.

For example:

I have created a Restaurants near by WIL, which is: http://maps.google.com/maps?q=restaurant near%20{!Contact_MailingAddress}%20{!Contact_MailingCity}%20{!Contact_MailingState}%20{!Contact_MailingPostalCode}

and also a Hotels near by WIL, which is: http://maps.google.com/maps?q=hotel near%20{!Contact_MailingAddress}%20{!Contact_MailingCity}%20{!Contact_MailingState}%20{!Contact_MailingPostalCode}

Now you can quickly find a restaurant or hotel near by a lead, account, contact.

Enjoy,

How do I set up these WIL's?

Here is where you set up a custom link for the Accounts Page.
https://na1.salesforce.com/setup/ui/link/custlinklist.jsp?retURL=%2Fui%2Fsetup%2FSetup%3Fsetupid%3DAccount&type=Account&pageName=Account&setupid=AccountLinks

I keep getting an error message that says
"Bad Link Definition"

It should work fine. I've tried it on two accounts.

To manually navigate there you can go to Setup, Customize, Accounts, Custom Links

Can someone share explicit instructions on how to load these? I got to the point where you put in a custom link, but could not determine where to paste the code. Any help would be much appreciated.

-Tim

I found the error in the "bad link definition." If you use the "custom links" wizard, you'll see above where it says "available merge fields." If you paste what is suggested in the "directions" code above, there's an error - it's not {!User_Address}, it's {!User_Street}. Same on the contact address.

I'm not a technical resource but my company would like to get this link installed. Is there a way that someone could list out the steps to do this - like for a 3rd-grader? "1. open "custom links" 2. Paste the following code. 3. Etc.

Thanks!

I'd like to see this done as an sforce control. Are there any ideas on how this can be done user javascript inside an sforce control?

Here is the code for a custom link to a Google Map to an Account Billing Address:

http://maps.google.com/maps?q={!Account_BillingStreet}%20{!Account_BillingCity}%20{!Account_BillingState}%20{!Account_BillingPostalCode}

Here are some Hotel and Restaurant custom links for Accounts as well:

http://maps.google.com/maps?q=hotel near%20{!Account_BillingStreet}%20{!Account_BillingCity}%20{!Account_BillingState}%20{!Account_BillingPostalCode}

http://maps.google.com/maps?q=restaurant near%20{!Account_BillingStreet}%20{!Account_BillingCity}%20{!Account_BillingState}%20{!Account_BillingPostalCode}

And Map, Hotels, and Restaurants for Leads:

http://maps.google.com/maps?q=from%20{!Lead_Street}%20{!Lead_State}%20{!Lead_PostalCode}

http://maps.google.com/maps?q=hotel near%20{!Lead_Street}%20{!Lead_City}%20{!Lead_State}%20{!Lead_PostalCode}

http://maps.google.com/maps?q=restaurant near%20{!Lead_Street}%20{!Lead_City}%20{!Lead_State}%20{!Lead_PostalCode}

I also found an issue when adding a suite or unit number within the "Billing Street" field under Accounts, the maps.google link does not work.

Any work arounds for this?

Yahoo has a new dynamic map web app called Yahoo Local. Its got some great features and a good API. It seems that the standard Salesforce.com custom link to Yahoo Maps is now redirected to the new Yahoo Local mapping service.

Does anyone know how to write a Custom Link URL for Yahoo Local to display search categories like 'Hotels' or 'Restaurants', like you can do with Google Maps/Local as demonstrated below?

Does anyone know how to set up a correlation between googlemaps and salesforce, that when you click on google maps in the account section, not only will that account come up, but also any other account/lead within a radius of 20 or so miles?

Is there a way for our users to plot their course throughout the day using Google map? For example, is it possible for someone to set one account as their start point and then link four or five other accounts using Google? (Ex: Start at ABC shop to DEF Shop to GHI Shop)

Has anyone had any feedback from their teams using Google maps? Thanks.

Hi Benji Jasik,

This is Bennett Fonacier from Bay.Net. Thanks for the great presentation you all provided for the Bay.Net usergroup. The Google mashup was the highlight.

Best Regards,
Bennett

Has anyone found a way to draw sales territories with Google Maps yet?

Sometimes I too have got an error message that says "Bad Link Definition". For outsourcing voice, chat, email or back-office support, visit the website http://callcenter.ramshyam.com

Wow! I could actually see the aerial view of my house, not very clear though. I shudder to think how this could be misused.

When searching, has anyone received the "access denied" message? If so, is there a fix?

Caroline, can you give me the URL where you received that error? I will get it fixed.

Post a comment