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

    JotForm submission doesn't update Google Spreadsheet

    Asked by ardin on March 10, 2016 at 11:00 PM


    I have created a form and integrated it to Google Drive and Spreadsheet. Every time I test it, it doesn't update my spreadsheet but I did receive a PDF copy of my submission in my Google Drive. I already did un-integrate and intergrate twice.

    We need this asap, please assist.

    Page URL:

  • Profile Image
    JotForm Support

    Answered by ashwin_d on March 11, 2016 at 12:20 AM

    Hello ardin,

    I did clone your form and integrated it with my google spreadsheet. I am unable to replicate the issue you are having. Submission data was copied successfully to google spreadsheet. Please check the screenshot below:


    Have you made any changes to the columns of integrated google spreadsheet? I would suggest you to please re-integrate your form again with google spreadsheet and test your form again. Please do not make any changes to google spreadsheet and see if the submission data is being copied or not.

    We will wait for you response.

    Thank you!

  • Profile Image

    Answered by ardin on March 11, 2016 at 01:05 AM

    Hi Ashwin,

    I did reintegrate again and it worked. Does this mean I cannot add a column or add a new sheet? If yes, that's frustrating.

  • Profile Image
    JotForm Support

    Answered by Chriistian on March 11, 2016 at 02:31 AM

    That is correct. Unfortunately you cannot add a column or sheet in the spreadsheet as it may affect the integration and cause the submissions to not be sent to the spreadsheet. 

    If you need further assistance, do let us know.

  • Profile Image

    Answered by metapon on May 16, 2017 at 03:39 AM

    Ardin - try use a new sheet and use =importrange function to import form output.