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

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 ?





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 .

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
    • Sticky Posts

    • 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

    Zoho Pagesense Resources

        Zoho SalesIQ Resources



              Zoho TeamInbox Resources

                Zoho DataPrep Resources


                    Zoho CRM Plus Resources

                      Zoho Books Resources


                        Zoho Subscriptions Resources

                          Zoho Desk Resources

                            Zoho Projects Resources


                              Zoho Sprints Resources


                                Qntrl Resources


                                  Zoho Creator Resources


                                    Zoho WorkDrive Resources




                                        Zoho Campaigns Resources

                                          Zoho CRM Resources

                                                      Design. Discuss. Deliver.

                                                      Create visually engaging stories with Zoho Show.

                                                      Get Started Now