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 integrate Google Docs spreadsheet with Jotform

    Asked by Free4good4 on April 19, 2012 at 12:51 PM

    I am attempting to have an auto populated spreadsheet to show all the Donations I have recieved Via Jotform/Paypal. I followed these instructions http://www.jotform.com/answers/54437-Integration-with-CAPSULE-CRM-or-others on how to import the spreadsheet, but the Paypal Column just show [Table]. What do I need to change?

  • Profile Image
    JotForm Support

    Answered by Mike_T on April 19, 2012 at 06:32 PM

    Thank you for contacting us.

    To get all the data, please try the following method.

    1. Add a CSV Report.

    2. Use the following syntax in Google Docs Spreadsheet:

    =ImportDATA("http://form.jotform.com/csv/report_id_here")

    Where http://form.jotform.com/csv/report_id_here is path to your CSV report.

    Please feel free to contact us if you need any further assistance.

  • Profile Image

    Answered by Free4good4 on April 20, 2012 at 12:00 PM

    My spreadsheet is working perfect now. Thanks for all your help.

  • Profile Image

    Answered by OM on April 25, 2012 at 05:45 PM

    Greetings JotForm Team,

    I hope these few lines reach you in good health and spirits.  I was able to get the speadsheet to upload to g'doc, but the g'doc did not automatically import new data.  Please let me know what I can do to to ensure that new information from jotform will autopopulate the g'doc spreadsheet.

    Thank you,

    OM

  • Profile Image

    Answered by jeanettebmz on April 25, 2012 at 10:17 PM

    @ OM

     Thank you for choosing our products

    Please make sure the id you have integrated into gdocs is the one for CSV report.

    Everytime you recieve a submission , you should have it reflected into gdocs

    Jeanette

  • Profile Image
    JotForm Founder

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

    Yes, you can now! 

    We have just 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.