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

    Pull data from google drive

    Asked by Kyle Roberts on June 06, 2013 at 02:26 PM


    I was wondering if it is possible to create a form that can pull data (like customer information) from a google spreadsheet and then auto-populate the information?




  • Profile Image

    Answered by dinesh-it on June 06, 2013 at 03:11 PM

    Hi, I think there is some workarround to pull data from google drive. If you are a programmer you can try this. Refer this link for Google Spread sheet Javascript API and here is the working Sample.

    Once You know how to retrive the data from spreadsheet and all, you can refer this Guide for Prepopulating-the-fields-to-your-JotForm-via-URL-parameters.

    Unfortunately currently you cannot directly pull data from google spreadsheet via JotForm.

    Hope this helps you.

    Thank you.

  • Profile Image

    Answered by JuggleGod on January 14, 2017 at 08:08 PM

    Hi, I was about to ask this same question, but saw that it was answered a few years ago. Has anything changed with this as I'd also like to be able to pull up customer information from a google drive spreadsheet. I don't have any formal programming training, so I'm going at this on my own.


  • Profile Image
    JotForm Support

    Answered by Jim_R on January 15, 2017 at 09:43 AM

    @JuggleGod - This is an old post so I moved your question to a separate thread: https://www.jotform.com/answers/1034911

    We'll have it addressed there shortly.