Messages and limitations of the Google Sheets connector
Message code list of GOOGLESPREADSHEETS category
The following message codes correspond to errors that occur in Google Sheets Connector.
This message code is output when an undefined error occurs.
|
Cause |
Solution |
|---|---|
|
An undefined error occurred. |
Check the error message or the help of the operation in which the error has occurred. |
Corresponding error
-
None
This message code is output when connection to Google Sheets fails.
|
Cause |
Solution |
|---|---|
|
Client ID, Client secret, or Refresh token of the connection resource is incorrect. |
Check the connection resource settings. |
|
Access permission for Refresh token of the connection resource has been removed due to configuration changes on the service-provider side. |
Re-authenticate and update Refresh token of the connection resource. |
|
Client secret of the connection resource has been disabled due to configuration changes on the service-provider side. |
Check the settings of service provider's application authentication information. |
|
Service provider's application authentication information is deleted. |
Check the settings of service provider's application authentication information. |
Corresponding error
-
com.google.api.client.auth.oauth2.TokenResponseException
This message code is output when the folder path specified is invalid.
|
Cause |
Solution |
|---|---|
|
The path entered in Folder Path for the operation in which the error occurred is invalid. |
Check Folder Path for the operation in which the error occurred. |
Corresponding error
-
InvalidFolderPathException
This message code is output when the specified spreadsheet can't be found.
|
Cause |
Solution |
|---|---|
|
The spreadsheet specified in File Name for the Read Sheet operation can't be found. |
Make sure the file path specified in File Name for the Read Sheet operation meets the following criteria.
|
Corresponding error
-
SpreadsheetNotFoundException
This message code is output when the cell address specified is invalid.
|
Cause |
Solution |
|---|---|
|
The cell address entered in Cell Address for the Read Sheet operation is invalid. |
Check Cell Address for the Read Sheet operation and enter a valid cell address. |
|
The cell address entered in Cell Address for the Writing operation is invalid. |
Check Cell Address for the Writing operation and enter a valid cell address. |
Corresponding error
-
InvalidCellAddressException
This message code is output when the row number specified is invalid.
|
Cause |
Solution |
|---|---|
|
The row number specified in End Condition/Row Number for the Read Sheet operation is invalid. |
Check End Condition/Row Number for the Read Sheet operation and enter a valid cell address. |
Corresponding error
-
InvalidRowNumberException
This message code is output when the spreadsheet to be created already exists.
|
Cause |
Solution |
|---|---|
|
The spreadsheet specified in File Name for the Writing operation already exists. |
In the Writing operation, modify the file name specified in File Name, or select Overwrite of Setting Of Writing. |
Corresponding error
-
SpreadsheetAlreadyExistedException
This message code is output when the writing operation failed to add rows or columns to the worksheet.
|
Cause |
Solution |
|---|---|
|
The Writing operation failed to add rows or columns to the worksheet. The spreadsheet may have been updated by another operation while the current operation was in process. |
Make sure that there is no other operation that modifies the target spreadsheet for writing while the Writing operation is being performed. |
Corresponding error
-
WorksheetUpdateFailedException
This message code is output when the Writing operation failed to delete the target worksheet for writing.
|
Cause |
Solution |
|---|---|
|
The writing operation failed to delete the target worksheet for writing. The spreadsheet may have been updated by another operation while the current operation was in process. |
Make sure that there is no other operation that modifies the target spreadsheet for writing while the Writing operation is being performed. The worksheet created temporarily may remain in the spreadsheet. |
Corresponding error
-
WorksheetDeleteFailedException
This message code is output when an error occurred while the Writing operation is in process.
|
Cause |
Solution |
|---|---|
|
An error occurred while the Writing operation is in process. |
Check the error message and resolve the problem. |
Corresponding error
-
BatchFailedException
This message code is output when access to the spreadsheet was denied.
|
Cause |
Solution |
|---|---|
|
Authority to access the spreadsheet was not granted. |
Check the sharing settings of the spreadsheet. |
Corresponding error
-
AccessDeniedException
This message code is output when the number of concurrent invocations of Google API exceeds the limit.
|
Cause |
Solution |
|---|---|
|
The number of concurrent invocations of Google API exceeds the limit. |
Reduce the number of concurrent invocations. |
Corresponding error
-
RequestRateLimitExceededException
Exception messages of GOOGLESPREADSHEETS category
|
Exception name |
Cause |
Solution |
|---|---|---|
|
AccessDeniedException |
Access to a spreadsheet was denied. |
Check the sharing settings for the read target spreadsheet. |
|
AccessDeniedException |
Access to a spreadsheet was denied. |
Check the sharing settings for the write target spreadsheet. |
|
BatchFailedException |
An error occurred while writing data. |
Check the error message and resolve the problem. |
|
com.google.api.client.auth.oauth2.TokenResponseException 401 Unauthorized |
Client ID or Client secret is incorrect. |
Check Client ID or Client secret. |
|
com.google.api.client.auth.oauth2.TokenResponseException 400 Bad Request { "error" : "invalid_grant" } |
Refresh token is incorrect. |
Check Refresh token. |
|
com.google.api.client.auth.oauth2.TokenResponseException 400 Bad Request { "error" : "invalid_grant", "error_description" : "Token has been revoked." } |
Application access permission was removed due to a user operation on the service-provider side. |
Perform OAuth 2.0 authentication again, and set the newly issued token to Refresh token. |
|
InputDataNotFoundException |
Input data isn't specified. |
Specify Input data or draw data flow. |
|
InvalidCellAddressException The cell address specified is invalid. Cell address:[<Cell Address>] |
The cell address entered in Cell address is invalid. |
Check Cell address and enter a valid one. |
|
InvalidFolderPathException |
The folder path specified in Folder Path is invalid. |
Check Folder Path. |
|
InvalidPropertyConfigurationException <Property name> is not specified. |
<Property name> isn't specified. |
Specify <property name>. |
|
RequestRateLimitExceededException |
The number of concurrent invocations of Google API exceeds the limit. |
Reduce the number of concurrent invocations. |
|
ResourceNotFoundException Resource definition could not be found. Name: [] |
Connect To isn't specified. |
Specify Connect To. |
|
ResourceNotFoundException Resource definition could not be found. Name: [<connection resource name>] |
The resource definition selected in Connect To isn't found. |
Check the connection resource specified in Connect To. |
|
SpreadsheetAlreadyExistedException |
The spreadsheet specified in File Name already exists. |
Modify the file name specified in File Name, or select Overwrite of Setting Of Writing. |
|
SpreadsheetNotFoundException No specified spread sheet is found. File Name:[<File name>] |
The spreadsheet specified in the File Name can't be found. |
Make sure the file path specified in File Name meets the following criteria. - A spreadsheet which exists is specified. - The specified file is in the format of "spreadsheet" or "form" |
|
WorksheetDeleteFailedException Failed to delete the worksheet. Sheet name:[<sheet name>] temporary sheet name:[<temporary sheet name>] |
Failed to delete the target worksheet for writing. The spreadsheet may have been updated by another operation while the current operation was in process. |
Make sure that there is no other operation that modifies the target spreadsheet for writing while the operation is in process. The temporary sheet <temporary sheet name> may remain in the spreadsheet. |
|
WorksheetUpdateFailedException Failed to set the number of rows/columns for the target spreadsheet. Sheet name:[<sheet name>] column number:[<number of columns>] row number:[<number of rows>] |
Failed to add rows or columns to the target worksheet for writing. The spreadsheet may have been updated by another operation while the current operation was in process. |
Make sure that there is no other operation that modifies the target spreadsheet for writing while the operation is in process. |
Limitations of GOOGLESPREADSHEETS category
Notes
-
The behavior described in the help pages is subject to change depending on specification changes in the destination.
Specification limits
-
Empty characters are output as null.
-
All data is output as string type.
-
For the format for values such as numbers and dates/times, the format that is displayed in the "Formula" field when you select the target cell on Google Sheets is used.
-
When data is obtained in currency format, the yen sign is output as unicode "U+00A5".
-
-
For End Condition/Column Name
-
When Specify Condition To Stop Reading is selected, End Condition/Column Name is set, and then Columns/Column Name is directly changed, as the column name differs, the end condition won't be used as condition. If Columns/Column Name has been changed directly, click Finish to close the properties screen. Then open the properties screen again and configure Columns/Column Name.
-
When multiple columns with the same name are set in Columns/Column Name and that name is set in End Condition/Column Name, the column at the topmost position in columns of Columns/Column Name with the same name will be used.
-
-
Functions, formulas, comments, gadgets, charts, images, drawings, and scripts aren't supported to read.
-
The results of calculation are read from cells to which functions or formulas are set.
-
-
About duplicate spreadsheet names or folder names
-
If two or more files/folders whose path is the same as the path of the spreadsheet specified in File Name exist, it can't be guaranteed which spreadsheet is read.
-
If two or more folders whose path is the same as the path specified in Folder Path exist, it can't be guaranteed which folder is used.
-
-
Only the files/folders located under My Drive can be accessed.
Notes
-
HTTPS is used in the communication between Google Drive/Google Sheets and this connector.
-
New format of "spreadsheet" and "form" have been introduced by service update of Google Drive in January 2015 at present. The existing file on Google Drive will be transfered to the new format within 2015.
-
This connector supports both new and old formats of "spreadsheet" and the old format of "form".
= Hint =If new format of "form" is used, response data can be processed with this connector by specifying a spreadsheet as the response destination.
-
Specification limits
-
About duplicate spreadsheet names or folder names
-
If two or more files/folders whose path is the same as the path of the spreadsheet specified in File Name exist, it can't be guaranteed which spreadsheet is read.
-
If two or more folders whose path is the same as the path specified in Folder Path exist, it can't be guaranteed which folder is used.
-
-
Only the files/folders located under My Drive can be accessed.
Notes
-
HTTPS is used in the communication between Google Drive/Google Sheets and this connector.
-
New format of "spreadsheet" and "form" have been introduced by service update of Google Drive in January 2015 at present. The existing file on Google Drive will be transfered to the new format within 2015.
-
This connector supports both new and old formats of "spreadsheet" and the old format of "form".
= Hint =If new format of "form" is used, response data can be processed with this connector by specifying a spreadsheet as the response destination.
-
Specification limits
-
Null and empty strings
-
If an input data value is null, the value won't be written.
-
If an input data value is an empty character, the value of the cell will be overwritten with the empty character.
-
-
The data is converted to string-type data, and then is written to the spreadsheet the same way as when it's entered from a web browser.
-
When you write values such as numbers and dates/times, convert the values into strings of the same format as the format that is displayed in the "Formula" field when you select the target cell on Google Sheets.
-
There are cases where strings in formats other than the format displayed in the "Formula" field may be written as numbers, dates/times, or other formats of data.
-
-
When data in currency format is written, unicode "U+00A5" must be used for the yen sign.
-
-
It's not possible to insert a row and write to it.
-
When the number of rows or columns on the spreadsheet is smaller than the range to be written, the appropriate number of rows or columns is added when writing.
-
For format specifications such as font and background color, those of the cell in the write destination are used. Formats can't be specified.
-
Functions, formulas, comments, gadgets, charts, images, drawings, and scripts aren't supported to write.
-
About duplicate spreadsheet names or folder names
-
If two or more files/folders whose path is the same as the path of the spreadsheet specified in File Name exist, it can't be guaranteed which spreadsheet is written to.
-
If two or more folders whose path is the same as the path specified in Folder Path exist, it can't be guaranteed which folder is used.
-
-
Only the files/folders located under My Drive can be accessed.
Notes
-
HTTPS is used in the communication between Google Drive/Google Sheets and this connector.
-
New format of "spreadsheet" and "form" have been introduced by service update of Google Drive in January 2015 at present. The existing file on Google Drive will be transfered to the new format within 2015.
-
This connector supports both new and old formats of "spreadsheet" and the old format of "form".
-
You can't create a new file with the old format of "form".
= Hint =If new format of "form" is used, response data can be processed with this connector by specifying a spreadsheet as the response destination.
-
-
The following errors may occur and the process may fail if the requests exceed the limit of the API, or if an action to update or delete the spreadsheet is performed on Google Drive/Google Sheets while data is being written to the spreadsheet. Don't perform such operations.
-
WorksheetUpdateFailedException: Failed to set the number of rows/columns for the target spreadsheet. Sheet name:[<sheet name>] column number:[<number of columns>] row number:[<number of rows>]
-
WorksheetDeleteFailedException: Failed to delete the worksheet. Sheet name:[<sheet name>] temporary sheet name:[<temporary sheet name>]
-
BatchFailedException: Batch Interrupted (some operations might have succeeded) : a response has already been sent for batch operation update id='R1C1'
-