Copying a spreadsheet copies all linked files as well

by

How about this workaround? In this workaround, Sheets API is used for copying a Spreadsheet. In the case of copy() of Class Spreadsheet, makeCopy() of Class File and Files: copy of Drive API, the copied spreadsheet includes the bound scripts and linked forms. So I thought to use Sheets API. The flow of this workaround is as follows.

  1. Retrieve object of source Spreadsheet using spreadsheets.get.
  2. Create new Spreadsheet by including the retrieved object using spreadsheets.create.

By this flow, the copied Spreadsheet without including the bound scripts and linked forms can be created. The sample script is as follows. When you use this script, please enable Sheets API at Advanced Google Services and API console. You can see about how to enable Sheets API at here.

Sample script :

var fileId = "### fileId of source Spreadsheet ###"; // Please set here.
var obj = Sheets.Spreadsheets.get(fileId, {fields: "namedRanges,properties,sheets"});
Sheets.Spreadsheets.create(obj);

Note :

  • When you use this script, please set fileId of source Spreadsheet.
  • At spreadsheets.create of Sheets API, the Spreadsheet cannot be created in the specific folder. So the copied Spreadsheet is created to root folder. If you want to create it in the specific folder, please move it after the Spreadsheet was copied. Of course, you can do it using script.
  • If you want to include developerMetadata of Spreadsheet, please add it to fields.

References :

If this was not what you want, I’m sorry.

More Related Contents:

  1. How to automatically import data from uploaded CSV or XLS file into Google Sheets
  2. Google app scripts: email a spreadsheet as excel
  3. Moving Files In Google Drive Using Google Script
  4. GAS “On edit” trigger not running when edited from API
  5. How to convert a Google Sheets-File to an Excel-File (XLSX)
  6. Script to convert .XLSX to Google Sheet and move converted file
  7. email notification if cell is changed
  8. Converting .xls to google spreadsheet in google apps script
  9. google script openById : You do not have permission to perform that action
  10. ArrayFormula is breaking the getLastRow() funtion. Possible workarounds?
  11. Google Sheets OnEdit() – You do not have permission to call a service
  12. Creating anchored comments programmatically in Google Docs
  13. Detect user inserting row or column in a google spreadsheet and reacting in a script
  14. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  15. How to get onFormSubmit to trigger automatically?
  16. File movement between Google Shared Drive (team drive) folders using Apps Script
  17. onEdit simple trigger never seems to be triggered
  18. How to get filtered values from Filter after using setColumnFilterCriteria?
  19. Protect ranges with google apps script
  20. How to access new ‘in-cell-image’ from google apps script?
  21. How to allow onEdit function to affect protected cell in a Google Sheet?
  22. Creating and Sending sheets in the same function
  23. How do I know if spreadsheet cells are merged using google apps script
  24. How to use a formula written as a string in another cell [evaluate for Google Spreadsheet] [duplicate]
  25. Google apps script error: “You do not have permission to call protect” [duplicate]
  26. TypeError: Cannot read property ‘getRange’ of null (line 6, file “Code”) in google sheet script [duplicate]
  27. .setFormula() and received error missing ) argument list
  28. How can I merge multiple tabs in a Google Spreadsheet using Google App Script?
  29. Accessing shared drive with DriveApp
  30. Convert a gdoc into image

Leave a Comment