I'm working with a team of people who are entering property data into a google docs spreadsheet (see data sample attached). I want that google docs spreadsheet to communicate with google maps or google earth pro so that when the spreadsheet is updated the changes appear within a shared map. So far the only close solution I have found is Google Spreadsheet Mapper solution.
See link: [url removed, login to view]
The downside to this solution is that it requires me to purchase at least 1 copy of Google Earth Pro in order to add batch addresses without knowing the coordinates of the property (I DO NOT HAVE COORDINATES). Also, I would like to set it up so that the data on my spreadsheet appears in the balloon when clicked. If possible I would like to replace the property picture in the placemark balloon with an iframe pointed at google street view shots of the properties.
Option 1) Ideally I would like my Google Spreadsheet to Communicate directly with a shared google map. I will need the datat set attached programmed in so that all data appears in the placemark balloon when clicked. Also I would like and Iframe of the google street view to appear in the placemark balloon.
Option 2) If I must I can purchase a copy of google earth and use that to link to google spreadsheet. In this instance I will still need the Google Spreadsheet Mapper document modified to work with the data from the attached spreadsheet. Once again, Iframe option is desired.
If you're interested in this project please tell me how you would implement what I'm looking for along with your quote. I need this done within the next 24-48ish hours so preference will go to those who respond quickly.