The download /back-up of Google scripts (.gs files) bounded to Google Spreadsheets
I have google spreadsheets having Google scripts (.gs files) bounded to it. When I download them from Google Drive, only csv or xlsx get downloaded. The associated scripts files (.gs files) are not downloaded. However the standalone scripts can be downloaded from Google Drive. How can the back up of Google scripts (.gs files) bounded to Google Spreadsheets can be taken? How can they be downloaded?
You can back up file-bound scripts locally on your machine using the command line tools for Google Apps Script (clasp).
The clasp is an open-source tool, provided by Google, to interact with Google App script projects. It may be used, for instance, to develop websites or Google Docs plugins locally instead of using the web environment. You can use clasp to download or to deploy projects to the Google App Scritps.
You may check a tutorial in a the Google codelab for Clasp.
Making a copy of a Google Apps Script project
To use
clasp, you must install first Node-js. You can download an installer for Windows or Linux from the official websiteOne installed Node.js, you must install
clasp. Using a command line terminal, you may executenpmto perform the installationnpm install -g @google/claspAfter installing
clasp, you can download the project files using the script id. You can go to Google Script Editor and copy the Script Id under File -> Project properties.
On your computer, create a folder for the project and navigate into the newly created folder. You can use a File Explorer to create the folder. Using Windows, Linux or Mac, you can create the folder using the command line terminal and the following commands:
mkdir gas-project cd gas-projectFinally, to make the copy, you must execute the following command, where 'scriptid' is the id you copied from Project properties.
clasp clone <scriptid>
Once you have a local copy of the files, you can run clasp pull to update the code locally or clasp push to send any locally-made changes to the server.
- How can I use Google Sheets Apps Script to Auto Generate today's date when an edit is made to a given column?
- An explicit urlFetchWhitelist is required for all Google Workspace add-ons using UrlFetchApp error while deploying sheet add on
- how to show instruction with image after install google workspace extension
- Regular expression to extract valid cell references from a spreadsheet formula
- My Google Apps script regex requires a match for either one expression or another.
- If checkbox checked set values
- Clarification on using the forEach() function
- Rank based on which column is being sorted by in a Table
- Auto border to a Dynamic Data
- How can I determine if a respondent's email address is unique in a list?
- Sum a number of range values; process and add to array
- Fill Google Form from Other Google Form Responses
- Downloading a PDF version of the open spreadsheet in Google Drive via scripts
- exporting spreadsheet to pdf then saving the file in google drive
- Convert a Markdown text file into a Google Document
- A Script to Simplify Creating a SO Table
- Archive a row after a dropdown status is selected on multiple sheets
- Get Google Sheet by ID?
- Google Sheets macro to copy a line of data to next empty row on another sheet
- Error 'Action Not Allowed' When Copying Content with a Vertical Line in Google Docs
- Remove an attachment of a Gmail email with Google Apps Script
- Google Apps Script switching html files
- How to make a simple authentication in Google Forms using Google apps script?
- Can a google-apps-script be written to download a csv file from spreadsheet directly to a local hard drive with an onEdit trigger?
- API call to directory.members.insert failed with error: Resource Not Found: groupKey
- Clone Folder/Files From Another Account With Apps Script
- Apps Script Delete Image
- DO NOT send notifications when share a file
- App Script to download specific cells in Google Sheet to PDF
- Export Google Docs comments into Google Sheets, along with highlighted text?