I recently attended a Salesforce webinar on how to use the Google API toolkit and must admit I was very impressed.

The power of moving data from Salesforce into Google docs, coupled with an increased availability of Google visualizations and add-ons to Google spreadsheets, is starting to make Google an extremely viable option as a service based business intelligence and analytics platform.

There are really no technical barriers to integration. The challenge now is provisioning, configuration, and deployment. It was not quite clear to me on what Salesforce recommends as best practice for retrieving, storing, and managing the various types of authentication tokens. Once this challenge is reduced to a "one-click" experience, I think the mash-ups will fly.

The motion chart (below) really impressed me as a possible solution to viewing key marketing metrics over time. I'm writing a paper on customer acquisition costs and had initially assumed use of Salesforce bar charts for reporting, but the chart below looks promising. It's currently using sample data now, but the Salesforce Google API toolkit provides the ability to update the underlying Google spreadsheet with actual data.