Can we write our front end design and use the google spreadsheet for the back-end for a website?
Thank You
Google Apps Script might also be a good option for you. You can host your code on the Google servers (all written in JavaScript) with easy access to all the spreadsheet and docs APIs. You can see a lot of tutorials on the site.
Another even simpler option might be Google Forms - if you are just trying to gather some data and record it in the spreadsheet.