I haven't been too easy lately on Google Apps in relation to Microsoft Office 2010. This isn't a bad thing: if Google wants users to abandon Office (or at least end the upgrade cycle) and fully invest in Apps, then they need to be really compelling and competitive, both for average office workers and power users. The recent rewrite of Docs and its associated improvements are definitely a step in the right direction and I'm convinced that Google is intent on changing (for the better) the way we work together and create content.
With scripts, you can:
- Create your own custom spreadsheet functions
- Automate repetitive tasks (e.g. process responses to Google Docs forms)
- Link multiple Google products together (e.g. send emails or schedule Calendar events from a list of addresses in a Spreadsheet)
- Customize existing Google products (e.g. add custom buttons or menus to run your own scripts)
To that end, I'm starting a series of posts that I'm calling Google Apps Ninja Stories. These will feature applications, customizations, tips, and tricks that will impress even the most jaded of cloud users. Just how much can you do in terms of office productivity natively in the cloud, and how can Docs change the way we collaborate? Check back soon for Ninja Stories that highlight what "power user" means in the cloud.