SIFAR786

// What is the Google Document ID for your email template?
var googleDocId = "abcd0000abcd0000abcd0000abcd0000";
// Which column has the email address? Enter the column row header exactly.
var emailField = 'Email';
// What is the subject line?
var emailSubject = 'You\'re bringing {Type}!';
// Which column is the indicator for email drafted? Enter the column row header exactly.
var emailStatus = 'Date drafted';

/* ----------------------------------- */

SIFAR786

//Goog.gl Shortener API - https://developers.google.com/url-shortener/v1/
//Requires URL Shortener API to be enable in Resources > Advanced Google Services of Script Editor
//Requires cFlatten reference "MqxKdBrlw18FDd-X5zQLd7yz3TLx7pV4j" in Resources > Lirbraries... of Script Editor - http://goo.gl/U4v9q2

function onOpen() {
  SpreadsheetApp.getUi()
    .createMenu("Goo.gl")
    .addItem("Shorten Selected URL(s)","setURLShorts")
    .addItem("Fetch Selected URL(s) Analytics","getURLAnalytics")
    .addToUi()  

SIFAR786

function deleteRows() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var rows = sheet.getDataRange();
  var numRows = rows.getNumRows();
  var values = rows.getValues();

  var rowsDeleted = 0;
  for (var i = 0; i <= numRows - 1; i++) {
    var row = values[i];
    if (row[0] == 'delete' || row[0] == '') { // This searches all cells in columns A (change to row[1] for columns B and so on) and deletes row if cell is empty or has value 'delete'.

SIFAR786

Pseudo Browser with Google Spreadsheet

Overview

This is a sample script for creating the pseudo browser using Google Spreadsheet.

Description

I unexpectedly noticed this. I think that this is for off-line browsing using HTML data. So there are many limitations. At first, please confirm them.

• Limitations
• It cannot move from opened site to other outside site. If the outer site is opened as a new wind, your own browser is opened and move there.

SIFAR786

// this function assumes the CSV has no fields with commas,
// and strips out all the double quotes
function parseCsvResponse(csvString) {
    var retArray = [];

    var strLines = csvString.split(/\n/g);
    var strLineLen = strLines.length;
    for (var i = 0; i < strLineLen; i++) {
        var line = strLines[i];
        if (line != '') {

SIFAR786

/**
 * Connect and fetch Salesforce data via OAuth
 */
function queryDataFromSalesforce() {
  // Read OAuth consumer key / secret of this client app from script properties, 
  // which can be issued from Salesforce's remote access setting in advance.
  var sfConsumerKey = ScriptProperties.getProperty("sfConsumerKey");
  var sfConsumerSecret = ScriptProperties.getProperty("sfConsumerSecret");
  if (!sfConsumerKey || !sfConsumerSecret) {
    Browser.msgBox("Register Salesforce OAuth Consumer Key and Secret in Script Properties");

SIFAR786

function rosterMaker() {
  //spreadsheet id of the rosters
  var SHEET_ID = FormApp.getActiveForm().getDestinationId();
  var ss = SpreadsheetApp.openById(SHEET_ID);
  var form = FormApp.getActiveForm();
  
  //get only the sheets with 'Roster' in the title
  var sheets = ss.getSheets()
    .filter(function(sheet) {return sheet.getName().match(/Roster/gi);});
  

SIFAR786

function columnToLetter(column, row) {
  var temp, letter = '';
  while (column > 0) {
    temp = (column - 1) % 26;
    letter = String.fromCharCode(temp + 65) + letter;
    column = (column - temp - 1) / 26;
  }
  return letter + row;
}

SIFAR786

/**
 * These simple triggers are available in Sheets, Docs, and Forms
 * Most of this information can be found:
 * https://developers.google.com/apps-script/guides/triggers/events
 */
function onOpen(e) {
  //  {
  //    authMode: 'LIMITED',
  //    source: 'Spreadsheet' || 'Document' || 'Form',
  //    user: 'User'

SIFAR786

def decode_eid(eid):
    """
    Decodes a SendGrid event id (sg_event_id) and returns as uuid
    """
    eid_len = len(eid)

    if eid_len == 22:
        res = uuid.UUID(bytes=base64.urlsafe_b64decode(eid + "=="))
    elif eid_len == 48:
        res = uuid.UUID(base64.urlsafe_b64decode(eid).decode("ascii"))