Google's provided solution for scripting within Google Sheets is Apps Script[?], which essentially runs within a Javascript runtime.
Other things to be aware of: