Hi, can't seem to get the export to sheets to work. It's not showing me any rows to match to. https://app.clay.com/workspaces/360985/workbooks/wb_ZMYMH7pxAqQZ/tables/t_DtPEUNNfqJAN/views/gv_Cp5WovTfytAM
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
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 :)
I did import headersm. They must have deleted somehow. Super wierd...
I've double checked. All the headers were there. This is an issue with Clay not detecting or showing them
I tested another workbook and it worked fine. It's only this workbook for some reason
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.
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.
which enrichments? All of them?
No, just the Google sheets enrichment you are using to send data from your table to your Google sheets.
I don't see which columns are duplicate here. And I've already deleted the sheets enrichment. didn't work
I've deleted the other tables, still doing the same thing. Won't let me change this
Please dig deeper this time. Unable also to change table or LI URL's.
This shows on the current table, and if I start a new one
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.
Sure
Hey, so ALL of my current workflow is broken. 3 different tables have critical issues. I have a bunch of credits I still need to use, but think it makes sense to downgrade my account for now. VERY frustrated with the experience currently. Would I be able to extend the clay credits for a month as I was planning to use them, but as the export feature isn't working well, I don't see the point in paying $200 more
This particular one the apify import broke, now the sheets broke
Don't get why
Access granted
Got it. I haven't started debugging yet but I noticed that the sheets has duplicate 'LinkedIn Profile URL' columns: https://downloads.intercomcdn.com/i/o/w28k1kwz/1253580631/81910f95ec9d154504de251b47e1/CleanShot+2024-11-15+at+13_16_14.gif?expires=1731696300&signature=996b0d0632cf9d4a2af8c4058020886bf694e9200652ca0258e1c7b7e560fc62&req=dSIiFcx2nYdcWPMW1HO4zbemokAVw%2BVhQtn%2B65UBlggnr4gROq2I1vAc5cix%0AuQWD%0A Which is the error the Sheets enrichment is giving: https://downloads.intercomcdn.com/i/o/w28k1kwz/1253580994/b159db3379ae10adb352b6bca77a/CleanShot+2024-11-15+at+13_16_43%402x.png?expires=1731696300&signature=50ced56718bcc659533bd76214ffe47edf2dcf1bac2613c70a86bdabc55946c9&req=dSIiFcx2nYhWXfMW1HO4zWVwnOdURsmbk5DGYn4TG4zrIsblJ1qwGjlGDva2%0ANU%2Bv%0A I deleted one of them and that error is longer there: https://downloads.intercomcdn.com/i/o/w28k1kwz/1253583092/a649d6881a9a427a2f170cbc94ba/CleanShot+2024-11-15+at+13_18_36%402x.png?expires=1731696300&signature=dfd5c101c81d9d8651e12c938e0e53a1f5cb23ccd94c020a18f9d4caeb809868&req=dSIiFcx2noFWW%2FMW1HO4zUZucluj%2B6DiJNj4rVB789B2EKFrWC4K3%2B8ESedi%0A2qcS%0A
That's what I was referring to earlier. The data still doesn't appear in the sheets, but I suspect it has to do with the column matching. Still looking into this.
looks like its working now
Now, you are able to match column headers in the sheets to columns in your Clay table through the enrichment. Once this is done, data should be sent as matched: https://downloads.intercomcdn.com/i/o/w28k1kwz/1253585337/514c1c041d101cbdc919d81d2e80/CleanShot+2024-11-15+at+13_20_02.gif?expires=1731696300&signature=c0d6cb4612ac69437c20879ee00bb9610a245f61252bc0d0abb0b03fee477342&req=dSIiFcx2mIJcXvMW1HO4zWQRqFQhMi%2BO2rxLSCmFtUZvUGy8220LxtYOYeMh%0A7iUm%0A https://downloads.intercomcdn.com/i/o/w28k1kwz/1253586247/cad468f1b4783d0e065d9032f7fb/CleanShot+2024-11-15+at+13_21_09.gif?expires=1731696300&signature=4727c7a2bb5f94f98a755a02cedab3c53296dbb0985c56bd80b0eee02b92abb4&req=dSIiFcx2m4NbXvMW1HO4zdtqlAK817%2ByjO0DZ6TxMweEy1HrwZWi6LaKSmnl%0APENv%0A
Does this fix the issue you were having? Still, happy to extend the deadline for the credit usage if you decide to downgrade.
I don't understand but it's doing it again!
Please take a look.
What error are you seeing? I just re-ran an enrichment and got expected results again: https://downloads.intercomcdn.com/i/o/w28k1kwz/1253630481/954a122cac45d15fa2252e26a1d6/CleanShot+2024-11-15+at+14_04_29.gif?expires=1731699900&signature=d6ba448551e06ab43bdca6c32b187aa10d557d30fcddee13759232dcd5c6fd2c&req=dSIiFc99nYVXWPMW1HO4zQE3FWUwAjwkCID7EoVJjfM9hCEKSJEBamFe0MXX%0AguRvZxoYVXoFU3L5wHU%3D%0A
Seems to be working now
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Hi Michael R.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: