Troubleshooting Integration Errors: Google

 

About

 This article contains the most common error messages that you can encounter with integrations to Google Drive or Google Sheets.   If your error message is not in this article, please contact support@prontoforms.com for assistance.

 

Error Messages

Error Message

Solution

Authorization was revoked. 

In Google, the user who was used to set up the connection may have changed their password, they may have manually revoked the authorization from the Security tab of their Google account, or Google may have expired the authentication token for another reason. 

To fix:

In ProntoForms, clear and reset your connection.  

 

Invalid Authorization: Unauthorized

The Google user (the one used to create the connection) does not have permissions to perform the requested action. 

 

To fix: 

1 In ProntoForms, clear and reset your connection.  If that doesn't work...
2. Ensure that the item you are trying to access is in your Google Drive account, and is not just an item shared with you.  ProntoForms only has access to write to files that belong to your Google Drive account.  Read here for more details. 

This action would increase the number of cells in the workbook above the limit of 5000000 cells.

Google places a limit on how many cells can be in a single Google Sheet.  ProntoForms is not allowed to send data that would exceed this limit. 

 

To fix:

1.  Create a new sheet and redirect the destination to point towards the new sheet. 
2. Alternatively, if you don't need some of the older data, the older data in the sheet could be deleted, and then re-execute the failed form submissions.

 

 

 

  [ top ]

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments