// This is the base64 encoded form of "Google グループ"constbase64data='R29vZ2xlIOOCsOODq+ODvOODlw==';// This logs://     [71, 111, 111, 103, 108, 101, 32, -29, -126, -80,//      -29, -125, -85, -29, -125, -68, -29, -125, -105]constdecoded=Utilities.base64Decode(base64data);Logger.log(decoded);// If you want a String instead of a byte array:// This logs the original "Google グループ"Logger.log(Utilities.newBlob(decoded).getDataAsString());

// This is the base64 encoded form of "Google グループ"constbase64data='R29vZ2xlIOOCsOODq+ODvOODlw==';constdecoded=Utilities.base64Decode(base64data,Utilities.Charset.UTF_8);// This logs://     [71, 111, 111, 103, 108, 101, 32, -29, -126, -80,//      -29, -125, -85, -29, -125, -68, -29, -125, -105]Logger.log(decoded);// If you want a String instead of a byte array:// This logs the original "Google グループ"Logger.log(Utilities.newBlob(decoded).getDataAsString());

// This is the base64 web-safe encoded form of "Google グループ"constbase64data='R29vZ2xlIOOCsOODq-ODvOODlw==';constdecoded=Utilities.base64DecodeWebSafe(base64data);// This logs://     [71, 111, 111, 103, 108, 101, 32, -29, -126, -80,//      -29, -125, -85, -29, -125, -68, -29, -125, -105]Logger.log(decoded);// If you want a String instead of a byte array:// This logs the original "Google グループ"Logger.log(Utilities.newBlob(decoded).getDataAsString());

// This is the base64 web-safe encoded form of "Google グループ"constbase64data='R29vZ2xlIOOCsOODq-ODvOODlw==';constdecoded=Utilities.base64DecodeWebSafe(base64data,Utilities.Charset.UTF_8,);// This logs://     [71, 111, 111, 103, 108, 101, 32, -29, -126, -80,//      -29, -125, -85, -29, -125, -68, -29, -125, -105]Logger.log(decoded);// If you want a String instead of a byte array:// This logs the original "Google グループ"Logger.log(Utilities.newBlob(decoded).getDataAsString());

// Instantiates a blob here for clarityconstblob=Utilities.newBlob('A string here');// Writes 'QSBzdHJpbmcgaGVyZQ==' to the log.constencoded=Utilities.base64Encode(blob.getBytes());Logger.log(encoded);

// Writes 'QSBzdHJpbmcgaGVyZQ==' to the log.constencoded=Utilities.base64Encode('A string here');Logger.log(encoded);

// "Google Groups" in Katakana (Japanese)constinput='Google グループ';// Writes "R29vZ2xlIOOCsOODq+ODvOODlw==" to the logconstencoded=Utilities.base64Encode(input,Utilities.Charset.UTF_8);Logger.log(encoded);

// Instantiates a blob here for clarityconstblob=Utilities.newBlob('A string here');// Writes 'QSBzdHJpbmcgaGVyZQ==' to the log.constencoded=Utilities.base64EncodeWebSafe(blob.getBytes());Logger.log(encoded);

// Writes 'QSBzdHJpbmcgaGVyZQ==' to the log.constencoded=Utilities.base64EncodeWebSafe('A string here');Logger.log(encoded);

// "Google Groups" in Katakana (Japanese)constinput='Google グループ';// Writes "R29vZ2xlIOOCsOODq-ODvOODlw==" to the logconstencoded=Utilities.base64EncodeWebSafe(input,Utilities.Charset.UTF_8);Logger.log(encoded);

constinput=Utilities.base64Decode('aW5wdXQgdG8gaGFzaA0K');// == base64encode("input to hash")constdigest=Utilities.computeDigest(Utilities.DigestAlgorithm.MD5,input);Logger.log(digest);

constdigest=Utilities.computeDigest(Utilities.DigestAlgorithm.MD5,'input to hash',);Logger.log(digest);

constdigest=Utilities.computeDigest(Utilities.DigestAlgorithm.MD5,'input to hash',Utilities.Charset.US_ASCII,);Logger.log(digest);

// This writes an array of bytes to the log.constinput=Utilities.base64Decode('aW5wdXQgdG8gaGFzaA0K');// == base64encode("input to hash")constkey=Utilities.base64Decode('a2V5');// == base64encode("key")constsignature=Utilities.computeHmacSha256Signature(input,key);Logger.log(signature);

