However before proceed you might want to watch video that I posted on Youtube.com so you can see what can do ?
Based on your business needs you might want to map some area on Map or pinpoint a location that totally depends on your needs. you might aware you can highlight a area like state/county and pinpoint a location in Google Maps .
for instance you have thousands of customer address like zip-codes, county ,state, country in your ZOHO .then you might want to map those all in Google maps on ZIP code level or county level or state level. that is something you can do. Note: Highlighting area ( polygon) depends on available KML file on Maps)
Here is the sample link here I highlighted all county of some selected markets that I have in my Database .
Please read the below instruction how to achieve this. I will try to provide more details as much as possible so knowing little knowledge on Google Apps Script(GAS) anyone can do this.
Here is the Flow diagram :
ZOHO (Creator/CRM/) ---->> ZOHO Reports ---->> Google Spreadsheet ---->> Google Fusion --- Maps
Step 1: First step is storing data inside ZOHO Reports from ZOHO Creator/CRM. you can do that very easily through import option and set schedule for fetching data.
you need to create a table in ZOHO Reports with ZOHO Creator data also make a location column - concatenating Zip code, county , state and country by comma that column will be used to Geo code in Google maps.
Step 2 : Export zoho reports table data to Google Spreadsheet thought Google Apps script ( ZOHO reports export API) .
I will attach Google script for fetching data from ZOHO Reports table. you need to construct export data url ( ZOHO reports export API)
Step 3 : Export google spreadsheet data into Google Fusion table and create map inside there.
Google Fusion Table
: First of all you need to have some idea about Google Fusion Table. Here is doc: click here
you might want spend some time to understand how Fusion table works and how you can create map from raw data.that will help you to understand to integrate ZOHO .
I think most of the people aware about it. nothing to know newly. click here
Google Apps Scripts: I have attached all google apps script that you need to run on google .remember that you need to replace all placeholder like construct proper zoho reports export url , Spreadsheet ID, Fusion table ID etc,
I hope that helps little for developers who are interested on . Please let me know if you have any trouble to figure out anything I will try to response.