New Submissions not Showing on Google Sheets

  • dakin2
    Asked on January 3, 2017 at 2:23 PM

    I have a form that is linked to a google spreadsheet. The new submissions are no longer populating on the linked Google Spreadsheet. 

    Here is a screenshot of the Submissions showing in JotForm (the 3 highlighted submissions should be showing on the Google Sheet): http://www.screencast.com/t/aBHa2c4Xh

    Here is a screenshot of the Google Sheet that should be showing the submissions, but is not: http://www.screencast.com/t/Apm4ZrDlMz

     

    I don't want to unlink and relink the spreadsheet if I don't have to because in the past when I have done this it created a new google spreadsheet and I had to redo all the other tabs from my previous google spreadsheet. As a side note, it would be nice if there was a way to select which google sheet you wanted to link a form submissions to.

  • David JotForm Support
    Replied on January 3, 2017 at 3:47 PM

    I tried reconnecting your form with your sheet and it looks like the permissions to update the sheet were removed.  The integration is found:

    New Submissions not Showing on Google Sheets Image 1 Screenshot 30

    But when the data is pushed to the sheet, the auth token is invalid:

    New Submissions not Showing on Google Sheets Image 2 Screenshot 41

    Unfortunately, it looks like you may have to redo the integration.