Skip to content

Instantly share code, notes, and snippets.

#!/usr/bin/python
import csv
import json
import urllib2
def main():
rows = []
url = 'https://docs.google.com/spreadsheet/pub?key=0Al2vbsd4zHJbdExOR0tBY2JfT0U0cVphb3hrMVd6WWc&output=csv'
@smelendez
smelendez / request.js
Last active December 16, 2015 14:09
quick and dirty jQuery-requiring replacement https://github.com/mapbox/mapbox.js/blob/v1/src/request.js on IE7/8 -- use at your own risk!
'use strict';
var corslite = require('corslite'),
JSON3 = require('json3'),
strict = require('./util').strict;
module.exports = function(url, callback) {
strict(url, 'string');
strict(callback, 'function');
$.getJSON(url + '?callback=?', function(data) {
/* Global Constants */
var cID = 0, cURL = 1, cName = 2, cContact = 3, cChanged=4, cChecksum=5, cMirrorPage=6; // column indices
var baseSiteUrl = 'https://sites.google.com/site/smelendeznicarmirror/'; // site to store mirrored content
var site = SitesApp.getSiteByUrl(baseSiteUrl);
var today = Date();
function test() {
var sheet = SpreadsheetApp.getActiveSpreadsheet();
GmailApp.sendEmail("smelendez@gmail.com","", sheet.getUrl());
}
ds = new Miso.Dataset({
url: "data/spreadsheet.tsv",
delimiter: "\t"
});
@smelendez
smelendez / gettsv.sh
Created December 3, 2012 16:51
Download a Google Spreadsheet as a TSV
#!/bin/bash
wget -O - 'https://docs.google.com/spreadsheet/pub?key=0AjUUa__FW_6RdERnMnBFX2xPQS01dC11WWxmQXhZcWc&single=true&gid=0&output=txt' | cut -f1,2,4 > spreadsheet.tsv