Doodle for your domain using Google Apps Script

1. To begin, open the starter spreadsheet. You need to logged into your Google Apps Administartor Account to proceed. If you are asked if you want make a new copy of the document, click "Yes, make a copy."

2. Once loaded, give it an appropriate name: Click the File menu above and choose Rename.

3. Now update the sheet named 'Doodles' with the Doodle name, Its Doodle Date and Doodle URLs. You may write any number of Doodle records in this spreadsheet. First record in this sheet must be the default logo for your organization. Do not change anything in the second sheet named 'Doodle archive'. Also do not alter the structure of the sheets.

4. Now go to Tools menu and choose Script Editor, This will open the application script.

5. Now select the function getTodaysDoodle and run it, as shown in the below images. This will ask you to authorize the script.

• 1. Now setup trigger to run function  getTodaysDoodle everyday. To setup trigger, Go to Tools>Current project's triggers. This will open a popup panel. Click on the link which says " No triggers set up. Click here to add one now. " Now setup the Time Driven day Timer trigger as shown in below images.

Now your Doodle is setup. Once a doodle has been used, it will be archived in the second spreadsheet.

Code:

  ///////////////////////////////////////////////////////////////////////

 //Setup a time driven trigger (Day Timer) to run this function/////////

///////////////////////////////////////////////////////////////////////

function getTodaysDoodle(){

  try{

    var ss = SpreadsheetApp.getActiveSpreadsheet();

    var doodleSheet = ss.getSheets()[0];

    var timeZone = Session.getTimeZone();

    var dataRange = doodleSheet.getRange(2, 1, doodleSheet.getLastRow()-1, 3);

    var data = dataRange.getValues();

    var today = Utilities.formatDate(new Date(), timeZone, 'MM/dd/yyyy');

    var logo = {};

    var doodleRow = 2;

    for(var i=0; i<data.length; i++){

      var date = Utilities.formatDate(data[i][1], timeZone, 'MM/dd/yyyy');

      //if doodle exists, then get that doodle name and url

      if(date == today){

        logo.name = data[i][0];

        logo.url = data[i][2];

        doodleRow = i+2;

        dataRange.clearFormat();

        break;

      }

    }

    //If no doodle exists, get the domain default logo

    if(logo.name == null){

      logo.name = data[0][0];

      logo.url = data[0][2];

      dataRange.clearFormat();

      doodleSheet.getRange(2, 1, 1,3).setBackground('gold');

    }

    updateDoodle(logo);

    //Archive the doodle in second sheet if it is not the default Logo

    if (doodleRow !=2){

      var archiveSheet = ss.getSheets()[1];

      doodleSheet.getRange(doodleRow, 1, 1,4)

.moveTo(archiveSheet.getRange(archiveSheet.getLastRow()+1, 1, 1));

      doodleSheet.deleteRow(doodleRow);

    }

  }

  catch(e){

    //If there occurs any error, Mail it to yourself

    GmailApp.sendEmail(Session.getEffectiveUser(), 'Error occured while updating' 

+'the Logo', 'Error'+e);

  }

}

//This function will update the logo, called from ' getTodaysDoodle()'

function updateDoodle(logo){

  var logoBData = UrlFetchApp.fetch(logo.url).getContent();

  var logoB64encodedData = Utilities.base64Encode(logoBData);

  var xmlRaw = "<atom:entry xmlns:atom='http://www.w3.org/2005/Atom'" +"xmlns:apps='http://schemas.google.com/apps/2006'>"

      +"<apps:property name='logoImage' value='"+logoB64encodedData+"' />"

      +"</atom:entry>";

  var base = 'https://apps-apis.google.com/a/feeds/domain/';

  var fetchArgs = googleOAuth_("myDoodle", base);

  fetchArgs.method = 'PUT';

  fetchArgs.payload = xmlRaw;

  fetchArgs.contentType = 'application/atom+xml';

  var myDomain = UserManager.getDomain();

  var url = base+'2.0/'+myDomain+'/appearance/customLogo';

  var urlFetch = UrlFetchApp.fetch(url, fetchArgs); 

  var status = urlFetch.getResponseCode();

}

//Google oAuthConfig.. Called from 'updateDoodle(logo)'

function googleOAuth_(name,scope) {

  var oAuthConfig = UrlFetchApp.addOAuthService(name);

  oAuthConfig.setRequestTokenUrl("https://www.google.com/accounts/OAuthGetRequestToken?scope="+scope);

  oAuthConfig.setAuthorizationUrl("https://www.google.com/accounts/OAuthAuthorizeToken");

  oAuthConfig.setAccessTokenUrl("https://www.google.com/accounts/OAuthGetAccessToken");

  oAuthConfig.setConsumerKey("anonymous");

  oAuthConfig.setConsumerSecret("anonymous");

  return {oAuthServiceName:name, oAuthUseToken:"always"};

}

If you see any bug in this application or would like to give any feedback/comment, please drop your comment through this form.

Search Keywords: Doodle for your domain, Custom Logo for Google Apps, Doodle using GAS, Doodle using Google Apps Script, Google Apps Script tutorial Doodle, Doodle for your Google Apps Domain