What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

    How to populate data in a jotform field with data from google sheet?

    Asked by zanesooyk on May 12, 2017 at 05:50 AM

    I need to pre-populate a dropdown box in jot form with data from an integrated google sheet. How do I do it?

  • Profile Image
    JotForm Support

    Answered by Jim_R on May 12, 2017 at 06:51 AM

    I'm afraid our integration with Google Spreadsheet works the other way around. It's not something you use to populate data to your form, it's something that you use to export Submission Data to a sheet.

    The only prepopulation feature we have is through URL parameters and to make things easier, you can use our Prepopulate App to generate the link:


    Another approach to prepopulate fields is to forward them to another form.

    Related guide: How-to-Automatically-Pass-Form-Data-to-Another-Form