There can be multiple reasons why submitted data isn't arriving in a Google Drive connection. Oftentimes, the data is arriving, but in a different sheet as in the screenshot below:
We deliver data to a new sheet when your form schema is changed, typically by editing the form in our designer.
In all other cases you will see a Delivery Error reported on your dashboard like so:
The reasons behind such a delivery error to a Google Doc are beyond the scope of this FAQ, but some common causes are:
- Spreadsheet has exceeded the cell-limit set by Google Docs.
- Spreadsheet has exceeded the number of columns (based on the number of fields defined in your form).
The delivery error may contain information that points to the causes above. You can attempt to resolve the issue by adding a second Google Doc connection in parallel to your existing one. It doesn't matter if the the spreadsheet name is a duplicate of the original.