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

    Google Spreadsheet: Integrating not updating modified sheet

    Asked by shand on November 08, 2016 at 03:14 PM

    Hello,

    I have integrated my Affiliate Prep Call Sheet with a google spreadsheet.  However, it is not updating the spreadsheet when new submissions are added.  

     

    I have seen in the forums that if the spreadsheet is revised is breaks the integration.  I have gone back and reintegrated the form and the spreadsheet and the new submission were added, however, I then had to copy and paste the new information into the original spreadsheet in which I had to revise the format to meet my needs.  

     

    Can you tell me if there is an issue with the integration?  Why won't it add the new submissions into my formatted spreadsheet?  Copying and pasting the new submission is huge inconvenience as I use this information on a daily basis all day long.  Nor is it an efficient use of time.

     

    I look forward to your response. 

    google spreadsheet zapier modified
  • Profile Image
    JotForm Support

    Answered by Mike on November 08, 2016 at 08:17 PM

    Unfortunately, we cannot guarantee that modified spreadsheet will keep the integration. The integration might be sensitive to the spreadsheet modifications, for example if you rename some field label (highlighted in green) the corresponding column will stop updating.

    If you would like to have more control over the spreadsheet you might consider configuring the Google Spreadsheet integration via Zapier.

    JotForm > Zapier > Google Spreadsheet

    Zapier: Save new JotForm responses as Google Sheets rows

    How to Setup Your Google sheet to Work With Zapier

    If you need any further assistance, please let us know.