Google announce the integration of BigQuery with Google Apps Script and Google Spreadsheets. "With this integration users now have the power to query multi-billion row tables, visualize the results and share them with others," stated Google. Below you can see a simple script that queries a sample dataset and plots the results.
The details of BigQuery and new features are available on the BigQuery website. Google is gradually adding more developers during this free preview period. Please sign up for an invitation.