// This writes an array of bytes to the log.constsignature=Utilities.computeHmacSha256Signature('this is my input','my key - use a stronger one',);Logger.log(signature);

// This writes an array of bytes to the log.constsignature=Utilities.computeHmacSha256Signature('this is my input','my key - use a stronger one',Utilities.Charset.US_ASCII,);Logger.log(signature);

// This writes an array of bytes to the log.constinput=Utilities.base64Decode('aW5wdXQgdG8gaGFzaA0K');// == base64encode("input to hash")constkey=Utilities.base64Decode('a2V5');// == base64encode("key")constsignature=Utilities.computeHmacSignature(Utilities.MacAlgorithm.HMAC_MD5,input,key,);Logger.log(signature);

// This writes an array of bytes to the log.constsignature=Utilities.computeHmacSignature(Utilities.MacAlgorithm.HMAC_MD5,'input to hash','key',);Logger.log(signature);

// This writes an array of bytes to the log.constsignature=Utilities.computeHmacSignature(Utilities.MacAlgorithm.HMAC_MD5,'input to hash','key',Utilities.Charset.US_ASCII,);Logger.log(signature);

// This writes an array of bytes to the log.constsignature=Utilities.computeRsaSha1Signature('this is my input',PropertiesService.getScriptProperties().getProperty('YOUR_PRIVATE_KEY'),);Logger.log(signature);

// This writes an array of bytes to the log.constsignature=Utilities.computeRsaSha1Signature('this is my input',PropertiesService.getScriptProperties().getProperty('YOUR_PRIVATE_KEY'),Utilities.Charset.US_ASCII,);Logger.log(signature);

// This writes an array of bytes to the log.constsignature=Utilities.computeRsaSha256Signature('this is my input',PropertiesService.getScriptProperties().getProperty('YOUR_PRIVATE_KEY'),);Logger.log(signature);

// This writes an array of bytes to the log.constsignature=Utilities.computeRsaSha256Signature('this is my input',PropertiesService.getScriptProperties().getProperty('YOUR_PRIVATE_KEY'),);Logger.log(signature);

// This writes an array of bytes to the log.constsignature=Utilities.computeRsaSignature(Utilities.RsaAlgorithm.RSA_SHA_256,'this is my input',PropertiesService.getScriptProperties().getProperty('YOUR_PRIVATE_KEY'),);Logger.log(signature);

// This writes an array of bytes to the log.constsignature=Utilities.computeRsaSignature(Utilities.RsaAlgorithm.RSA_SHA_256,'this is my input',PropertiesService.getScriptProperties().getProperty('YOUR_PRIVATE_KEY'),Utilities.Charset.US_ASCII,);Logger.log(signature);

// This formats the date as Greenwich Mean Time in the format// year-month-dateThour-minute-second.constformattedDate=Utilities.formatDate(newDate(),'GMT','yyyy-MM-dd\'T\'HH:mm:ss\'Z\'',);Logger.log(formattedDate);

// " 123.456000"Utilities.formatString('%11.6f',123.456);// "   abc"Utilities.formatString('%6s','abc');

// This assigns a UUID as a temporary ID for a data object you are creating in// your script.constmyDataObject={tempId:Utilities.getUuid(),};

consttextBlob=Utilities.newBlob('Some text to compress using gzip compression',);// Create the compressed blob.constgzipBlob=Utilities.gzip(textBlob);

consttextBlob=Utilities.newBlob('Some text to compress using gzip compression',);// Create the compressed blob.constgzipBlob=Utilities.gzip(textBlob,'text.gz');

// Creates a blob object from a byte array.constdata=[71,79,79,71,76,69];constblob=Utilities.newBlob(data);// Logs the blob data as a string to the console.console.log(blob.getDataAsString());

// Declares a byte array.constdata=[71,79,79,71,76,69];// Declares the content type of the blob.constcontentType='application/json';// Creates a blob object from the byte array and content type.constblob=Utilities.newBlob(data,contentType);// Logs the blob data as a string to the console.console.log(blob.getDataAsString());// Logs the content type of the blob to the console.console.log(blob.getContentType());

// Declares a byte array.constdata=[71,79,79,71,76,69];// Declares the content type of the blob.constcontentType='application/json';// Declares the name of the blob.constname='Example blob';// Creates a blob object from the byte array, content type, and name.constblob=Utilities.newBlob(data,contentType,name);// Logs the blob data as a string to the console.console.log('Blob data:',blob.getDataAsString());// Logs the content type of the blob to the console.console.log('Blob content type:',blob.getContentType());// Logs the name of the blob to the console.console.log('Blob name:',blob.getName());

