Hello there!
It would be great to get the details of the project. Do you mean you need to create the form on the fly based on data in the spreadsheet? I have done several projects like this recently, so it is quite fresh in my mind.
If I understood the task correctly, then the way I would implement it, you would have to click a button in the spreadsheet, the form will be created and then saved to the drive and the link to it can be sent to the users.
Let me know if you want to discuss this further.
Cheers,
Denis