• Check if the submission documents/data are actually present or not in Google Drive/Sheet. Sometimes, the submission goes through successfully, but frevvo does not hear back from Google in time and after a certain timeout period throws this error.
• Resubmit (see this documentation on how to resubmit forms/workflows).

Google Sheets

Workbook or Sheet deleted/renamed

First Column header deleted/renamed 

• Check your Google Sheet to see if the workbook, sheet, or first column header was altered. This can also happen if the sheet is sorted without excluding column headers, so that the headers end up on some other row.
• If needed, update the Doc Actions to reflect the new name.
• Resubmit failed submissions.

• Check the Google Sheet for protected ranges (see this Google support article.)
• Remove the restrictions.

• Reduce the size of your spreadsheet. A few methods are described in this blog article.

• On Premise Customers - Ensure you have followed these installation steps for the correct version of the Google Connector for your frevvo version.
• Enable the API(s) (see this Google support article).

• Check your Google Drive to see if the folder was altered.
• If needed, update the Doc Actions to reflect the new folder name.
• Resubmit failed submissions.

• Check the submission to see if the control used to set the Google Drive folder name happens to be blank or invalid.
• If possible, edit the submission to enter a value in that control, then resubmit.
• Make that control required or troubleshoot the business rules that set it to ensure it is always filled with a valid value.

OAuth Token expired

Follow these instructions to regenerate your OAuth token. Then, update your Doc Actions and rules to reflect the new token.