varun-raj

function pullJSON() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheets = ss.getSheets();
  var sheet = ss.getActiveSheet();


  var url="http://example.com/feeds?type=json"; // Paste your JSON URL here
  
   var response = UrlFetchApp.fetch(url); // get feed
  var dataAll = JSON.parse(response.getContentText()); //

auycro

uses ShlObj, ComObj, ActiveX;

//GET DESKTOP FOLDERS
function GetSystemPath(Folder: Integer): string;
var
  PIDL: PItemIDList;
  Path: LPSTR;
  AMalloc: IMalloc;
begin
  Path := StrAlloc(MAX_PATH);

mhawksey

// instead of var results = YouTubeAnalytics.Reports.query(ids, start-date, end-date, metrics, optionalArgs);
var params = {"method" : "post",
              "payload" : {'ids' : query.ids,
                           "startDate" : startDate,
                           "endDate": endDate,
                           "metrics": query.metrics,
                           "options": JSON.stringify(options)
                          }
             };
var yt_data = UrlFetchApp.fetch("https://script.google.com/macros/s/YOUR_APP_ID/exec", params);

kurokikaze

(new-object System.Net.WebClient).DownloadFile('http://dl.google.com/chrome/install/375.126/chrome_installer.exe', 'c:/temp/chrome.exe');. c:/temp/chrome.exe /silent /install;rm c:/temp -rec

sheharyarn

Youtube Downloaders

Download Youtube Videos using Ruby or PHP

Just copy the appropriate script, provide the video_id and run. It will list download links for different qualities and streams.

:P

chipoglesby

//If the current cell is more than the previous cell, set it as lime green

function onEdit(e) {
  var ss = SpreadsheetApp.getActive();
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var name = sheet.getName();
  var range = sheet.getRange("A:J");
  var values = range.getValues();
  var cell = sheet.getActiveCell();
  var value = cell.getValue();

dgp

2 - Autos & Vehicles
1 -  Film & Animation
10 - Music
15 - Pets & Animals
17 - Sports
18 - Short Movies
19 - Travel & Events
20 - Gaming
21 - Videoblogging
22 - People & Blogs

ociredefz

/**
 * Google Script - Add Fonts.
 * Add other fonts in Google Spreadsheet.
 *
 * a) Open 'Script editor'
 * b) Add this script
 * c) Save and run 'onOpen'
 * d) Go to some 'Spreadsheet' project
 * e) Click to 'Font Editor' and then to 'Change Font'
 */

MauricioMoraes

// Takes and array of arrays matrix and return an array of elements.
function flatten(arrayOfArrays){
  return [].concat.apply([], arrayOfArrays);
}

anguyen8

#!/bin/bash

# Anh Nguyen <[email protected]>
# 2016-04-30
# MIT License

# This script takes in same-size images from a folder and make a crossfade video from the images using ffmpeg.
# Make sure you have ffmpeg installed before running.

# The output command looks something like the below, but for as many images as you have in the folder.