I need to autopopulate a jotform using a certail field as a unique code from spreadsheets?

I know I can do this by uploading an Excell file but, I want the data to be read from a Google spreadsheet which will be continuously updated by a jotform. The Exell file that I will be uploading will be static and, won't update automatically.

Unfortunately, we don't have a built-in way to pull data from Spreadsheet and show it in the form. The closest way I could think now is to have Prepopulate URL created in Spreadsheet that when you click it opens the Form and prepopulates it.

But that will require clicking of the link so the prepopulated form will open from Spreadsheet.

But basically it would look like this:

The prepopulate column I created manually, and this is the formula: =HYPERLINK("https://form.jotformpro.com/71801383290958?name="&B2&"&name[last]="&C2)

If you think that could work please let us know.

Thank you!