Getting started Appscript is pretty powerful and free, it is javascript with google api for manipulating things. Begin with a sheets document. Open tools/script editor Write in Code.gs Rename to some Run with the triangle button Ctrl + Enter to see the Log Save it Since most of the time I am operating on some selected range, you would first select on some cells before running the script.