Google Apps Scripts
The onOpen() function is automatically executed when the document is opened:
https://developers.google.com/apps-script/guides/triggers/#onopen
Create a new menu:
https://developers.google.com/apps-script/reference/base/ui#createMenu(caption)
Google Script: From Table to Calendar
You can find the original instructions here: https://habr.com/ru/articles/529332/ The schedule…
Google script: HTML Service (sidebar output)
Class google.script.run (Client-side API):https://developers.google.com/apps-script/guides/html/reference/run ‘Close Sidebar’ button is clicked:https://developers.google.com/apps-script/guides/html/reference/host#close() https://developers.google.com/apps-script/reference/base/ui#showsidebaruserinterface…
Google script: Dialog boxes (ui.alert, ui.prompt)
https://developers.google.com/apps-script/reference/base/ui#alerttitle-prompt-buttons https://developers.google.com/apps-script/reference/base/ui#prompttitle-prompt-buttons Original version: My version with changes or enhancements:…
Google script: LanguageApp (text translation)
The onEdit function is a trigger that fires when a…
Google script: MailApp (sending emails)
https://developers.google.com/apps-script/reference/mail/mail-app Sending a simple email: Original version: My version with…