On this page:
Table of Contents
...
Possible Reason for Doc Post Failure | Try This... |
---|---|
Connection Timeout |
|
Google Sheets Workbook or Sheet deleted/renamed First Column header deleted/renamed |
|
Google Sheet has a column or sheet set as a Protected Range |
|
Google Sheets has reached the limit of 5000000 cells |
|
Google Sheets or Google Drive API is not enabled |
|
Google Drive folder deleted/renamed |
|
Google Drive folder name set by template that resolves to null |
|
Google Drive folder name set by template that contains an apostrophe |
|
OAuth Token expired | Follow these instructions to regenerate your OAuth token. Then, update your Doc Actions and rules to reflect the new token. |
...
This error can also occur if you are writing to a Google Sheet using a business rule using the deprecated '&updates' parameter, and you have a text or textarea control that gets a value with a comma at runtime. For example, if you are passing a control in the var updateparams rule such as "FullName" and the runtime value entered is "Smith, John" the comma can interfere with the comma-separated update parameters being passed to the Google Sheet. To correct this, please update your business rule to use the '&updatesjson' parameter as described in this documentation.
...
You may encounter this error when performing read/update/write operations to a Google sheet from a form/workflow. The Google API can never be a replacement for a database in terms of reliability. There are no SLAs associated with free google accounts. makes multiple http calls to the Google API with no guaranteed SLA. As the load increases, the chances that the Google service might fail increases. If you encounter the 'internal server error', the only thing to do is to try again later.
Error - Cannot find dependency
If you the error "** Error: cannot find dependency named [results] in rule" in the debug console, check to see if you are attempting to read a Google Sheet column whose name is a reserved word, such as "status". The workaround is to encase the word in square brackets.
Code Block |
---|
Status[i].value = x.results[i]['status']; |
Google Connector Known Issues
...