// Declares a string for the blob.constdata='GOOGLE';// Creates a blob object from a string.constblob=Utilities.newBlob(data);// Logs the blob data in byte array to the console.console.log('Blob Data:',blob.getBytes());

// Declares a string for the blob.constdata='GOOGLE';// Declares the content type of blob.constcontentType='application/json';// Creates a blob object from the string and content type.constblob=Utilities.newBlob(data,contentType);// Logs the blob data in byte array to the console.console.log('Blob data:',blob.getBytes());// Logs the content type of the blob to the console.console.log(blob.getContentType());

// Declares a string for the blob.constdata='GOOGLE';// Declares the content type of the blob.constcontentType='application/json';// Declares the name of the blob.constname='Example blob';// Create a blob object from the string, content type, and name.constblob=Utilities.newBlob(data,contentType,name);// Logs the blob data in byte array to the console.console.log('Blob data:',blob.getBytes());// Logs the content type of the blob to the console.console.log('Blob content type:',blob.getContentType());// Logs the name of the blob to the console.console.log('Blob name:',blob.getName());

// This creates a two-dimensional array of the format [[a, b, c], [d, e, f]]constcsvString='a,b,c\nd,e,f';constdata=Utilities.parseCsv(csvString);

// This creates a two-dimensional array of the format [[a, b, c], [d, e, f]]constcsvString='a\tb\tc\nd\te\tf';constdata=Utilities.parseCsv(csvString,'\t');

// This set of parameters parses the given string as a date in Greenwich Mean// Time, formatted as year-month-dateThour-minute-second.constdate=Utilities.parseDate('1970-01-01 00:00:00','GMT','yyyy-MM-dd\' \'HH:mm:ss',);Logger.log(date);

// Creates a blob object from a string.constdata='GOOGLE';constblob=Utilities.newBlob(data);// Puts the script to sleep for 10,000 milliseconds (10 seconds).Utilities.sleep(10000);// Logs the blob data in byte array to the console.console.log(blob.getBytes());

consttextBlob=Utilities.newBlob('Some text to compress using gzip compression',);// Create the compressed blob.constgzipBlob=Utilities.gzip(textBlob,'text.gz');// Uncompress the data.constuncompressedBlob=Utilities.ungzip(gzipBlob);

constgoogleFavIconUrl='https://www.google.com/favicon.ico';constgoogleLogoUrl='https://www.google.com/images/srpr/logo3w.png';// Fetch the Google favicon.ico file and get the Blob dataconstfaviconBlob=UrlFetchApp.fetch(googleFavIconUrl).getBlob();constlogoBlob=UrlFetchApp.fetch(googleLogoUrl).getBlob();// zip now references a blob containing an archive of both faviconBlob and// logoBlobconstzip=Utilities.zip([faviconBlob,logoBlob],'google_images.zip');// This now unzips the blobsconstfiles=Utilities.unzip(zip);

constgoogleFavIconUrl='https://www.google.com/favicon.ico';constgoogleLogoUrl='https://www.google.com/images/srpr/logo3w.png';// Fetch the Google favicon.ico file and get the Blob dataconstfaviconBlob=UrlFetchApp.fetch(googleFavIconUrl).getBlob();constlogoBlob=UrlFetchApp.fetch(googleLogoUrl).getBlob();// zip now references a blob containing an archive of both faviconBlob and// logoBlobconstzip=Utilities.zip([faviconBlob,logoBlob]);

constgoogleFavIconUrl='https://www.google.com/favicon.ico';constgoogleLogoUrl='https://www.google.com/images/srpr/logo3w.png';// Fetch the Google favicon.ico file and get the Blob dataconstfaviconBlob=UrlFetchApp.fetch(googleFavIconUrl).getBlob();constlogoBlob=UrlFetchApp.fetch(googleLogoUrl).getBlob();// zip now references a blob containing an archive of both faviconBlob and// logoBlobconstzip=Utilities.zip([faviconBlob,logoBlob],'google_images.zip');

// Returns the object { name: "John Smith", company: "Virginia Company"}constobj=Utilities.jsonParse('{"name":"John Smith","company":"Virginia Company"}',);

// Logs: {"name":"John Smith","company":"Virginia Company"}constperson={name:'John Smith',company:'Virginia Company',};constjson=Utilities.jsonStringify(person);Logger.log(json);