Skip to content

Instantly share code, notes, and snippets.

@brianyoungblood
brianyoungblood / gdrive-example.php
Created May 6, 2023 02:45 — forked from geschke/gdrive-example.php
Google Drive PHP API library example to download a spreadsheet file
<?php
require_once __DIR__ . '/vendor/autoload.php';
class DriveFile
{
private $service = null;
private $client = null;
private $auth;
@brianyoungblood
brianyoungblood / NSLookup.gs
Last active January 22, 2016 00:39 — forked from mogsdad/NSLookup.gs
NSLookup - Google Sheets custom function to Perform a Network Service Lookup, using StatDNS API. From "Nslookup or dig in Google App Script" (http://stackoverflow.com/a/30610580/1677912).
/**
* Perform a Network Service Lookup, using StatDNS API.
*
* @param {"google.com"} dn A well-formed domain name to resolve.
* @return {String} Resolved IP address
* @customfunction
*/
function NSLookup(dn) {
// From gist.github.com/mogsdad/ece531531e0ef5dc355d
@brianyoungblood
brianyoungblood / gist:6532023
Last active December 22, 2015 21:19 — forked from alanchrt/gist:1014534
Highlight all addresses to find county only - new column is created and cells are populated with county.
/*****************************************************************************\
* Batch Spreadsheet geocode find county *
* Author: Alan Christopher Thomas *
* http://alanchristopherthomas.com/ *
\*****************************************************************************/
//Pull counties (administrative_area_level_2) from Google geocoder
function onOpen() {
// Add the Geocode menu
SpreadsheetApp.getActiveSpreadsheet().addMenu("Geocoder", [{