How can I use jotform to automatically populate a google spreadsheet?

  • Profile Image
    Asked on June 22, 2010 at 09:14 PM
  • Profile Image
    Answered 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 on September 18, 2011 at 11:10 PM


    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(""; "table";1)


    =ImportHTML("" &"?workaround="&INT(NOW()/TIME(0;2;0))&REPT(GoogleFinance("GOOG");0) ; "table";1)



    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 on September 22, 2011 at 10:23 AM

    Worked great! 

  • Profile Image
    Answered 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
    Answered on May 07, 2012 at 01:10 PM

    UPDATE: We have now released integration with Google Docs:

    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.