Hi all, I want to export a list of contacts I've found using Clearbit to another table. I can click on each cell individually and it gives me the option to "write each item to new role in other table", but is there a way to automatically do this so it autoupdates for new data that's added to the table?
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Hi Michael, thanks for reaching out. Taking a look at this now.
The write to table column will run automatically as new leads are pulled into your table - here's how you can set the write to other table column up in your workspace: 1. Make sure your Clay API key is linked correctly. 2. Find and set up the write to table enrichment column by clicking on Add Column > Add Enrichment > Search and select "write to table" https://downloads.intercomcdn.com/i/o/1198904361/3f67448e206777df45b95b0c/CleanShot-2B2024-09-04-2Bat-2B22_37_07.gif?expires=1728572400&signature=d9f7bbe3878e04f14bbf4103b7fee1446b75cb191a43e5d8731c44d742029004&req=dSEuHsB%2BmYJZWPMW1HO4zUOGxdRBczjY3XP6pls40EUIXA%3D%3D%0A 3. You can now choose to parse your arrays into an existing table or create a new blank table for them, by clicking on "new table": https://downloads.intercomcdn.com/i/o/1198904362/2d0802e8f2b400ae2661cfc6/CleanShot-2B2024-09-04-2Bat-2B22_45_05.gif?expires=1728572400&signature=949c70b5e6f8f758045578718842f79a6f0cc9cbb90727381f7ce19f901b9337&req=dSEuHsB%2BmYJZW%2FMW1HO4zeoz800%2Fx72MqPOJ9fQhK2lXDg%3D%3D%0A 4. We can now neatly write our array of objects into individual rows by inserting a column in the 'Select a List from a Column' field. Type a forward slash, choose the column containing the arrays, open its properties, and click "insert all items". https://downloads.intercomcdn.com/i/o/1198904363/5b8ff331300c2f7d8c10a39f/CleanShot-2B2024-09-04-2Bat-2B22_53_01.gif?expires=1728572400&signature=05762a10c40fdf97c6ce96d4113d8a4c698efad11029180be5f74a15fcf19ab4&req=dSEuHsB%2BmYJZWvMW1HO4zT205jiFwFMbR2g4Gfhv9uUKuQ%3D%3D%0A 5. Now the last thing we'll have to do is specify which objects from the array we want to write to the new table, and to which columns we want to map them. We'll be able to select columns which are existing or create new ad-hoc columns for this purpose: https://downloads.intercomcdn.com/i/o/1198904365/cd63b467ff32f8730cae429a/CleanShot-2B2024-09-04-2Bat-2B22_55_01.gif?expires=1728572400&signature=b0ba01ed49ec9c19ded65ae4e06d08778b1613e87376bdf347a96eb2a46e4e8f&req=dSEuHsB%2BmYJZXPMW1HO4zRXCYOgnovT6gs3r2grz9eO%2FGw%3D%3D%0A 6. You can also add other column values to the table, which is useful when transferring lead data from one table to another using the 'Write to Table' column. This setup can work independently, without the list feature configured in step 4. https://downloads.intercomcdn.com/i/o/1198904364/78c2e80597d41d589143e455/CleanShot-2B2024-09-04-2Bat-2B23_00_35.gif?expires=1728572400&signature=bbbd9452dfe520ae5e332a62825d19b09db08f24c5ac7c7ebd6752eeb73ade11&req=dSEuHsB%2BmYJZXfMW1HO4zWjfjcpCJJXMLP7nTaI26Nm2bw%3D%3D%0A You're all set! You can now save and run your 'Write to Table' column.
I get a failed to create column error. Any thoughts?
Tried just adding one at at a time and still doesn't do it.
Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1728573300&signature=9debf39d14c52e73d862fd20880c27ebb3af9d1266ba0cfcd20045369c748da0&req=dSEgF85%2FmohWX%2FMW1HO4zYTywCP5AZQV2BKsam%2FhVPsWfw%3D%3D%0A
I sent you a loom too
Looks like the issue was with the Clay API key you linked here, was able to swap it out and the enrichment is running correctly now!
Hi Michael R.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
.png){kind=logo}
