Pull data from google drive

  • Profile Image
    Kyle Roberts
    Asked 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 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 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
    Answered 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.