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 can I use jotform to automatically populate a google spreadsheet?

    Asked by icovfx on June 22, 2010 at 09:14 PM
  • Profile Image
    JotForm Founder

    Answered by aytekin on June 22, 2010 at 09:20 PM
    You cannot create Google spreadsheets but you can create regular Excel spreadsheets. On My Forms page, select one of the forms and then click on Reports. Then select "Excel" options to create a live feedback which can be bookmarked so that you can get the latest list of submissions.
  • Profile Image

    Answered by perhapslater on September 18, 2011 at 11:10 PM

    Hello,

    I seem to be able to automatically upload my form submissions into google spreadshets.

    I employ the =importhtml function to grab the HTML Table Report from Jotform.

    Below are two examples.  The first simple example updates more slowly, up to an hour between updating.  The second example,  employs google finance functions to force the spreadsheet to update every two minutes.  The second example does add a disclaimer to the spreadsheet about stock quotes because using the google finance function triggers this disclaimer.  Of course, I doubt you will actually be storing stock quotes in your form.

    Furthermore, in the second option you can change the number, highlighted in yellow below, to choose how often, in minutes, the spreadsheet updates.  It is set to every two minutes, below.

    Replace the green highlighted area with the URL of your form report after making an HTML Table Report.

    To get started copy one of the options below and paste it into a blank google spreadsheet in cell A1, for example.  Be sure to change the table # to the # of your form report.  The data should load into the spreadsheet.  Good luck!

     

    =ImportHTML("http://www.jotform.com/table/###########"; "table";1)

     

    =ImportHTML("http://www.jotform.com/table/#########" &"?workaround="&INT(NOW()/TIME(0;2;0))&REPT(GoogleFinance("GOOG");0) ; "table";1)

     

    Eric

    P.S.  here is a link to a doc someone wrote explaining some of how the second example works with Google Finance

  • Profile Image

    Answered by brx250 on September 19, 2011 at 01:43 AM

    Hi Eric,

    That's a very clever solution! Thank you for sharing it. We are pretty sure many users would be benefited from the provided solution.

     

    Cheers! :)

    _____________________________________________    

    Albert  JotForm Support  

  • Profile Image

    Answered by lshad24 on September 22, 2011 at 10:23 AM

    Worked great! 

  • Profile Image

    Answered by brx250 on September 22, 2011 at 08:31 PM

    Hi Ishad24,

    We're glad to know that this has been of any help to you. And I expect many users will do, too. 

    Again, cheers! Enjoy using JotForm! :)

    _____________________________________________    

    Albert  JotForm Support  

  • Profile Image

    Answered by on January 13, 2012 at 03:52 PM

    Thanks for providing this solution. It's inovative companies such as yours that make it possible for the little guys to compete with the bigger companies.

  • Profile Image
    JotForm Founder

    Answered by aytekin on May 07, 2012 at 01:10 PM

    UPDATE: We have now released integration with Google Docs:

    http://www.jotform.com/blog/57-Google-Docs-Integration-Send-Responses-to-Google-Spreadsheets-Instantly-

    You can get your submissions directly in a Google Docs Spreadsheet. Please give it a try and if you have any further comments or suggestions, post it on the blog post comments.