Is it possible to connect a spreadsheet to my form?

  • Kaylen Hickman
    Asked on March 2, 2023 at 8:55 PM

    Any updated on whether this can be integrated with Google Sheets or any other online spreadsheet?

  • Mary_Ed JotForm Support
    Replied on March 3, 2023 at 1:40 AM

    Hello Kaylen,

    Thanks for reaching out to Jotform Support. Yes, Google sheets integration is now an available feature at Jotform. Let me show you how to set that up:

    • In Form Builder, in the orange navigation bar at the top of the screen, click on Settings.
    • Click on Integrations on the left side of the screen.
    • Select the Google Sheets Integration.
    • Now, select or connect your Google account.
    • Then choose whether you want to create a new spreadsheet or if you want to use an existing spreadsheet.
    • Choose the fields you want to map and then save.

    1677825601 64019641b40ff  Screenshot 10

    We also have a guide about Google Sheets Integration that you can check out.

    Let us know if you need any more help.

  • heetch
    Replied on March 7, 2023 at 10:28 AM

    Hello
    I think that the question was if we can take the Google Sheet data to create list directly in the Jotform and not take data from the Jotform to put it in the google sheet.

    I had the same request, because I will have a dynamic list in a google sheet, and I would like my list in the jotform to udpate when the google sheet update, but I'm not sure it's possible today

    Is it ?

    Thank you for your answer :)

  • Gemmhel JotForm Support
    Replied on March 7, 2023 at 11:07 AM

    Hi Kaylen,

    Thanks for reaching out to Jotform Support. Unfortunately, the feature you're looking for isn't available at Jotform right now. I've 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.

    The closest feature we have is the Spreadsheet to Form widget, which allows you to upload a spreadsheet to your form and use the values you have on the spreadsheet to pre-populate the form.

    Let us know if you have any other questions.