This could work great with sql2sheets[1] new feature[2] I launched yesterday, which lets you collect html form responses directly to google sheets, if you want to stay on brand and not use the google forms product.

[1]https://sql2sheets.com

[2]https://www.youtube.com/watch?v=jAgbhPRT9D4