How do I add a simple google map for static address (map of buisness location) using Coffecup HTML editor in Coffeecup Visual Site Designer? I have tried the suggested methods listed on Google Map API website but I just can't seem to get to work.

Use the html tool in VSD to insert the iframe code Google Maps supplies you with. Or you can use the link they provide you.