Populate form fields with data from Google Spreadsheet

Quiero llenar campos a partir de una hoja de calculo de google, no de un excel. Ya que la información que contiene es dinámica

Vi la opcion hoja de calcula a formulario pero no me sirve

Hi modernizacionroldan,

Thanks for your feedback. Unfortunately, our Spanish Support agents are currently busy helping other Jotform users. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Spanish, let us know and we can have them do that. But, remember that you'd have to wait until they're available again.

We have a Spreadsheet to form widget widget that you can use to import your data, but it won't populate the Product List field. Let me show you how to use it:

• Create a spreadsheet that includes your data in the structure you see below. The column names in the spreadsheet and field names on the form must be the same.

• In Form Builder, click on the Add Form Element menu on the left side of the page.
• Under the Widgets tab, search for the Spreadsheet to Form widget and add it to your form.

• In the Widget Settings window that opens up, upload your data file and customize the other options. 
• Then, click on Update Widget.

• In the final stage, add the fields to view values and name them the same as on the spreadsheet.

Give it a try, and let us know if you need any help.

Thank you but Spreadsheet to form widget  only accept Excel and I need to use Google Sheet.

Hi modernizacionroldan,

Thanks for getting back to us. Unfortunately, it's currently not possible to fill out the form with data from the Google Spreadsheet. The closest you can get is the Spreadsheet to Form widget, however, it only accepts Excel Spreadsheet.

We've gone ahead and escalated your request to our developers, but when or if it's developed depends on their workload, how viable it is, and how many other users also request it. If there are any updates, we’ll circle back to this thread and let you know.

Thanks for your patience and understanding, we appreciate it.