Last active
October 15, 2021 08:39
-
-
Save aryamurali/e027517468a4c05a17fb36a3f86ebc29 to your computer and use it in GitHub Desktop.
Create multiple copies of a document and rename using data in google sheet
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* This code helps you create multiple copies of a document in your google drive and rename each of them based on values in a google sheet. | |
In the first column of your google sheet, list down the names of the new files as required. | |
In your google sheet,open tools-->script editor and paste the following code. | |
Open the google doc whose copy is to be made. Copy the text after /d/ and replace the text in line 13. | |
Run the code. You will find your new copies in the same folder as the document whose copies are being made*/ | |
function copyDocs() { | |
var data = SpreadsheetApp.getActiveSheet().getDataRange().getValues(); | |
for (var i in data) { | |
/*Open the google doc whose copy is to be made. Copy the text after /d/ and paste in placeof 1T0tf4KJWKWiG0YVMWxL_FVIKZW__KBWTdSfeXD2FiGk */ | |
var drive=DriveApp.getFileById('1T0tf4KJWKWiG0YVMWxL_FVIKZW__KBWTdSfeXD2FiGk'); // | |
drive.makeCopy(data[i][0]); | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
How can we use it on multiple sheets?