pozhidaevak

Learning Google Apps Script

The best resource for learning Google Script is the official documentation available at developers.google.com. Here are other places that will help you get up to speed.

1. Google Apps Scripts - Snippets by +Amit Agarwal
2. Apps Script Starter - Modern development workflow for building Google Apps Script projects with Babel, Webpack and VS Code.
3. Digital Inspiration by +Amit Agarwal - Google Addons
4. Awesome Google Scripts by +Amit Agarwal
5. O'Reilly - Apps Script - by +James Ferreira
6. Apps Script Webinars - YouTube - by +Eric Koleda

pozhidaevak

# Compiled source #
###################
*.com
*.class
*.dll
*.exe
*.o
*.so
*.pyc

pozhidaevak

// Just change 22nd string to your template :-D
// This script adds "URL" menu to google sheet with one intem "create URL".
// You need select cell range and click on the menu item in order to make links from your cells.
// It can create links by template 123 => https://example.com/browse/123/.

var ss = SpreadsheetApp.getActiveSpreadsheet();

function onOpen() {
  var menu = [{name: "create URL", functionName: "createURL"}];
  ss.addMenu("URL", menu);

pozhidaevak

letterFrequency = {'E' : 12.0,
'T' : 9.10,
'A' : 8.12,
'O' : 7.68,
'I' : 7.31,
'N' : 6.95,
'S' : 6.28,
'R' : 6.02,
'H' : 5.92,
'D' : 4.32,