twotix

function checkURLs() {
  var errors = [];
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var rows = ss.getDataRange().getValues();
  for (i in rows) {
    var url = rows[i][0];
    try {
      UrlFetchApp.fetch(url);
    } catch (e) {
      // This error message parsing is gross, but it looks like 

twotix

function myFunction() {
  
  //oauth の設定
  var oauth = UrlFetchApp.addOAuthService(Session.getActiveUser().getEmail());
  
  oauth.setConsumerKey("anonymous"); //ちゃんとしたのを使ったほうがいいとおもふ
  oauth.setConsumerSecret("anonymous"); //ちゃんとしたのを使ったほうがいいとおもふ
  oauth.setRequestTokenUrl("https://www.google.com/accounts/OAuthGetRequestToken?scope=https%3A%2F%2Fwww.google.com%2Fcalendar%2Ffeeds%2F");
  oauth.setAuthorizationUrl("https://www.google.com/accounts/OAuthAuthorizeToken");
  oauth.setAccessTokenUrl("https://www.google.com/accounts/OAuthGetAccessToken");

twotix

#!/bin/sh
# Just copy and paste the lines below (all at once, it won't work line by line!)
# MAKE SURE YOU ARE HAPPY WITH WHAT IT DOES FIRST! THERE IS NO WARRANTY!

function abort {
  echo "$1"
  exit 1
}

set -e

twotix

function getJSON(aUrl,sheetname) {
  //var sheetname = "test";
  //var aUrl = "http://pipes.yahoo.com/pipes/pipe.run?_id=286bbb1d8d30f65b54173b3b752fa4d9&_render=json";
  var response = UrlFetchApp.fetch(aUrl); // get feed
  var dataAll = Utilities.jsonParse(response.getContentText()); //
  var data = dataAll.value.items;
  for (i in data){
    data[i].pubDate = new Date(data[i].pubDate);
    data[i].start = data[i].pubDate;
  }

twotix

javascript:location.href='http://google.co.uk/search'+location.search

twotix

// script used in http://mashe.hawksey.info/google-refine-apps-script-integration
function setup(){
  ScriptProperties.setProperty('active', SpreadsheetApp.getActiveSpreadsheet().getId());
}
function doGet(e){
  var secret ="lemons"; //must match secret in Google Refine
  if (e.parameter.secret == secret){
    var ss = SpreadsheetApp.openById(ScriptProperties.getProperty('active')); 
    var sheet = ss.getSheetByName("Vertices"); // sheet name of where you want the data to go
    var idx = parseInt(e.parameter.idx); // I had an idx column sequentially numbered to give me a row index

twotix

/*   
   Copyright 2011 Martin Hawksey

   Licensed under the Apache License, Version 2.0 (the "License");
   you may not use this file except in compliance with the License.
   You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software

twotix

// The rest of this code is currently (c) Google Inc.

// setRowsData fills in one row of data per object defined in the objects Array.
// For every Column, it checks if data objects define a value for it.
// Arguments:
//   - sheet: the Sheet Object where the data will be written
//   - objects: an Array of Objects, each of which contains data for a row
//   - optHeadersRange: a Range of cells where the column headers are defined. This
//     defaults to the entire first row in sheet.
//   - optFirstDataRowIndex: index of the first row where data should be written. This

twotix

function combineData(){
 var doc = SpreadsheetApp.getActiveSpreadsheet();
 var sheets = doc.getSheets(); // get all the sheets
 var outSheet = doc.getSheetByName("combined"); // set where we want to write the results
 for (i in sheets){ // loop across all the sheets
   if (sheets[i].getSheetName().substring(0,9) == "followers"){ // if sheetname starts with 'follower' then 
     var target = sheets[i].getSheetName().substring(12); // extract users name for target column
     var data = getRowsData(sheets[i]); // get extisting data from current sheet
     for (j in data){
       data[j]["target"] = target; // create a target column with the users name

twotix

/*   
   Copyright 2011 Martin Hawksey

   Licensed under the Apache License, Version 2.0 (the "License");
   you may not use this file except in compliance with the License.
   You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

   Unless required by applicable law or agreed to in writing, software