This Google Apps Script creates folders and files in Google Drive based on values in Google Sheets

createFolders.gs

function myFunction() {
  
  // Spreadsheet Variables 
  var ss = SpreadsheetApp.getActiveSpreadsheet(); 
  var sheet = ss.getActiveSheet(); 
  var lastRow = sheet.getLastRow(); 

  // Google Drive Variables 
  var rootFolder = DriveApp.getFolderById("1oqHxYeC8wC0ufJ8WPtq4WKfoJDqulppB"); 

  // Logger.log(lastRow); << 18

  for ( var i = 1; i < lastRow; i++ ) {

    // create folder 
    let title = sheet.getRange(i,1).getValue(); 
    let description = sheet.getRange(i,7).getValue(); 
    if ( title != "title") {
      var folderId = rootFolder.createFolder(title).getId();  
      var folder = DriveApp.getFolderById(folderId); 
      // Logger.log('Folder Name: ' + title + ' Folder ID ' + folderId); 
      
      var docID = DocumentApp.create(title).getId();
      var document = DocumentApp.openById(docID); 
      var paragraph = document.getBody().appendParagraph(description); 
      DriveApp.getFileById(docID).moveTo(folder); 
    }; 
  }
}

Can you make a script with prompt for making folder names and then make folder names with the prompt. I have made a bat exe which runs on command prompt, it asks for

1. Deal Number
2. Deal Name
3. Seller
4. Customer

Based on above information, Parent folder is created with
Parent folder - "Deal Number" + "Deal Name", under this
1st Folder is "Deal Number"+"Deal Name"+"Customer" then "Deal Number"+"Loading Pics"
2nd folder "Seller" then "Deal Number"+"Loading Pics" and "Material Pics"

Loading Pics and Material Pics is static.

In the 2nd folder, a xlsx file is copied and renamed to "Deal Number"+"Shipping Instructions".xlsx

This script can be run on a windows system only, I am planning to shift to chromebook, so I want a script which is platform independent.

Hi @amitm020, yes, you can use ui.prompt to get input from a user, then use that input as a value/parameter in your code.

Everything you currently do with your bat script can be duplicated with Apps Script.

I used the Yu.prompt and the values are coming, how to use these to create folder, can you send a example

…

On Wed, Aug 14, 2024 at 9:38 AM Joseph Palumbo ***@***.***> wrote: ***@***.**** commented on this gist. ------------------------------ Hi @amitm020 <https://github.com/amitm020>, yes, you can use ui.prompt to get input from a user, then use that input as a value/parameter in your code. Everything you currently do with your bat script can be duplicated with Apps Script. — Reply to this email directly, view it on GitHub <https://gist.github.com/palumbo/d81f9541a8ee0829420c97a2a55936c3#gistcomment-5154043> or unsubscribe <https://github.com/notifications/unsubscribe-auth/BKRBNADCI3RU2FLB73LIGPDZRNMVDBFKMF2HI4TJMJ2XIZLTSKBKK5TBNR2WLJDUOJ2WLJDOMFWWLO3UNBZGKYLEL5YGC4TUNFRWS4DBNZ2F6YLDORUXM2LUPGBKK5TBNR2WLJDHNFZXJJDOMFWWLK3UNBZGKYLEL52HS4DFVRZXKYTKMVRXIX3UPFYGLK2HNFZXIQ3PNVWWK3TUUZ2G64DJMNZZDAVEOR4XAZNEM5UXG5FFOZQWY5LFVEYTEMZYHEYDSMJUU52HE2LHM5SXFJTDOJSWC5DF> . You are receiving this email because you were mentioned. Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub> .