publish a Google Spreadsheet through Google Apps Scripts

by
  • You want to achieve File > Publish to the web... using Google Apps Script.

If my understanding is correct, how about this sample script?

When you use this script, please enable Drive API at Advanced Google Services.

Sample script:

var spreadsheetId = "###"; // Please set this.
Drive.Revisions.update({published: true, publishedOutsideDomain: true, publishAuto: true}, spreadsheetId, 1);

Official document:

  • publishAuto: Whether subsequent revisions will be automatically republished. This is only populated and can only be modified for Google Docs.
  • published: Whether this revision is published. This is only populated and can only be modified for Google Docs.
  • publishedOutsideDomain: Whether this revision is published outside the domain. This is only populated and can only be modified for Google Docs.

Note:

  • Spreadsheet has the revision ID of 1 as the default, when new Spreadsheet is created. And by publishAuto, when the Spreadsheet is updated, the updated Spreadsheet is automatically reflected to the published Spreadsheet.
    • I used them to this sample script.
    • If you want to modify this settings, please modify the script.

References:

If I misunderstood your question and this was not the result you want, I apologize.

Edit:

About the URL of published Spreadsheet, when the Spreadsheet is published manually, the URL can be retrieved like https://docs.google.com/spreadsheets/d/e/2PACX-###/pubhtml. In this case, 2PACX-### is not the Spreadsheet ID. Unfortunately, in the current stage, this URL cannot be retrieved by API. Drive API v2 had retrieved it with publishedLink before. But now, it cannot be retrieved. When Drive API is updated from v2 to v3, publishedLink was removed. This is the current situation.

But as a workaround, you can create the URL of published Spreadsheet using Spreadsheet ID. Please check the following URL.

    https://docs.google.com/spreadsheet/pub?key=### spreadsheetId ###

You can access the published Spreadsheet using above URL.

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. Initiate a download from google apps script
  13. How to convert a Google Sheets-File to an Excel-File (XLSX)
  14. Google script replaceAllShapesWithImage with image from drive doesn”t work any more
  15. Script to convert .XLSX to Google Sheet and move converted file
  16. In Google Apps Script, how would I get all subfolders and all subsubfolders and all subsubsub folders etc.?
  17. Creating a zip file inside Google Drive with Apps Script
  18. How do I create a file in a folder?
  19. Converting .xls to google spreadsheet in google apps script
  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. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  25. Upload an image to s document
  26. “SpreadsheetApp.getUi() cannot be called from this context”
  27. Get All Links in a Document
  28. Is there any limit on number of concurrent hits or simultaneous executions on Google App Script Web App
  29. It it possible to change the from address when using sendEmail?
  30. How can I merge multiple tabs in a Google Spreadsheet using Google App Script?

Leave a Comment