mhawksey

function createDummyFoldersWithNesting() {
  // Get the starting point for the dummy folder structure
  // Replace with your desired folder ID or use 'root' to start in the root of your My Drive
  const rootFolder = DriveApp.getFolderById("YOUR_FOLDER_ID"); 

  // Configuration for the dummy structure
  const maxNestingLevel = 3;        // How many levels deep the structure will go
  const maxFoldersPerLevel = 5;     // Maximum number of folders to create in each level
  const maxFilesPerFolder = 5;      // Maximum number of files to create in each folder
  const fileFolderPrefix = 'Dummy'  // Text added to the start of all folders/files

mhawksey

/**
 * This library includes software components derived from the following projects:
 * [ChatGPTApp] (https://github.com/scriptit-fr/ChatGPTApp)
 * [Google AI JavaScript SDK] (https://github.com/google/generative-ai-js/)
 * 
 * These components are licensed under the Apache License 2.0. 
 * A copy of the license can be found in the LICENSE file.
 */

/**

mhawksey

function main(){
  console.log("Run in memory tests")
  inMemory();
  console.log("Run in cache tests")
  withCache();
}


// From https://medium.com/@saravanaeswari22/memorization-in-javascript-f312d66402b2
const memoize = (func) => {

mhawksey

// @OnlyCurrentDoc
const FOLDER_ID = 'YOUR_FOLDER_ID'; // OR 'root' if you want your entire My Drive  

/** 
 * Method One: Using built-in DriveApp / file iterator  
*/
function generateFolderFilesDriveApp() {
  try {
    const folderId = FOLDER_ID;
    const parentFolder = (folderId === 'root') ? DriveApp.getRootFolder() : DriveApp.getFolderById(folderId);

mhawksey

Retrieving and Parsing XML data from Google Workspace Update Blog and Putting it to Google Spreadsheet using Google Apps Script

This is a sample script for retrieving and parsing the XML data from Google Workspace Update Blog and putting it to Google Spreadsheet using Google Apps Script.

At Google Workspace Update Blog, the XML data is provided. By this, the retrieved XML data is parsed with XmlService, and the data is put to Google Spreadsheet. Recently, I got a request for this. So I created this sample script. When this was useful for your situation, I'm glad.

Update: Modified version of the script which keeps inserting new posts after the header row.

mhawksey

/**
 * @file A sample showing how to format date/time values in Apps Script so that they appear in the 
 * user's timezone. View a working version here: 
 * https://docs.google.com/spreadsheets/d/1t_ur0wMw80AXaFkpBXmYclLfGm_kDccYcD5LAGoBkrQ/edit
*/

/**
 * Add menu item after the spreadsheet opens.
 */
function onOpen() {

mhawksey

mhawksey

// Handling inline images and attachments so they can be included in the merge
// Based on https://stackoverflow.com/a/65813881/1027723
// Get all attachments and inline image attachments
const msg = draft.getMessage();
const allInlineImages = msg.getAttachments({includeInlineImages: true, includeAttachments: false});
const attachments = msg.getAttachments({includeInlineImages: false});
const htmlBody = msg.getBody(); 
 
// Create an inline image object with the image name as key 
// (can't rely on image index as array built based on insert order)

mhawksey

// @OnlyCurrentDoc

const BearerTokenKey = 'twitterBearerToken';

function onOpen() {
  SpreadsheetApp
    .getUi()
    .createMenu('Twitter')
    .addItem('Set Bearer token', 'helpers.requestBearerToken')
    .addItem('Sign out', 'helpers.logout')

mhawksey

/**
 * @OnlyCurrentDoc
 */

YouTube.setTokenService(function(){ return getYouTubeService().getAccessToken(); });

// Read data from current sheet and create live events returning details back to sheet
function schedule_events(){
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("YT");
  new cUseful.Fiddler(sheet)