Skip to content

Instantly share code, notes, and snippets.

View NicoMiceli's full-sized avatar

Nico Miceli NicoMiceli

View GitHub Profile
@NicoMiceli
NicoMiceli / gotoCell.js
Created October 12, 2018 18:31 — forked from tamirko/gotoCell.js
How to go to a specific cell in a Google sheet ?
function onOpen()
{
var menuEntries = [{name: "Go to", functionName: "goToCell"}];
SpreadsheetApp.getActiveSpreadsheet().addMenu("MyUtils", menuEntries);
}
function goToCell()
{
var strRange = Browser.inputBox("Insert the required cell (e.g.: B351):", Browser.Buttons.OK_CANCEL);
if(strRange != "cancel")
@NicoMiceli
NicoMiceli / BigQuery2GSheets.js
Created August 3, 2017 17:22 — forked from greenido/BigQuery2GSheets.js
An Apps script example to fetch data form Big query to google spreadsheets. For more: http://wp.me/pB1lQ-19i
/**
* Fetching data from BigQuery and present it in our sheet
* Author: Ido Green
* Date: 14/12/2013
*
* See: http://wp.me/pB1lQ-19i
* Misc: https://developers.google.com/bigquery/
*/
//