schlos

function getGeocodingRegion() {
    return PropertiesService.getDocumentProperties().getProperty('GEOCODING_REGION') || 'au';
}

function addressToPosition() {
    // Select a cell with an address and two blank spaces after it
    var sheet = SpreadsheetApp.getActiveSheet();
    var cells = sheet.getActiveRange();

    var addressColumn = 1;

schlos

DataFire Dataflow: Sync GitHub issues to spreadsheet

Pulls all new issues from a GitHub repo into a spreadsheet

View on DataFire

[metadata]: ./ '{"links":[{"connection":"563b9b84ea9ad5f345e97505","operation":{"method":"get","path":"/repos/{ownerId}/{repoId}/issues"}},{"connection":"563b9b85ea9ad5f345e97511","operation":{"method":"get","path":"/list/{key}/{worksheetId}/{visibility}/{projection}"}},{"connection":"563b9b85ea9ad5f345e97511","operation":{"method":"put","path":"/cells/{key}/{worksheetId}/{visibility}/{projection}/{cellId}"}},{"connection":"563b9b85ea9ad5f345e97511","operation":{"method":"post","path":"/list/{key}/{worksheetId}/{visibility}/{projection}"}},{"connection":"563b9b85ea9ad5f345e97511","operation":{"method":"put","path":"/list/{key}/{worksheetId}/{visibility}/{projection}/{rowId}"}}],"constants":[{"name":"spreadsheetID","description":"The ID of your spreadsheet from its URL: docs.google.com/spreadsheets/d/SPREADSHEET_ID","type":

schlos

Linux System Metrics

CPU

• system.cpu.idle: % Idle CPU
• system.cpu.system: % System CPU
• system.cpu.user: % User CPU

Disk

schlos

// Gmail/Inbox Email Purge Script
// Using Google Script
// Clears out all emails older than X days

// Labels
function multipleLabels() {
  var myLabels = {
    '"Updates"': "7d",
    '"Forums"': "7d",
    '"Promotions"': "7d",

schlos

/*
  Gmail Message Snoozing
  
  Quick implementation to allow snoozing of unread messages in Gmail
  
  Usage:
  
  The move unread emails into a snooze label for the desired snooze time. After
  the specified time, the message should be moved back into your inbox. This will
  only effect unread emails to prevent messages from continuing to bounce back

schlos

function installScript() {
  
  // Makes sure that only 1 scheduler is installed
  uninstallScript();
  
  // Trigger every 1 hour.
  ScriptApp.newTrigger('gmailScheduler')
      .timeBased()
      .everyHours(1)
      .create();

schlos

// ==UserScript==
// @name        gmail-enhancer
// @namespace   gmail-enhancer
// @description gmail-enhancer UX experience
// @include     https://mail.google.com/mail/*
// @version     1.2
// @grant       none
// ==/UserScript==

(function() {

schlos

how-to-add-a-line-to-a-google-spreadsheet-via-email

http://stackoverflow.com/questions/34801292/how-to-add-a-line-to-a-google-spreadsheet-via-email

schlos

// This script retrieves contents of Gmail Inbox and leaves only
// predefined amount of last messages. Old messages will be
// moved to archive.

function cleanOld(){
  var old_threads = GmailApp.getInboxThreads();
  var leave = 30;
  
  if (old_threads.length>=leave){
    for (var i=leave; i<old_threads.length; i++){

schlos

var LABEL = 'Snooze';
var MONTHS = 1;
var MARK_UNREAD = true;
var ADD_UNSNOOZED_LABEL = true;

function dailySnooze() {
    var today;
    var page;
    var d = new Date();
    var day = d.getDate();