Michael J.

Now that I know hiding columns causes issues I will just avoid doing that. The function is working fine for me as long as no columns are hidden.

Yes that is exactly what I said in the video and in my messages, if you hide a column it breaks the writes, and if you don't hide any columns then the data sends fine. In my use case, I was hiding columns to have other columns built off of the data from a source column via formulas. Building this end table for a sales team, so another use case for hiding columns was just to modify the views for them to remove data they don't need. "Hiding the column might break the flow and we do not recommend doing that" I never saw this anywhere online. Having this in an faq or some form of documentation online would be helpful.

Here's a loom demonstrating the fail case and bug that I have found. Here is the sheet that was used in this demo. If this is a bug that I caught, is there any bounties? 😉 Just kidding, thanks for follow ups. Would love to hear back from dev team if this is intended or not, could not find any documentation on this anywhere online.

Clay please remove that loom, it's exposing the confidential information that I was trying not to share with everyone. I will create a loom to replicate the issue and follow up now. I found out the reason why it is overwriting header rows and it definitely feels like a bug

So more on this, looks like the issue is easily replicated if you have an ongoing write to a sheet and then hide a column on the sheet. This causes the next row write to be added to the header. Still would like to push this as a bug, that doesn't seem like an intending functionality.

https://community.clay.com/x/support/f16ktiajcrmi/fixing-clay-and-google-sheets-integration-issues-d Kind of a similar thread / issue. Daniel K. Not sure if you're still on the sheets team, any help would be greatly appreciated 🙂

I know the enrichment is set up correctly because it has worked correctly, it is just not stable and it is not consistently appending rows, it is often overwriting the header row and causing errors.

Bo (. so the only way to do this instantly is to use something like zapier then, right?

Yea exactly, was trying to access a contact property from the import object from hubspot array inside of my clay table from zapier. The zap for updating a record in a table does not allow you to access formulas and and I think it interpreted the nested value in the import object array as a formula. Once I added a plaintext column I was able to edit that field. Owen C. if there's an easier way to have my objects in the clay table automatically sync whenever changes are made to the source objects in hubspot that would be great. I played with using a lookup object to get these updated contact properties as well, but I don't think it automatically looks up the contacts when changes are made in hubspot.