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

    Funnel form submissions to an existing Google Spreadsheet

    Asked by FarmigoSupport on October 15, 2013 at 11:02 AM

    Hi,

    I would like to know if it's possible to have form submissions populate a pre-existing spreadsheet in Google Docs.  Do you have a help page on how to set that up?

    Thank you,

    Submissions
  • Profile Image
    JotForm Support

    Answered by ardy0689 on October 15, 2013 at 11:33 AM

    Hello. Yes this is possible with JotForm. There are 2 ways that you can do this:

    From "Integrations Wizard":

    1. Click "Setup & Embed"

    2. Click "Integration" button and "Integrations Wizard" will popup

    3. Click "Document Sharing Tab"

    4. Choose "Google Spreadsheets"

     

    5. Click "Authenticate" button

     

    6. Click "Authenticate" again from the popup window

     

    7. Click "Next"

     

    8. Fill the required fields: Folder Title and the Spreadsheet Name

     

    The second one is using our Google Spreadsheet Integrations App. It will automatically create a form that will redirect you into the Integrations steps.

     

    As for using existing spreadsheet, I advise that you send a test submission for the new integration and use the created template by JotForm and adjust the columns accordingly on your existing template.

    For further info please refer to this guide:

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

  • Profile Image

    Answered by chantinon on February 23, 2015 at 09:25 PM

    One problem use Form Spreadsheet with integration, i necessary others columns and thats columns eliminated if created in form spreadsheet. Whats solution? 
  • Profile Image
    JotForm Support

    Answered by Welvin on February 24, 2015 at 07:10 AM

    @chantinon,

    Your question will be answered to this thread: http://www.jotform.com/answers/521467.

    Thank you!

  • Profile Image

    Answered by WheelsofJustice on March 06, 2016 at 10:38 AM

    is the google sheets/forms integration two way, so that a if I edit in Google, will it change the submission in jotform ?

     

    thanks

  • Profile Image

    Answered by FarmigoSupport on March 06, 2016 at 10:45 AM
    ## Please do not write below this line ##
    Hello!
    I am out of the office currently. If this issue is urgent and you cannot wait for a response until Monday, please call my cell at 347-450-3307. This will ring my cell phone and send me a text message with your voicemail if I cannot answer immediately. Urgent issues include not being able to access your system or members not being able to access your system. Of course, if you think something is urgent, you can call!
    Thank you,
    Karli
    [N8LORK-PP01]
    ...