We were recently considering quick prototyping using Google Forms but ran into two key limitations:

(1) Getting a _validated_ email address of the submitter. It does support an email field, but makes it a free-form text input with no way of enforcing ownership of that email.

(2) Pre-populating some of the fields when we send the user to a form via a link. Without this, the user ends up filling the fields even though they have already submitted that information in another form.

Are there any powerful (forms + spreadsheet) products out there that solve these (and are cheaper than, say, AirTable) ?

(2)