Featured gadget: Gantt charts in spreadsheets. Cross-posted from the Google Enterprise blog. Editor's note: Hangouts On Air are live video chats, interviews, or performances that are broadcast to Google+. We’ll host these broadcasts from time to time on the Google Enterprise Google+ page to give you the inside scoop on our business and products. Last week, we hosted our first Hangout On Air from the Google Enterprise Google+ page with Jonathan Rochelle, Director of Product Management, Jeff Harris, Google Docs Product Manager, Teresa Wu, Google Docs Community Manager, and Eric Brunnett, Director of IT at Trump Hotel Collection.
During the conversation, Jonathan Rochelle told us the story of how Google Docs, Google Drive and cloud collaboration came to be. What was once an experiment to bring desktop software to the web is now a collaboration and productivity platform used by millions of people in their personal lives and at businesses, universities, non-profits and government agencies around the world. Secure Online Backup and Archiving for Gmail, Facebook, Twitter, and Wordpress | Backupify. Saving Form Data to Google Spreadsheets Using PHP and the Google Docs API. The general idea is to read a Google Spreadsheet through PHP and save user submitted form data via the Google Documents List Data API. By doing this, you can quickly view all the submissions at a glance and you are also able to export CSV files of the data. Using Google Docs gives you and your clients a quick and easy interface to interact with form data.
I’ve written a small PHP helper class to assist with the whole process (PHP5). You are going to need the following: A working copy of the Zend GData Client Library (1.0.3+)A copy of the PHP Google Spreadsheet Helper ClassA Google account, in order to be able to create a spreadsheet document using Google Docs. First you should login to Google Docs using your existing Google account. Nameemailcomments Make sure to save your spreadsheet and give it a name, you will need to use the spreadsheet name in the code below. The following is a basic example of using the Google_Spreadsheet PHP helper class. If you need to get row data … Download.
Google spreadsheets as a database. Google Visualisation API Query Language Playground Google spreadsheet key (e.g. rvWgEEGK9xuUQBR1EFcxHWA ) or spreadsheet URL Sheet number* (optional): * The number of the first sheet in a spreadsheet (which is used by default) is 0. To select thesecond sheet, add: 1; for the third sheet, add 2, and so on. Go fish... Now it's time to write your own query in two parts - the columns you want to select, and the conditions you want each returned result to satisfy. Try out some visualisation queries here... Select the columns from the list box (ctrl+click for multiple selections in IE, command+click on a Mac) or type the elements directly into the appropriate text box. select where order by So you are asking: Here is the URL for that query: , Data Scraping Wikipedia. Tony Hirst of the Ouseful.Info blog has written an excellent article explaining how you can use the importHTML function in Google Spreadsheets to retrieve data from any table in any website.
Tony uses the function to scrape data from Wikipedia tables and then uses Yahoo Pipes to geocode the data and create a Google Map mash-up (here is a Google Map showing UK city populations as scraped from Wikipedia). I've been playing with the importHTML function for a few days now (since reading Tony's article) and instead of Yahoo Pipes I've been using Batchgeocode to retrieve the latitude and longitudes and then the Google Spreadsheet Map Wizard to create a map from the data.
The Google Maps API Tricks blog also has a post on how you can use Google Maps' own geocoder. The Google geocoder can export csv-data, which can then be directly imported into a Google Spreadsheet. One of the awesome things about the importHTML function is that it is dynamic and automatically refreshes.