![]() Let fileId = sheet.getRange(1,2).getValue() However, since the fileId corresponds to a range in the sheet, you can pass directly the range - so instead of using “fileId”, you could use this: let sheet = SpreadsheetApp.openById(“spreadsheetId”).getSheetByName(“sheetName”) function myFunction() ")įinally, in order to copy each file, you can make use of Apps Script’s DriveApp, something similar to this: DriveApp.getFileById(“fileId”).makeCopy(“destination”) So, before you use this script, please enable Drive API at Advanced Google services. Please copy and paste the following script to the script editor of your Google Spreadsheet including 200 hyperlinks like. ![]() The method for installing the library can be seen at the official document. 1HLv6tWz0oXFOJHerBTP8HsNmhpRqssijJatC92bv9Ym6HSN69_UuzcDk Ref So I created this library for using the batch request with Google Apps Script. Ref I thought that the request of the batch request might be a bit complecate. In this script, in order to achieve the batch request, a Google Apps Script library is used. So, in this answer, I would like to propose to copy the files of 200 hyperlinks using the batch request. When the batch request is used, the process cost will become low because the batch request is run with the asynchronous process. You want to achieve this using Google Apps Script.įrom the number of hyperlinks, I thought that in this case, the batch request might be useful for your situation.You want to copy the Google Slides to the specific folder in your Google Drive. ![]() You have the Spreadsheet including 200 hyperlinks of Google Slides like.I believe your current situation and your goal as follows.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |