Hello,
We're experiencing issues with google sheets v4 writer adding large amounts of blank rows to the bottom of google sheets. It eventually causes the writers to fail due to size.
Thank you!
Robyn
Best answer by rharte
View original
+2
- Contributor
- 606 replies
-
25 May 2021
Hi @rharte ,
Sorry to hear you are running into issues with Sheet V4. Would you be able to share more about the workspace and the writer feature type parameters so we can try to reproduce this on our end? How many features are being sent to the writer in comparison to how many (including blanks) are written? Are you seeing any errors or warnings in the translation log?
Any additional info would be great - or if you are able to send in your workspace and sample data, let me know and we can convert this to a support case.
I actually figured out the answer to my question after posting! In the Google Sheet V4 Writer, under sheet options, I had to change the setting for Insert Method from Insert Rows to Overwrite. That solved the empty row problem.
Thank you for following up.
Robyn
+2
- Contributor
- 606 replies
-
25 May 2021
I actually figured out the answer to my question after posting! In the Google Sheet V4 Writer, under sheet options, I had to change the setting for Insert Method from Insert Rows to Overwrite. That solved the empty row problem.
Thank you for following up.
Robyn
Great, thanks for letting us know!
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.