I was unable to make this work. Probably me being thick, as I’m a bit of a noob with this sort of thing. I clicked submit and nothing happened (both on local and when deployed).
If anyone else has this problem, I ended up starting from scratch and following these instructions: https://github.com/jamiewilson/form-to-google-sheets
…and it worked.