...

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 comma 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 a hidden text control to your form and then use a business rule to get the value(s) of the selection or repeat control, like this:

var list = '';
for (var a = 0; a < MultiCheck.value.length; a++)
{ 
    list = list + MultiCheck[a].value + ' ';
}
MCList.value = list;

Then, pass the text control (MCList in this example) to the spreadsheet in your Google Sheet Update rule.

"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.

Invalid String Literal

If you see the error "invalid string literal" when using a business rule to read or update a google sheet, make sure that you have commented out the slashes in your oAuth Code, as in OAuth21\/\/0dqqBnY...

Internal Server Error

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

...

Please report any issues or feedback to us here. See the list below for some known issues with the Google Connector.

...