3

There are two basic categories of Apps Script files - Bound to the document (Sheet, Doc, Form) Stand Alone Bound files do not show up in your Google Drive. Stand Alone Apps Scripts files do show up in your Google Drive. You can create multiple projects inside of an Apps Script file, but projects in other files can not be searched or loaded into the code ...


3

To select cells with a script: var sheet = SpreadsheetApp.getActiveSheet(); var rangeList = sheet.getRangeList(['C3', 'C7', 'C17', 'C56']); sheet.setActiveRangeList(rangeList); The last range in the list is set as the active range. To type in a dialog box: function promptRangesList() { var ui = SpreadsheetApp.getUi(); var response = ui.prompt('Comma-...


1

Publish a Google Add-on to the G Suite Marketplace Basic Concepts: You must use the G Suite Marketplace SDK in order to get to the “Publish” section for publishing an add-on, and you must first open the Google Cloud Platform for your specific project (apps script file) The G Suite Marketplace SDK must be enabled in the Google Cloud Platform The two ...


1

The FormCreator app was created using Google Apps Script. For more specific details see Develop Add-ons for Google Docs, Sheets and Forms


1

I think a hack is possible for one category at a time. Select the category, scroll down to the last entry (no See More), Ctrl+A, Ctrl +C, then in the top row of a spreadsheet Ctrl+ V, scroll down to the last entry and read off its row number. Currently I make it 221 for Business Tools and 424 for Productivity, for example.


1

I wasn't logged in when I asked this question, but here is the script I am using to achieve this if anyone wants to use it. function CopySheet() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var data = ss.getSheetByName("sheet1").getDataRange().getValues() var newSh = ss.insertSheet(ss.getSheets()).setName(ss.getSheetByName("sheet1").getRange(4,1)....


Only top voted, non community-wiki answers of a minimum length are eligible