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 have the product options in my forms pull from either QuickBooks or Google Sheets?

    Asked by dansilver1005 on May 29, 2017 at 10:23 AM

    I have all of my products and pricing in QuickBooks and in a Google Sheets. Instead of having to manually add them to my order form, I'd like for the order form to connect with either Google Sheets or QuickBooks, so the information automatically pulls in as I update it. Otherwise, I will have to update the same info in multiple places.


    How can I accomplish this?





  • Profile Image
    JotForm Support

    Answered by ashwin_d on May 29, 2017 at 11:23 AM

    Hello Dan,

    Unfortunately it is currently not possible to populate the product data from any external source or previous submission data. 

    The only option is to manually add products and prices.

    Thank you!

  • Profile Image

    Answered by dansilver1005 on May 29, 2017 at 01:43 PM
    So all integrations are only one way? In other words, form data can be pushed into google sheets but data in sheets can't be used to populate fields?
    Is there a third party solution like zapier or Piesync that can bridge the two for 2 way integration?
    Or can I upload a csv file at least to populate the fields?
    Sent from my iPhone
    Please excuse any spelling errors, grammatical errors or other typographical mistakes. :)
  • Profile Image
    JotForm Support

    Answered by Kevin_G on May 29, 2017 at 02:28 PM

    Yes, you're correct, I have checked on Zapier and I cannot find a way to get information from Google Spreadsheet to pre-populate in a JotForm form. You cannot import products or data from external sources in a JotForm. 

    You could generate your own script to display the information from an external source, but this would require to get the source code of your form.