When Google lifted traditional office applications into its “cloud” of fast network connections, powerful servers, and seemingly limitless storage, it changed the way many of us create, organize, and share information. And, as Press Democrat reporter Nathan Halverson noted in a recent story, these free new computer applications help keep costs down.
“Unlike traditional software that is installed on your computer, these new programs run over the Internet,” Halverson wrote. “That means no installation discs, and no worrying if your computer has enough memory. If your computer can run a Web browser such as Internet Explorer, it can run these applications.”
And for those hoping to get the most out of Google Apps, German native Philipp Lenssen offers
timely guidance. In his new book–“Google Apps Hacks”–Philipp explains that working in the cloud offers a whole lot more than simply the freedom from desktop software. With Google Apps, collaborating with others near and far becomes much easier and more fun. I talked to Philipp recently about his approach to writing “Google Apps Hacks.” (Read to the end of the interview for info about how to win Philipp’s new book!)
.
SP: Why did you write “Google Apps Hacks?”
I have a great interest in Google’s approaches and tools. In 2003 I started covering them nearly daily for the weblog, Google Blogoscoped, which also kind of led to my writing the book, “55 Ways to Have Fun With Google.” When O’Reilly contacted me for a new book project covering the Google tools, I didn’t really have to think twice. It sounded like great fun–and a year afterwards I know it was indeed great fun.
SP: I understand you wrote your new book with Google Apps. How did that work?
This editor allows sharing, so when I finished a page in draft mode, I would invite Brian to the document. When Brian finished the changes, it was my turn again to use the Google document editor revision tool to highlight changes. All in all this process was great fun. We didn’t need to send around any attachments, and there were no questions like “Do you have the latest version of Word installed?” As long as the other party has a recent browser, like Firefox or Internet Explorer, the online “operating system” can start-up. (Find out more about the process here.)
SP: Why are Google Apps getting so much attention now?
It’s a rather different concept working up there in the so-called “computing cloud” than down here with our traditional, desktop-based apps. As Google’s application suite grows, it can become confusing to find out which tool to pick for which task. We all know Google search, and we all may know one or two Google applications beside that (like Gmail, for instance). But not as many of us have started using their many other online applications, like Google documents, Google Spreadsheets, Calendar, Reader, Picasa photo albums, and so on. My book introduces each of these tools and then shares tips and tricks for using them in advanced ways. It also shares hacks on how to workaround common problem still found in this rather young “online
office.”
SP: What will readers gain from reading your new book?
For those not already familiar with Google’s many apps, my book will serve as an introduction to bring you up to speed on how to use these tools; you will then be able to do your word processing, your image and video sharing, emailing and so on using browser-based programs. This will get rid of a lot of hassles of the “desktop” world, like installation and maintenance.
And for those people already familiar with Google’s apps, there will be many advanced tips that can be applied in everyday work. From programming tips to Greasemonkey scripts, from stylesheet hacking to interconnecting the different Google apps, from creating back-ups to pulling external website data into Spreadsheets, and much more. And in each chapter, we also have a Beyond Google section for those interested in other, related, but non-Google tools out on the market.
SP: What’s on the horizon?
I think it’s fascinating that only two decades ago, it simply wasn’t possible for anyone to quickly share thoughts, opinions, pictures, videos and so on with the whole world, but that today it’s all very easy, and free. Google is not the only player on this scene but they’re certainly one of the biggest. I’m really curious what this faster exchange of ideas will lead to in the next decades.
I’m giving away a free copy of Philipp Lenssen’s “Google Apps Hacks.” All you have to do is post your favorite Google Apps hack, tip, and/or workaround here by April 28. I will fairly yet arbitrarily select the winner!
Update! The contest is extended until May 7.

