Google Spreadsheet: Integrating not updating modified sheet

  • Profile Image
    shand
    Asked 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. 

  • Profile Image
    Mike
    Answered 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.