Puxar informação de um Google Sheets para o formulário

Eu preciso puxar uma informação do Google Sheets para um formulário.

Como eu posso fazer isso? Eu só achei o contrário. Enviar para um Sheets as respostas do formulário.

Hi Julio,

Thanks for reaching out to Jotform Support. Unfortunately, our Portuguese Support agents are busy helping other Jotform users at the moment. 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 Portuguese, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

Now, let me help you with your question. You're right, our current Google Sheets integration can only send data to Google Sheets. However, we have the Spreadsheet to Form Widget where you can upload an Excel file and then prefill the form fields with data from the Excel document. This only works with Excel documents. Visit our guide on How to Use the Spreadsheet to Form Widget or follow the steps below:

• Create a spreadsheet that includes your data in the structure you see below. It's important that the column names in the spreadsheet and field names on the form are 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.