Initiate a download from google apps script

by

EDIT : read the comments below, Zig Mandel is perfectly right when he points out the limitations of the “complicated” version, it was really a simple (and fun) exercice to show other methods.

I think you’ll have to use an intermediate Ui as a popup to confirm the download.
After that there are 2 possible ways that I know, one is very simple and the other is quite cumbersome, make your choice, the code below shows both of them.

note : to use the complicated one you need to deploy your app (ie save a version and deploy as webapp), for the simple one just use it “as it is”. (I show the simple in the code comments).

The code :

function onOpen() {
  var menuEntries = [ {name: "test download", functionName: "downloadFile"}
                     ];
  var sheet = SpreadsheetApp.getActiveSpreadsheet();
  sheet.addMenu("Utils",menuEntries);
}

function downloadFile(){
  var file = DriveApp.createFile('test file', 'Some content in this file to test it');
  var fileID = file.getId();
  var fileName = file.getName();
  var ui = UiApp.createApplication().setTitle('Download');
  var url = ScriptApp.getService().getUrl()+'?&ID='+fileID+'&name="+fileName;
  var p = ui.createVerticalPanel();
  ui.add(p);
  p.add(ui.createAnchor("click to download', url));
  p.add(ui.createAnchor('or use this link ',file.getDownloadUrl()));// this is the simple one, just get the file you created and use getDownloadUrl()
  SpreadsheetApp.getActive().show(ui)
}

function doGet(e){
  var fileId = e.parameter.ID;
  var fileName = e.parameter.name;
  var fileString = DocsList.getFileById(fileId).getContentAsString();
  return ContentService.createTextOutput(fileString).downloadAsFile(fileName);
}

PS : I had some fun writing this, the “complicated version” is really funny imho 🙂

More Related Contents:

  1. How to automatically import data from uploaded CSV or XLS file into Google Sheets
  2. Easiest way to get file ID from URL on Google Apps Script
  3. Creating anchored comments programmatically in Google Docs
  4. Transfer ownership of a file to another user in Google Apps Script
  5. Google app scripts: email a spreadsheet as excel
  6. How to use ContinuationToken with recursive folder iterator
  7. Moving Files In Google Drive Using Google Script
  8. Correct usage of DriveApp.continueFileIterator(continuationToken)
  9. File movement between Google Shared Drive (team drive) folders using Apps Script
  10. Copying a spreadsheet copies all linked files as well
  11. Permanently delete file from google drive
  12. How to convert a Google Sheets-File to an Excel-File (XLSX)
  13. Google script replaceAllShapesWithImage with image from drive doesn”t work any more
  14. Script to convert .XLSX to Google Sheet and move converted file
  15. In Google Apps Script, how would I get all subfolders and all subsubfolders and all subsubsub folders etc.?
  16. Creating a zip file inside Google Drive with Apps Script
  17. How do I create a file in a folder?
  18. Converting .xls to google spreadsheet in google apps script
  19. publish a Google Spreadsheet through Google Apps Scripts
  20. Accessing shared drive with DriveApp
  21. google script openById : You do not have permission to perform that action
  22. Convert a gdoc into image
  23. Download file from Google Drive to local folder from Google Apps Script
  24. Google app script timeout ~ 5 minutes?
  25. How to understand LockService and implement it correctly?
  26. Navigating embedded Google Apps Script iFrame from the parent
  27. Why does google script editor stop paren matching after 100 lines in a function and does it affect the code?
  28. Google Apps Script Auto Generated Library Documentation
  29. Margins parameters for Google spreadsheet export as PDF
  30. Hidden field in a Google Form

Leave a Comment