@kyleheney If you know javascript you are way ahead of the game. Google script is basically a clone of Javascript.
I put together this bare bones spreadsheet and script as a demo.
Make a copy and give it a try. Go into Tools/Script Editor. Then run it using the debugger (icon of a bug). You can set up breakpoints by clicking just to the left of the line numbers. You will see a red dot. If it’s the first time trying a script search YouTube for a short beginner tutorial.
You will have to authorize the script by going through a few screens and warnings about it being able to access your spreadsheets and email. Since you are the owner of the script and know what it is doing just keep allowing it.
Let us know how you make out.