I got it working!
for others to note. If you run the script in googleScript, you will get an error. That is because this is not a standalone script, which is a thing you can do in google script as this allows for trigger actions. But, our trigger action requires inputs via the query parameters and therefore will always produce the error.
I’m not sure exactly what the problem was but here is my working codes!
Thanks @cttricks
