Integrate Google Maps with ZOHO Creator / ZOHO CRM / ZOHO Reports Data

HI all ,

On another forum discussion I told there is a workaround to integrate ZOHO Data with Google Maps . then I am getting lots of email but I could not help enough b/c of my work pressure. so I thought It would be good if I could post the process then other developers can help ZOHO users.

However before proceed you might want to watch video that I posted on Youtube.com so you can see what can do ?

Video link : https://www.youtube.com/watch?v=_kW1DJAf1x8&lc=z23wvvbxjkngvjf0lacdp434r453uiuqfzv0qcgb4ypw03c010c

Sample link : https://fusiontables.google.com/DataSource?docid=1hHtzGvzPSKRNWeIlCjkkDQV2pydZOvdJsLbv30z8#map:id=4

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 .

link : https://fusiontables.google.com/DataSource?docid=1p4QLbulA-wER8S1GovcBXpJR6MYXD_Ga5OFQYpox#rows:id=3

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 .

Google Spreadsheet: 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.

Thanks!!

Regards ,

Arfater Rahman

ZOHO Creator Developer
arahman123@zoho.com

New to Zoho LandingPage?

Access Zoho LandingPage

Zoho LandingPage Resources

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Tout forum

France ZUGs

Zoho SalesIQ Resources

Sticky Posts
Merge and Store v1 API depreciation
Hi Zoho Writer users, The Merge and Store v1 API allows you to store the merged document in Zoho WorkDrive. The response of this API will be returned with the document's ID only after the merge is complete. In Deluge, the maximum timeout for operation
Zoho Creator Developer's Conference 2017 !!!
We welcome all our Creator Developers! You're invited to join us for our annual Zoholics Developers conference August 29th–31st! This is your chance to get training and guidance on Zoho Creator from our most knowledgeable custom app builders. Zoholics Developers is a three-day event where you'll participate in interactive workshops to hone your app-building skills, get questions answered by Creator experts with personal one-on-one sessions, and connect with other Creator developers from around
Share your success story
We would like to hear from our passionate users how much Zoho Creator has changed the way you work and benefited you. If you would like to share your story to us and be featured as a proud user of Zoho Creator, then this is for you. Fill up the form below and if you want to be included in a case study, we will get in touch with you to get further details. So what are you waiting for? Tell us your story. Charles