Troubleshooting Export to Sheets: No Rows Displaying Issue

Michael R. · 2024-11-14T16:55:34.924Z

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 R.
·
·
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 C.
·
·
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 R.
·
·
I did import headersm. They must have deleted somehow. Super wierd...
Michael R.
·
·
I've double checked. All the headers were there. This is an issue with Clay not detecting or showing them
Michael R.
·
·
I tested another workbook and it worked fine. It's only this workbook for some reason
Michael R.
·
·
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 F.
·
·
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 R.
·
·
which enrichments? All of them?
Tomi F.
·
·
No, just the Google sheets enrichment you are using to send data from your table to your Google sheets.
Michael R.
·
·
I don't see which columns are duplicate here. And I've already deleted the sheets enrichment. didn't work
Michael R.
·
·
I've deleted the other tables, still doing the same thing. Won't let me change this
Michael R.
·
·
Please dig deeper this time. Unable also to change table or LI URL's.
Michael R.
·
·
This shows on the current table, and if I start a new one
Tomi F.
·
·
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 R.
·
·
Sure

29 comments