Learn Google Apps Script
I learned a little JavaScript which is applicable to Google Apps Script. This allows me to code Google Docs, Sheets, Slides, Forms, etc… to create custom applications. Here are some tutorials for getting started. I also offer an online workshop for you to learn how to code: alicekeeler.com/goslow.
Apps Script Tutorials
Start Here: A Quick Google Apps Script Project
Coding Will Save You Hours Of Your Life
Code a List of Your Calendar Events
Google Apps Script: Code Insert a Sheet
Start Here: A Quick Google Apps Script Project
Google Apps Script: Getting Started Part 2
Google Apps Script: You Can Code (part 3)
Google Apps Script: Format a Sheet
Google Apps Script: Create an Add-On
Google Apps Script: Create an Alert
Google Apps Script: Create Your Own Mail Merge
Google Apps Script: Make Row Taller on Form Submit
Google Apps Script: Create New Tabs
Kids Code: Create an Add-on Menu
Google Apps Script Picker Tutorial
Additional Tutorials
The Google Apps Script developers page offers getting started tutorials.
googleappsscript.org is not specifically designed for teachers but has some very helpful tutorials to help you figure out those elements of your code you are trying to do. Remember to steal steal steal. I don’t generally code from scratch. I find other people’s code online, copy and paste it, and modify it.