Invalid requests[0].deleteDimension: Sorry, it is not possible to delete all non-frozen rows.

[gurusewack]

Hi @jlolling
I am trying to insert the data into the existing Google sheet and am getting the below error. Please help me to resolve this error.

{
"code": 400,
"errors": [
{
"domain": "global",
"message": "Invalid requests[0].deleteDimension: Sorry, it is not possible to delete all non-frozen rows.",
"reason": "badRequest"
}
],
"message": "Invalid requests[0].deleteDimension: Sorry, it is not possible to delete all non-frozen rows.",
"status": "INVALID_ARGUMENT"
}

Thanks
Guru

[jlolling]

Hi, Can you show me your configuration of the tGoogleSheet component please and an screenshot of your job? Best regards Jan

…

On 8. Jan 2024, at 19:24, gurusewack ***@***.***> wrote: Hi @jlolling <https://github.com/jlolling> I am trying to insert the data into the existing Google sheet and am getting the below error. Please help me to resolve this error. { "code": 400, "errors": [ { "domain": "global", "message": "Invalid requests[0].deleteDimension: Sorry, it is not possible to delete all non-frozen rows.", "reason": "badRequest" } ], "message": "Invalid requests[0].deleteDimension: Sorry, it is not possible to delete all non-frozen rows.", "status": "INVALID_ARGUMENT" } Thanks Guru — Reply to this email directly, view it on GitHub <#19>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AB5KS7LT7GSFKSPRAC7AOIDYNQ2ULAVCNFSM6AAAAABBR4FMU6VHI2DSMVQWIX3LMV43ASLTON2WKOZSGA3TAOJZHA4TAMY>. You are receiving this because you were mentioned.

[gurusewack]

Hi @jlolling
Herewith, I have attached the configuration screenshot. Additionally, I am facing another issue: while data was transferred to the Google Sheet component, the header data was not inserted.

Thanks
Guru