If you are experiencing Google Spreadsheet Connection delivery errors that look like:
"GData::Client::AuthorizationError: request error 401" or "GData::Client::AuthorizationError: request error 409"
This means that your Google Spreadsheet submissions are getting stuck.
Below are steps to help you fix the problem:
Firstly, you will need to upgrade to Destinations. Create a new Destination with a Spreadsheet Format, and select Google Drive as the Destination. Click "Add new Destination".
Next, you will need to redirect the failing submissions to your new Google Spreadsheet Destination. To do this, go to your Delivery Problems page (the link can be found on your Dashboard when you have submission errors) and click the "redirect" button that appears beneath each submission error.
Once you click this, you will see a box appear that lists the available alternative Destinations you can choose from.
You can also choose to remove the error from your Delivery Problems page once it has been directed.
After you've redirected the errors to your new Google Spreadsheet Destination, go to your "Forms" page and click on the form. Then click "Destinations".
Once the "Destinations" page has loaded, click the "X" button on the far right of your Google Spreadsheet Connection. You will need to delete the Google Spreadsheet Destination in order to prevent further submission errors.
Once this has been done, all future submissions will go to the new Google Spreadsheet Destination.
Note: If you have any questions regarding this or would like further assistance, please contact our support team.