Can Google Spreadsheets be used to auto-fill form data?

Is it possible to link a Google Spreadsheet column, row or cell to auto-fill a drop-down list or email field in a JotForm? I need to be able to display and utilize spreadsheet data on a form dropdown and auto-populate an email field.

I would like to apologize for any inconvenience. If I'm understanding your concern correctly, I'm afraid that it is not possible to prepopulate a field in a form with data coming straight from a Google Spreadsheet.

Most likely, form fields can only be prepopulated with data through URL parameters. Or, with the Spreadsheet to Form widget which uses an Excel file to fill form fields automatically if a respondent provided the correct "unique code".

How-to-Use-the-Spreadsheet-to-Form-Widget

If you have any further questions, please do not hesitate to let us know.