I LOVE Google apps.
My simplest tip is to use Google Docs to keep track of lists.
I like making lists. Lists of things to do; ideas for projects; ideas for presents for particular people.
The problem with creating them on one machine is that they can get out of sync or I forget about them.
By putting them in the cloud, I can get them from anywhere (which will be even better - I hope - when Google Android phones start hitting the market). So the syncing problem is solved.
But other options are now open to me.
I can share my gift idea list for my wife with family and friends so that we can collaborate together without her seeing it.
Or my wife and I can share a grocery list over the course of a week and I can do some shopping on my way home from work on Friday.
As simple as it is, it is very helpful.
My favorite tip is one I discovered too late!
A friend and I collaborated on an impromptu presentation while attending a recent conference. Since then we've continued to exchange ideas about refining the presentation, and each of us has re-used it a couple of times. If we had maintained the presentation on Google Docs, the ongoing collaboration would have been much more convenient and efficient.
On the other hand, I agree with Lenssen's wish for Gears support for Docs, for at least two reasons: (1) I'll be repeating the presentation in a couple of weeks in a location that doesn't have open wifi, which means I won't be able to hit any cloud-based content during that session; (2) due to concerns over information security, some companies are blocking access to Google Docs from within their networks.
InformationWeek recently had an article on how much sensitive corporate data is easily accessible on the 'Net. It will be interesting to see how the convenience of cloud-based documents balances against such concerns (whether legitimate or not - I'm not advocating either POV here).
I was able to use Google Docs in an unexpected way...
I recently used Google Docs to create a 70 page Marketing Plan for my Marketing Management course. We were in a five person team.
I was able to use the standard features to keep everyone on the same page and avoid the hassles of piece meal documents needing to be emailed and stitched together.
AN INTERESTING way I was able to use this was with the revision history feature of Google Docs. I found throughout the project I was doing most of the work. After trying to resolve the issue with my team (and with a grade at stake!) I invited my instructor as a viewer of the documents.
He was able to review the revision history and see the large amount of work put in by myself.. and helped to save my grade!
I was on my gap year travelling through Asia in 2007. Google's mymaps feature had recently been released. Every time I stopped in an internet cafe, I updated the map to show where I was. I colour coded my lines to show the modes of transport that I'd taken, and could embed images and videos into the placemarks (being stored in picasa web and youtube of course!) An excellent coincidence was that while I was making my way around China, the Chinese road system was overlayed by Google, so I could be even more accurate. One irritant was that I had to explain to family and friends and address bar hack to ensure that my whole map came up on one page (so people didnt think i'd stopped moving!). Thankfully, an update has meant that you can now get far more items on a page by default.
Check it out:
http://maps.google.com/maps/ms?ie=UTF8&hl=en&msa=0&msid=115870688370049651826.000001128a1a16fff1341&z=3
My favorite "tip" I guess is just using the chart gadgets. It's amazing how it all works but the "Interactive Time Series Chart" is just one of the examples of how there is no way a regular application can match what's possible with web apps.
Sheldon
Few users of Google apps know how to shorten their URLs. Google has the tendency to put all the possible parameters into URL, but normally they are not necessary. It's easy to remove them and send the plain text version of the human readable address to someone, instead of using services like tinyurl.com.
Here are some examples for Google Maps (the official version is when you click on "Link to this page"):
1) search for a place
official:
http://maps.google.com/maps?f=q&hl=en&geocode=&q=Warsaw&ie=UTF8&ll=52.276561,21.012726&spn=0.355422,0.933838&z=10&iwloc=addr
shortened:
http://maps.google.com/?q=Warsaw
2) select a type of map
http://maps.google.com/?q=Warsaw&t={k,h,p}
k=sattelite (k like Keyhole)
h=hybrid
p=terrain (don't know what "p" stands for)
3) search for a particular geographical location
http://maps.google.com/?q=48.858168,2.294571
4) Few people know about this trick to put a label on the location from example 3:
http://maps.google.com/?q=48.858168,2.294571%20(Eiffel%20Tower)
(just put the label in parenthesis after the coordinates)
I like to use all kinds of Google tools for my vanity stream... and aggregate everything in Google Reader and access it from whereever I am.
Google Reader + Gears + OQO/EeePC/etc = a never ending stream of bus fodder without the hassle of paper. I've gotten more than a few people asking me how I'm connected to the internet on the bus.
Also collaborating with the Google office apps is just awesome. I can't wait to start embedding videos into presentations, too.
When giving someone directions sometimes you can't tell which building the address is because the numbers are hard to read at night or they aren't visible.
I always give directions by putting the address in google maps. Adding street view, move it to a picture of the actual building and creating a link.
This way when you give someone the link it will have the address & picture right when they click it. No more confusion.
I use Google docs to store my online Project Management course homework and handouts so that I can more easily collaborate with my team mates. I had no idea this could be this easy and useful!
Sara - here's my favorite Google Docs hack:
Attach a bunch of documents / spreadsheets to an email messages and send it to Google docs. They all get uploaded instantly.
Google apps allows me to share documents with less technologically literate folks on my neighborhood committee. I needed to post a spreadsheet of local businesses up to a group of board members, and all I had to do was simply press 'Publish' and enter their e-mail addresses and paste in the link in an e-mail. No attachments meant no frustration.
I'm now trying to shift more and more of my personal documents to google apps.
Google apps allows me to share documents with less technologically literate folks on my neighborhood committee. I needed to post a spreadsheet of local businesses up to a group of board members, and all I had to do was simply press 'Publish' and enter their e-mail addresses and paste in the link in an e-mail. No attachments meant no frustration.
I'm now trying to shift more and more of my personal documents to google apps.
I'm taking Anatomy and Physiology and I've got to create outlines for each chapter which I copy from the end of the chapter. I'm storing those chapters in google docs that I'll always have a reference should I need it again.
Didn't have time to read all other comments but my fav. is Print to Pdf feels like a Mac on Pc sorta.
I love google gears. This is an amazing invention. Because in many cases I haven't internet connection or have a low bandwidth for such writing google docs. It's much more convenient that currently Googld Docs support google gears. I can write docs anywhere. Also, it's a very useful APIs for various web applications. It's a revolutionary idea for web services.