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.

After I manually did update now, it added 3 people, but no one from the 50 people preview. Something seems off about this

Thank you very much Smit V. that's exactly what I was hoping to accomplish. This seems to be a perfect use case for auto dedupe, really appreciate your help!

Sure, just looping back to the initial bug and reason for this post. My main table is synced to a hubspot list, however the amount of rows in the clay table does not equal the amount of contacts in my list. Even when I manually sync the source, it says that 2400+ contacts are found but it doesn't add the missing contacts to my table. If I duplicate the table and reconnect the source, it will re-run all of the enrichment columns causing the table to consume around 30000 credits of data I already have. If I duplicate the table and import the existing rows I have enriched, when I reconnect the source, it just duplicates the records. I simply want my main table in Clay to be fully synced up with my hubspot list.