tGoogleSheetOutput exceeds grid limits

[bglaplante]

I'm trying to add rows to an existing Google Sheet (by specifying start writing at row 4900).

The component errors with the following.  Am I really stuck at a max of 1000 rows in my Google sheet with this component?

WARN: Got error:400 Bad Request
{
  "code" : 400,
  "errors" : [ {
    "domain" : "global",
    "message" : "Range (Sheet1!A4919) exceeds grid limits. Max rows: 1000, max columns: 26",
    "reason" : "badRequest"
  } ],
  "message" : "Range (Sheet1!A4919) exceeds grid limits. Max rows: 1000, max columns: 26",
  "status" : "INVALID_ARGUMENT"
}
ERROR: Stop processing because of the error does not allow a retry.
Exception in component tGoogleSheetOutput_2 (CBC_ACH_Rejects_2_GSheet)
com.google.api.client.googleapis.json.GoogleJsonResponseException: 400 Bad Request
{
  "code" : 400,
  "errors" : [ {
    "domain" : "global",
    "message" : "Range (Sheet1!A4919) exceeds grid limits. Max rows: 1000, max columns: 26",
    "reason" : "badRequest"
  } ],
  "message" : "Range (Sheet1!A4919) exceeds grid limits. Max rows: 1000, max columns: 26",
  "status" : "INVALID_ARGUMENT"
}
	at com.google.api.client.googleapis.json.GoogleJsonResponseException.from(GoogleJsonResponseException.java:146)

[Anonymous]

Hello,

tGoogleSheetOutput is a custom component written by talend community user and shared on talend exchange portal. We don't have the source code of these components. It is the ownership of the person who built it.

Feel free to contact the author directly.

Best regards

Sabrina