The list of message code which falls into GOOGLESPREADSHEETS category

Message code corresponds to the errors which may occur during Google Spreadsheet Adapter operations.


GOOGLESPREADSHEETS0000E

Message code corresponds to undefined error occurred.

Causes Solution
Undefined error has occurred See the accompanying error messages which should indicate the cause of the error.

Corresponding error


GOOGLESPREADSHEETS0001E

Message code depicts the error which occurred when connection to Google Spreadsheet fails.

Causes Solution
Failure exists in [Client identifier], [Client secret], or [Refresh token] of global resource. Check global resource setting.
Access right of [Refresh token] in global resource is undone by configuration changes of service provider side. Re-authenticate and update [Refresh token] of global resource.
[Client secret] of global resource is invalidated by configuration changes of service provider side. Check the setting of service provider's application authentication information.
Service provider's application authentication information is deleted. Check the setting of service provider's application authentication information.

Corresponding error


GOOGLESPREADSHEETS0003E

Message code indicates that the folder path specified is invalid.

Causes Solution
The value specified in the [Folder Path] is invalid. The value specified in the [Folder Path] is invalid.

Corresponding error


GOOGLESPREADSHEETS0004E

Message code indicates that the specified spreadsheet cannot be found.

Causes Solution
The spreadsheet specified in the [File Name] field defined for Read Sheet Operation does not exists. Make sure the file path specified in the [File Name] meets the following criteria.
  • The spreadsheet the file path points to exist.
  • The specified file path points to neither 'Spreadsheet' nor 'Form'

Corresponding error


GOOGLESPREADSHEETS0005E

Message code indicates that the cell address specified is invalid.

Causes Solution
The address specified in the [Starts From Specified Cell Address] field defined for Read Sheet Operation is invalid. Make sure the cell address specified in the [Starts From Specified Cell Address] is valid.
The cell address specified in the [Starts From Specified Cell Address] field defined for Write Operation is invalid. Make sure the cell address specified in the [Starts From Specified Cell Address] is correct.

Corresponding error


GOOGLESPREADSHEETS0006E

Message code indicates that the row number specified is invalid.

Causes Solution
The row number specified in the [End Condition / Row Number] field defined for Read from sheet operation is invalid. Make sure the cell address specified in the [End Condition / Row Number]field defined for Read from sheet operation is valid.

Corresponding error


GOOGLESPREADSHEETS0007E

Message code indicates that the spreadsheet to be created already exists.

Causes Solution
The spreadsheet specified in the [File Name] field defined for Write Operation already exists. Either modify the file name specified in the [File Name], or check the [Overwrite] within the [Setting Of Writing].

Corresponding error


GOOGLESPREADSHEETS0008E

Message code indicates that the writing operation failed to add either rows or columns to the worksheet.

Causes Solution
The writing operation failed to add either rows or columns to the worksheet. Suggests that the spreadsheet has been updated from different operation while the current operation is acting on it. Make sure there is no other operation modifying the spreadsheet while write operation is being performed on the same spreadsheet.

Corresponding error


GOOGLESPREADSHEETS0009E

Message code indicates that the writing operation failed to delete the worksheet specified.

Causes Solution
The writing operation failed to delete the worksheet specified. Suggests that the spreadsheet has been updated from different operation while the current operation is acting on it. Make sure there is no other operation modifying the spreadsheet while write operation is being performed on the same spreadsheet. Worksheet created temporarily may remain in the spreadsheet.

Corresponding error


GOOGLESPREADSHEETS0010E

Message code indicates that an error occurred while writing operation is in process.

Causes Solution
Error occurred while write operation is in process. Confirm the error message and address the issue as appropriate.

Corresponding error


GOOGLESPREADSHEETS0011E

Message code indicates that the operation has no authority to update the spreadsheet specified.

Causes Solution
Failed updating the spreadsheet specified due to insufficient authority. Make sure that sufficient authority is granted for the write operation in the sharing settings

Corresponding error