Troubleshooting Export to Sheets: No Rows Displaying Issue

Michael Robinson · 2024-11-14 16:55:40.461257+00

Hi, can't seem to get the export to sheets to work. It's not showing me any rows to match to.

Troubleshooting Export to Sheets: No Rows Displaying Issue | Clay

Michael Robinson
·
·
I should add, I've deleted both the column and API keys. After readding, it's still not showing me the columns to match. Grrrr
owen (Clay)
·
·
Hey Michael, thanks for reaching out! This is because the Google sheet you are trying to upload data to does not have any column headers. Try adding headers to the Google sheet correlated to which data you'd like to map from Clay into this sheet and check the menu again. There will be a spot where you can insert a column from Clay to correspond to a column header in Google Sheets. Let me know how this goes and if you have any other questions :)
Michael Robinson
·
·
I did import headersm. They must have deleted somehow. Super wierd...
Michael Robinson
·
·
I've double checked. All the headers were there. This is an issue with Clay not detecting or showing them
Michael Robinson
·
·
I tested another workbook and it worked fine. It's only this workbook for some reason
Michael Robinson
·
·
The spreadsheet is also not updating even when I force run all rows. have to go cell by cell. Suspect there's something going on on the backend.
Tomi Fiure (Clay)
·
·
Hello Michael! I tested running a row in your table and I get this error: https://downloads.intercomcdn.com/i/o/w28k1kwz/1253326976/286841831ebc052cc83a0dca6324/CleanShot+2024-11-15+at+09_55_16%402x.png?expires=1731684600&signature=917422c1b649532b6e713ce3358f8580159298ce500653f52395302110b83f9f&req=dSIiFcp8m4hYX%2FMW1HO4zWhjMBwoBkTR77jfnSmc8%2FXB9L%2BwyZ7HYC794l1%2B%0A1Hlb%0A This due to multiple columns in the Sheets headers being identical. I think you should double check that in the sheets but also, it could be useful to delete the sheets enrichment, make a new and re-authenticate your account. Let me know if the problem persists still.
Michael Robinson
·
·
which enrichments? All of them?
Tomi Fiure (Clay)
·
·
No, just the Google sheets enrichment you are using to send data from your table to your Google sheets.
Michael Robinson
·
·
I don't see which columns are duplicate here. And I've already deleted the sheets enrichment. didn't work
Michael Robinson
·
·
I've deleted the other tables, still doing the same thing. Won't let me change this
Michael Robinson
·
·
Please dig deeper this time. Unable also to change table or LI URL's.
Michael Robinson
·
·
This shows on the current table, and if I start a new one
Tomi Fiure (Clay)
·
·
Do you mind giving me access to the google sheets temporarily so I can debug better? It's hard to understand what is going on otherwise. My email is tomi.fiure@clay.com.
Michael Robinson
·
·
Sure

29 comments