Skip to content

Instantly share code, notes, and snippets.

View mstepien's full-sized avatar

Martin mstepien

View GitHub Profile
@mstepien
mstepien / drive-appscript.js
Last active January 1, 2016 17:59 — forked from igrigorik/drive-appscript.js
BigQuery queries for the HTTP Archive dataset with some Google BigQuery API code updates: - use of class QueryRequest - http://googleappsdeveloper.blogspot.com/2013/11/code-updates-required-for-apps-script.html
function onOpen() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var menuEntries = [ {name: "Run Query", functionName: "runQuery"} ];
ss.addMenu("HTTP Archive + BigQuery", menuEntries);
}
function runQuery() {
var projectNumber = 'httparchive';
var sheet = SpreadsheetApp.getActiveSheet();