Martin Hawksey mhawksey
mhawksey
/ Tweet functions.gs
Last active
September 15, 2022 22:34
— forked from iamdaniele/Tweet functions.gs
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // @OnlyCurrentDoc | |
| const BearerTokenKey = 'twitterBearerToken'; | |
| function onOpen() { | |
| SpreadsheetApp | |
| .getUi() | |
| .createMenu('Twitter') | |
| .addItem('Set Bearer token', 'helpers.requestBearerToken') | |
| .addItem('Sign out', 'helpers.logout') |
mhawksey
/ yt.gs
Created
February 3, 2021 12:48
Modified version of Scheduling Live Broadcasts from Google Sheets - with setThumbnail https://mashe.hawksey.info/2017/09/identity-crisis-using-the-youtube-api-with-google-apps-script-and-scheduling-live-broadcasts-from-google-sheets/
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * @OnlyCurrentDoc | |
| */ | |
| YouTube.setTokenService(function(){ return getYouTubeService().getAccessToken(); }); | |
| // Read data from current sheet and create live events returning details back to sheet | |
| function schedule_events(){ | |
| var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("YT"); | |
| new cUseful.Fiddler(sheet) |
mhawksey
/ shBrushJScript.js
Created
April 17, 2020 20:36
SyntaxHighlighter which includes Google Apps Script services
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * SyntaxHighlighter | |
| * http://alexgorbatchev.com/SyntaxHighlighter | |
| * | |
| * SyntaxHighlighter is donationware. If you are using it, please donate. | |
| * http://alexgorbatchev.com/SyntaxHighlighter/donate.html | |
| * | |
| * @version | |
| * 3.0.83 (July 02 2010) | |
| * |
mhawksey
/ template-ALT.html
Last active
November 26, 2019 08:37
Mosaico Template for CiviCRM based on
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html | |
| PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> | |
| <html xmlns="http://www.w3.org/1999/xhtml"> | |
| <head> | |
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> | |
| <meta name="viewport" content="initial-scale=1.0" /> | |
| <meta name="format-detection" content="telephone=no" /> | |
| <title style="-ko-bind-text: @titleText">[subject]</title> | |
| <style type="text/css"> |
mhawksey
/ code.gs
Created
April 26, 2019 18:37
Example Google Apps Script custom sheet function example. For more info see https://mashe.hawksey.info?p=19219
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * Generates a SHA-256 hash of a text input. | |
| * | |
| * @param {String||Array} value to SHA-256 hash. | |
| * @param {String} key to use to generate the hash with. | |
| * @return the SHA-256 hash of the value | |
| * @customfunction | |
| */ | |
| function HASH(value, key) { | |
| if (typeof key !== 'string'){ // test the key is a string |
mhawksey
/ UrlShortener.gs
Last active
April 2, 2021 05:51
Google Apps Script shim to replace UrlShortener calls with a Bit.ly version
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // https://addyosmani.com/blog/essential-js-namespacing/ | |
| // extend.js | |
| // written by andrew dupont, optimized by addy osmani | |
| function extend(destination, source) { | |
| var toString = Object.prototype.toString, | |
| objTest = toString.call({}); | |
| for (var property in source) { | |
| if (source[property] && objTest == toString.call(source[property])) { | |
| destination[property] = destination[property] || {}; | |
| extend(destination[property], source[property]); |
mhawksey
/ snip_02.js
Created
March 17, 2018 16:48
Code snippets for Recording .mp3 audio in Google Add-ons/Google Apps Script to Google Drive https://mashe.hawksey.info/?p=17916
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| blobToDataURL(blob, function(url){ | |
| var filename = 'recording_' + | |
| (new Date()) + | |
| '_.mp3'; | |
| google.script.run.withSuccessHandler(function(driveUrl){ | |
| $('ol.convertedList') | |
| .append('<li><strong> ' + filename + | |
| '</strong> <a href="'+driveUrl+'" target="_blank">Drive Link</a><br/>' + | |
| '<audio controls src="' + url + '"></audio>' + | |
| '</li>'); |
mhawksey
/ snip01.js
Last active
November 17, 2019 07:53
Code snippets for Recording .mp3 audio in Google Add-ons/Google Apps Script to Google Drive https://mashe.hawksey.info/?p=17916
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| blobToDataURL(blob, function(url){ | |
| $('ol.convertedList') | |
| .append('<li><strong> recording_' + | |
| (new Date()) + | |
| '_.mp3</strong><br/>' + | |
| '<audio controls src="' + url + '"></audio>' + | |
| '</li>'); | |
| }) |
mhawksey
/ appsscriptzoneids.csv
Last active
September 23, 2025 03:08
ZoneIds used in Google Apps Script
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| value | text | |
|---|---|---|
| Pacific/Midway | (GMT-11:00) Midway | |
| Pacific/Niue | (GMT-11:00) Niue | |
| Pacific/Pago_Pago | (GMT-11:00) Pago Pago | |
| Pacific/Honolulu | (GMT-10:00) Hawaii Time | |
| Pacific/Johnston | (GMT-10:00) Johnston | |
| Pacific/Rarotonga | (GMT-10:00) Rarotonga | |
| Pacific/Tahiti | (GMT-10:00) Tahiti | |
| Pacific/Marquesas | (GMT-09:30) Marquesas | |
| America/Anchorage | (GMT-09:00) Alaska Time |
mhawksey
/ gist:0c5ad7b79e1162b239156ce946cbe2be
Last active
June 7, 2022 15:17
Snippet of code used for DevFest London 2017 to count faces in audience and send to Google Analytics and update image in Google Slides (see https://mashe.hawksey.info/?p=17787)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import io | |
| import picamera | |
| import cv2 | |
| import numpy | |
| import requests | |
| import base64 | |
| def hitGA(faces): | |
| print("Sending to GA") | |
| requests.get("http://www.google-analytics.com/collect?v=1" \ |