Issues with Google Sheets Enrichment Overwriting Header Row | Clay

Issues with Google Sheets Enrichment Overwriting Header Row

Google sheets enrichment to write clay data from clay to a sheet is not working, I am trying to add a new row and it keeps overwriting my header row (the 1st row) and this causes the future writes to have an error since the header columns are not overwritten. This keeps happening to me inconsistently, sometimes the writes work and add a new row at the bottom of the sheet, sometimes they write to the first row and cause errors. https://app.clay.com/workspaces/333994/workbooks/wb_0swxic6jgsgz5PrKxnh/tables/t_0syfcxoywTmSoY2ijSS/views/gv_0swxichcsy75sJdZfuW Working out of this workbook with sensitive customer data so I don't want to further share any screenshots of cutsomer data from the sheets themselves. Happy to work privately with customer service.

16 comments

Clay
APP
·
·
When using the Google Sheets "Add Row" enrichment, the integration should append data to the end of your sheet, not overwrite the header row. This inconsistent behavior might be happening because: 1. The integration is correctly configured to add rows, but might be encountering API rate limits (Google Sheets has a limit of 300 read requests per minute). To fix this: ** Double-check your enrichment setup: ensure you've selected the "Add Row" action (not "Lookup, Add or Update") ** Verify you've correctly pasted your Google Spreadsheet URL * Make sure you've properly mapped your Clay columns to the Google Sheet columns If problems persist, please share more details about your specific setup so we can troubleshoot further.
Sources: Add Row with Google Sheets Google Sheets integration overview | Documentation | Clay University Google Sheets [Clay 101] - Clay University
Michael J.
·
·
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.
Michael J.
·
·
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 🙂
Michael J.
·
·
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.
Clay
APP
·
·
Hello! Thanks for reaching out and being patient while I got back to you. I totally respect you wanting to not send screenshots. Sharing the table link URL should be enough to troubleshoot the issue. Also since it is a google sheets issue, I do not have access to the sheet. Would it be possible for you to send the sheet url?
Clay
APP
·
·
Even sending a loom video of what is happening should be enough to get me started on this. I assure you this data is confidential and will not be shared elsewhere.
Clay
APP
·
·
Hey! Thanks for waiting patiently while I figured this out. Created a loom for you outlining my thought process and recommended solution. Do let me know if I have misunderstood or if there is anything else that I can help you with! :)
Michael J.
·
·
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
Clay
APP
·
·
Hello! I have deleted the message and the loom as well. If you can record a video or describe the method you are following to send that data to sheets I can take a look at it.
Michael J.
·
·
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
APP
·
·
Hello! Thanks for reaching out. I have escalated this to the engineering team but am curious to know why you would hide the columns to begin with. I would suggest waiting till the data is completely sent to make any changes. Hiding the column might break the flow and we do not recommend doing that.
Clay
APP
·
·
If you do not hide the column are you able to send the data successfully?
Michael J.
·
·
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.
Clay
APP
·
·
Hey! I checked with the engineering team and they reproduced it on their end. Seems to be working for them. Eitherway, is there anything else that is a major blocker for you right now? When it comes to hiding column, I would suggest trying it out with a different sheet cause it could be that particular sheet causing problems!
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.
Clay
APP
·
·
Makes sense. If there is nothing else, I am going to go ahead and close out this ticket. Do reach out again if you need any further assistance :)