Learn Google Apps Script – Free Source Code Guide Coding exercises and more https://basescripts.com/google-apps-script-exercises-and-code-samples-with-source-code-free-pdf-guide-download Free Apps Script Lessons by Laurence Svekis Google Developer Expert in Workspace (GDE) dataFolder() function The dataFolder() function does the following: Sets the sid variable to a specific Google Sheets ID. Sets the id variable to a specific Google Drive folder ID. Gets the folder with the given id. Opens the Google Sheets file with the given sid, selects the sheet named “files”. Gets a list of files in the folder. Loops through each file in the folder, and for each file: Appends a new row to the “files” sheet in the Google Sheets file with the file name, ID, and size. Logs the file name to the console. newFiles() function The newFiles() function does the following: Sets the id variable to a specific Google Drive folder ID. Gets the folder with the given id. Creates a new Google Docs document with the name “new Doc”. Gets the ID of the newly created document. Gets the file with the ID of the newly created document. Moves the file to the folder with the given id. newFiles2() function The newFiles2() function does the following: Gets the folder with a specific Google Drive folder ID. Creates a new Google Docs document with the name “new Doc 2”. Gets the ID of the newly created document. Gets the file with the ID of the newly created document. Moves the file to the folder with the specific Google Drive folder ID. In summary, the dataFolder() function logs the names of files in a Google Drive folder and adds the file name, ID, and size to a specific Google Sheets file. The newFiles() and newFiles2() functions create a new Google Docs document with a specific name and move it to a specific Google Drive folder. Course content web development and web design courses with coding examples and source code for the lesson content. Source Code is available within my Github account. Lessons posted are designed to help students learn more about a specific topic related to modern web development and applying code. Laurence Svekis is a professional top selling course author having instructed over 1 Million students both online and in person. Laurence Svekis is a Google Developer Expert specializing in Google Workspace automation using Google Apps Script Code. Check out my Website for more details at https://basescripts.com/ Subscribe https://www.youtube.com/@LaurenceSvekisCourses Learn more about Google Apps Script – Free coding lesson – Source Code included #GoogleAppsScript #GAS #AppsScript #GoogleScript #GoogleSheets #GoogleDocs #GoogleForms #GoogleSlides #GoogleWorkspace #GSuite #GSuiteEdu #GoogleEdu #onlinecourses #elearning #distancelearning #onlinetraining #learningonline #onlineeducation #MOOCs #virtuallearning #edtech #educationtechnology #learningsolutions #traininganddevelopment #professionaldevelopment Tags and Keywords #CodeWithGoogleAppsScript #FolderContents #IteratingFiles #SpreadsheetTracking #DocumentService #CreateFiles #AddToFolder #DriveFolder #FolderID #FileIterator #FileID #FileName #NewFiles #MoveFiles #ListFiles #SpreadsheetID #AppendRow #FileInformation #FileSize #FileDateModified