Spreadsheet to form Widget: Option to connect Google Sheet

Is there a way to connect a Google Sheet to the "spreadsheet to form widget"?

We need to ensure that any updates we make are reflected in the form.

If it's not possible, is there a way to automatically refresh the widget whenever we make an update to our spreadsheet? Or should I continue manually uploading it to my widget?

Hi Andrew,

Thanks for reaching out to Jotform Support. You can actually use Google Sheets in your Spreadsheet to Form widget. Just make sure to download it as an .XLSX file. Check out my screenshot below:

But unfortunately, it is currently not possible to connect the Google Sheet to the widget and automatically refresh it whenever you make any updates to the sheet. You will have to manually upload it to your widget every time you make changes to the sheet.

While the feature you’re looking for isn’t currently available, rest assured we’re always working to add new services and features to Jotform. I've gone ahead and escalated your request to our Developer Team. When or if it's developed depends on their workload, how viable it is, and how many other users request it. If there are any updates, we’ll circle back to this thread and let you know. 

Let us know if there’s anything else we can help you with. 

Hi Neil,

If this is the case, what can you recommend for us while waiting for thesidget development?

Hi Andrew,

Thanks for geting back to us. In the meantime, the best workaround is to manually update the Excel file in the widget which you already mentioned on your initial message. Currently, that is the simplest way to do it.

Let us know if there’s anything else we can help you with.