On this page:
Table of Contents
...
If the submission doesn't reach the Google Connector, all tenant administrators or flow admins (if configured) will receive a Doc Post Failure notification email reporting information about the error. Note the email subject contains the server name where the form/flow is hosted.
Here are some examples:
There are a number of reasons why your data or documents may not post successfully to Google Sheets/Google Drive. Here are some common reasons and troubleshooting actions you can take.
| 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. |
Why won't the Doc Action wizards connect forms/flows to my Google Account ?
Google users with 100+ pre-existing documents in their Google Drive may have issues using the frevvo Doc Action Wizards to connect forms/flow to their Google account. The login screen in the wizard may hang or throw an unexpected error. If you experience this issue please:
- Update to the supported version of frevvo Google Connector v2.3
- Note: If you are using Live Forms frevvo Online, cloud hosted software the frevvo Google Connector is already updated to v2.3
- Use the form/flow Manually Set Doc URIs wizard and do NOT use the frevvo Google Sheet wizard
...
How do I check the status of the Google connector?
Paste this url in your browser: http://<DOMAIN_ NAME>/google/health to check the Google Connector status. Provide your domain name and the port number if you are running locally. You should see a {"status":"UP"} message.
How do checkbox and repeat controls pass to Google Sheet?
If you use the Doc Action Wizard to Send Data to Google Sheet, your Checkbox (multi-select) controls, repeat controls, and tables will pass to the spreadsheet as a space separated list. However, if you are passing those values using a business rule to update the Google Sheet, you may see it populate the sheet in error, such as "[Ljava.lang.String;@43156d18". The best way to correct this is to add some standard javascript to your rule to join the array into a string, such as this:
| Code Block |
|---|
// Join the array value of MultiCheck into a space-separated string.
var mcj = MultiCheck.value;
var j = mcj.join(' ');
// Pass the variable 'j' to the Google Sheet.
var updateparams = '&updates='+encodeURIComponent('multicheck='+j+); |
Why doesn't my T/F control populate on the Google Sheet?
When using a T/F boolean control, by default the connector will pass the value "true" when checked and will pass no value (blank) when unchecked. To ensure that the value "false" is passed to your Google Sheet when the control is unchecked, simply check the "Required (false)" property on the properties panel for that control.
"Unknown Error has Occurred" message when logging on to the Save to Google Spreadsheet wizard
...
This may be because you are using an invalid or revoked access token in your business rule. Make sure you are using a valid access token and retest.
This error can also occur if you are writing to a Google Sheet using a business rule, 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. This will be fixed in a future release. A workaround is to add code to your rule to strip the commas:
| Code Block |
|---|
//Remove Commas
var t = FullName.value;
var tcomma = t.replace(/,/g," "); |
Then, pass the variable "tcomma" in the updataparams rule instead of the original control value.
Internal Server Error
You may encounter this error when performing read/update/write operations to a Google sheet from a form/flow. 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
...
Please report any issues or feedback to us here. See the list below for some known issues with the Google Connector.
...
| Ticket | Description | Work-around |
|---|---|---|
| #16848 | Google Spreadsheet - Boolean control : Fetching values true/false should not be case sensitive | Google sheets automatically converts true, True, false, and False values to upper case. Click here for more information. Let's say you have a checked Boolean control value stored in your spreadsheet as TRUE. This might cause an issue when reading from Google spreadsheet, and setting the value of the Boolean checkbox. Implement one of the following as a workaround:
|
| #17952 | Some number values update to date values in Google Sheets | In some cases, Google Sheets may change valid number values to dates values. The best way to handle this situation is to write scripts to clean up the bad data in your Google Sheets. |