Mashing it up with Zoho Sheet and Zoho Creator

Our users have created some cool mashups using Zoho Sheet and Zoho Creator. The first two examples are from Jynn, a software engineer from Hyderabad, India. In the first application, Jynn mashes up Zoho Creator, Google Maps and Yahoo Pipes.

Zoho Creator offers end users a brand new way to perform basic CRUD operations using the web both as a database and for processing data.

Here I will briefly describe how I used Google Maps to Integrate with Zoho Creator,Using simple transformations with Yahoo pipes.

The application and its uses:
This Integration i.e Creator +Maps can be used in many ways e.g., Tracking Inventory, tracking Human resources, Basic Travel maps or even geographic maps of movie theatres where a current movie is playing.

This application overlays Zoho creator data onto a Google Map i.e in this case Movie Theatres where a particular movie is playing shown on a Google map.
Zoho creator is used to update movie info using the UI or even Bulk upload and Google maps is used to overlay the data.

I also used the cool technology of Yahoo Pipes to basically transform the Feed generated by Zoho Creator.

In the second example, Jynn uses Zoho Sheet along with Dapper, Yahoo Pipes and Google Maps. Here’s how Jynn describes the application :

The Application:
There is a live excel sheet hosted on Zoho Sheets,which gives info on Radio stations in India for radio Enthusiasts….

Updating the sheet with coordinates will be immediately reflected in the Google Maps

Technology Used:

Zoho Sheet:
Can be embedded onto your blog/webpage (Here it is in my blog),and contains City name and Location

Dapper :
This is the killer app which I used to parse the HTML output from Zoho Sheet and convert to RSS.

Yahoo Pipes:
To extract Geo Encoded data From The RSS feed…

The next one comes from Pete Thomas of Land of Zoho Creator fame. Pete mashes up Oodle, the local classifieds site with Zoho Creator. Nicknamed Zoodle, the prototype mashup creates the work flow of the customer service process for Pete’s friend Ted. From the post :

Zoodle will let Ted enter the listing data he gets from a BuggyRocket customer as it becomes available and only publish it for Oodle to pick up once it’s complete. Other features include:

  • Listing detail page: Although it’s not the slickest looking thing in the world, we do manage to provide a “detail page” served directly from Zoodle. We also provide an image URL in the same fashion.
  • Private application with some public pages: Ted’s use of Zoodle requires his authentication but the detail page, image URL, and Oodle XML feed are all publicly available on the web.
  • Gradual approach to form completion: Through the use of several forms that are attached to the main “Essentials” form, Ted can easily fill out the parts of a real estate listing that he currently has data for and come back to finish the rest at any time before publishing.
  • Republishing: Data can be edited, overwritten, and republished at any time.

Thanks Jynn & Pete!

If you have such mashups made using Zoho, please do leave your comments.

Comments

2 Replies to Mashing it up with Zoho Sheet and Zoho Creator

Leave a Reply

Your email address will not be published.

The comment language code.
By submitting this form, you agree to the processing of personal data according to our Privacy Policy.

Related Posts