EscribirEnUnaCeldaHoja

 function onOpen() {

  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();

  var entries = [

    { name : "Escribir",  functionName : "Escribir"}

   ];

  spreadsheet.addMenu("Lord Pakus Scripts", entries);

};

function Escribir()

{

  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();

  var sheet = spreadsheet.getActiveSheet();

 

  sheet.getRange(1,1).setValue('Hola').setBackground('red');

  sheet.getRange(1,2).setValue('Mundo').setBackground('green');

}