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
Google Sheet v4 writier writing blank rows to all google sheets
Best answer by rharte
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
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+2- Contributor
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
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!