.png){kind=logo}
How to Duplicate a Table with Headers and Format in Support
Hi, Support. What is the best way to duplicate a table to use the same headers and format? Then does it duplicate the prompts?
Hi, Support. What is the best way to duplicate a table to use the same headers and format? Then does it duplicate the prompts?
Hi Omar, thanks for reaching out! Duplicating a table will duplicate all of your table columns and prompts, just not the table data itself! Here's how to duplicate a table below. Let me know if you have any other questions! 😊 https://downloads.intercomcdn.com/i/o/w28k1kwz/1257836480/9eda2669aafb7a72f06bf0ebc15e/AD_4nXdgvOG9niP5C2H3ScBomj0nx_0OpvR8Y-hwzBg7_EHza8Bdmo3CvT9Rk5UL6PHA2QlfqZHrsLhuk_yjdHgVeAlmB5CU1jJPJuu4uefdEQCnnHQFQ4TujQYMWhOOpwDe6Z0NPPwooFJpDWhsuRfzhlI_e_4?expires=1732032000&signature=b584358d9976e9ca3a8683d4d8cb904b31d8eef14e55205ebbbc9a4f95bede16&req=dSIiEcF9m4VXWfMW1HO4zSuD2z%2F2cGxAM0myRHsvWGxhS1AnCDDPesuLtDJT%0AGB8j%0A
Thanks Tanvi. Seems easy enough. Once I do that and I have the same headers, do I import my new list into the copied table? I tried it before and it didn't populate the data.
Hey Omar, to import the table data into your duplicate table you will need to export the data from your original table as a CSV and then import this CSV file into your new table! You can find both of these options under the Actions menu in the top right!
Hi Support. Essentially what i want to do is reduce the time that it takes me to build each list. I spend a lot of time creating a new campaign. Can I have a master list that i just keep adding to, and that automatically feeds into smartlead? What is the best way that I can do this? Any educational material that you can point me to or best practices?
Hi Omar, yes you can do this! All of our tables have row limits of 50,000 rows. What you can do is create a find people table and set up your workflow with all of your enrichments. From here, you can continue adding new sources to your find people table which will allow you to expand on the lists that you have already built
Awesome! Thanks Tanvi. Are their any resources that you can point me to?
And then, is there a way to take any inbound leads and push into Clay? I'd love to learn these two methods if possible! Thanks
Hey Omar, here's a quick example video for you about how to add sources to your people table
Here's our online course about automating inbound in Clay, highly recommend checking it out! https://www.clay.com/university/course/automated-inbound If you're looking to just learn more about the product, we recommend checking outthis quick demo video and looking at the rest of the resources at clay.com/university, especially Clay 101. We’ve also started offering open office hours 2x a week to walkthrough Clay’s foundations and answer questions live! You can register for that here. Let me know if you have any other questions! 😊
Hi Support. Are you guys working today on Thanksgiving?
Hey, thanks for reaching out Omar - Yes we do :)
Hi Bo, how are you? I am trying to make my life easier by not having to create a new table everytime I add new leads (not sure if you can see the earlier chat). If I create a 'CSV upload table' where I bring in a list from an external source, does the formatting have to be the same? MOre specifically, I brought in a list from maybe Listkit, which uploaded fine, and added each column that was duplicated. Then, I tried to upload a list from Apollo, which didn't upload. The rows say 8, but only show 2. What did I do wrong and how do i correct?
Yes, when you re-import the leads, it should allow you to map the table to the right column without any issues. It typically would be an issue of CSV. Can you show me on a Loom the CSV you uploaded in the table? I'll be able to tell you what went wrong here :)
Hi support, quick question. I want to use Million Verifier as a list cleaner and it has an API, but CLay does not 'recognize it'. Is there a way that I can still use it as an integration?
Hey! You can totally use Million Verifier with Clay even though it's not a built-in integration. Here's how to set it up: 1. Use the HTTP API enrichment as GET 2*. Copy this endpoint format:* https://api.millionverifier.com/api/v3/?api=your-api-key&email=test@example.com&timeout=10 3. Replace 'your-api-key' with your actual API key 4. Replace 'test@example.com' with your email column using the forward slash notation Let me know if you want me to help you set up the formula - happy to walk you through it! 😊
Thanks Bo. I was supposed to make a video for you with my problem, but I realized that I could use APollo with the api. So i'm testing that. hopefully it gets a bit easier. I appreciate you guys
Hi Support. What is 'your email column' supposed to be?
Hey! The email column type is basically just a way to help Clay understand which column contains emails. When you mark a column as "email type", Clay gets smarter about using that data - especially when you're adding enrichments. Without it, Clay might not automatically connect the dots when you're trying to use that email info. Want me to show you how to set this up for your columns? 😊
Hi Bo. Yes, can you please help? I found the email column that I will be working in. It's listed in 'business email'. How do I replace my email within the text?
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=1732995900&signature=4b2a845c33154d6b6ac26673624aeb5112885347301c9cccde92554a75fde85d&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSn1D5If2BKsam%2FhVPvtIA%3D%3D%0A
I see the change but don't know what it means. So within the endpoint that you provided, change the 'test@exmple.com' to 'email@email.com' ?
Hey! I want to help but I'm a bit lost on what you're trying to do here. Could you tell me: 1. What are you trying to achieve? 2. Are you trying to add data to a table or something else? Once I know your goal, I can show you the best way to do it - whether that's manual entry, importing data, or something else! 🤔 When you want to add data in a table, you can add it manually like I added the text, you can import it by clicking on the actions button on the top right > import and select what you want to import, then map the values to the fields.
Thanks Bo, I believe that I am a bit outside of my league here, and am trying to keep up. My goal is to create a table so that I can just continue to add leads directly into a duplicate table, so that I can save time on building the same table each time. I use Apollo to download leads and have usually uploaded to Clay as a CSV. I just integrated Apollo so that hopefully it is easy to upload and I don't have to do a CSV. Next, I wanted to have the email addresses from Apollo, verified with Million Verifier. Hopefully this helps. And if so, how can I make my life easier and my outreach process faster and smoother.
Thanks for explaining! Totally get what you're trying to do - let's make this super simple for you! 1. Click "Actions" in the top right corner 2. Hit "Import" to bring in your Apollo CSV data 3. Match up the fields with where you want them to go You can keep adding leads this way until you hit 50k rows. And hey - if you need more space, just duplicate the table! 😊
Thanks Bo, I am trying to download this test CSV into a table and it isn;t transferring with the same rows. I've included a pic using the same csv files between the two tables and I can't get it to populate properly. The new table 'apollo-contacts' I uploaded into a new table. What am I doing wrong that I can't get the same data into my "*Master External upload"?
Hey! Ah I see what's happening - you're trying to move data between tables! That's actually a different process than using CSVs. Here's how to do it: 1. First, add your Clay API key in your profile settings > integrations 2. Go to the table with your data 3. Click "Add enrichment" in the top right 4. Look for "Write to other table" enrichment 5. Map your columns to match where you want the data to go 6. Hit run! http://www.clay.com/university/lesson/write-to-table-integration-overview https://www.clay.com/university/lesson/write-to-table-clay-101 If you simply want to import a CSV (a file from your computer, you can do this more easily) by going int he table you previously sent me (that I added the email and click on Actions > Import > CSV https://www.clay.com/university/lesson/csv-import-overview Want me to walk you through which fields to map? Just let me know if you get stuck at any point! 😊
close this ticket
Hi, I wanted to go over this again if possible. I download leads from apollo and want to use Million Verifier to ensure that they are cleaned. How can I use HTTP API to clean them before they go into Smartlead? Thanks
Hey Omar! Thanks for reaching out. Just to confirm, you'd like to use Million verifier to validate the emails and only send the emails marked as valid to Smartlead? Do you have a table you're trying to set this up in? Happy to review your current set up.
Hi Daniela, I want to use table: https://app.clay.com/workspaces/237559/tables/t_T3XiSDY7gA3M/views/gv_kWtUfk6dGhdV
Is there a way to have it automatically scrubbed before being pushed into smartlead? I'm looking for an easier way to outsource my table to a teammate so that I don't have to keep 'doing' stuff and it is more plug and play. Lemme know if this is possible and what my abilities can be for my use case
Hey there Omar thanks for reaching out, jumping in for Daniela here, what you will do is create the HTTP API column and then following the screenshot below enter in your API key were the "your-api-key" part is then save and run. https://downloads.intercomcdn.com/i/o/w28k1kwz/1273880354/e5f8d615711ea2c62050fad3fff3/image.png?expires=1733172300&signature=eb6c0ec335e17f427a9d7c5bc32518fbee18402b4c02ece88a0afa023fed7270&req=dSIgFcF2nYJaXfMW1HO4zZhV41jNqjLuQy6UqtsxgYe11oT1Su0TWpP8fS8U%0AW9Mt%0A
Hi Luis Arturo, that makes a lot more sense! I'll try this
Hi SUpport. If I duplicated a table, but no longer want an enrichment to run, can I just hide it? If I do that, will it run in the background, or should I just delete it? How do you handle unused columns? Thanks
Hey there Omar thanks for reaching out this is a good question. In this case it is better just to delete the column, as even if you hide the column, it may still run if the trigger that will tell the column to run is met.
Hi LuisArturo, okay, I will make sure that I do that. I was never really sure. THank you for the continued help!
Can you tell me what I did? https://app.clay.com/workspaces/237559/tables/t_NxPFEPzsDF4q/views/gv_kkvByupAh63Phttps://app.clay.com/workspaces/237559/tables/t_NxPFEPzsDF4q/views/gv_kkvByupAh63P After deleting the unused fields, 'push to smartlead' said could not add. Can you check?
Hey there Omar can try toggling this option in the setup menu? https://downloads.intercomcdn.com/i/o/w28k1kwz/1277129382/88c930b1571e8f89f3aafc14e9d1/image.png?expires=1733363100&signature=4bc4b4efd02a142e1e08695f71bf93c04eb2ce29b7d763c7af576e9bd9069bc7&req=dSIgEch8lIJXW%2FMW1HO4zfZP7WHKZMp%2FLVFSR8bHWSuZdtyJOY8TyP%2FUcyA1%0ACWFd%0A
Done and that worked! But these three names were brand new and didn’t exist elsewhere. Why would that have mattered?
Hi Omar! Jumping in for Luis Arturo. I tried to check your table since I don't have context, but it seems to have been deleted! It's also worth noting that sometimes leads can be blocked for reasons such as being marked as invalid or blocked by a previous action, which could prevent them from being added to a campaign, even if they are new. Happy to look at your table again.
Hi Support. Is there a way that I can make formatting easier for job titles? For instance, sometimes the words are all capitalized, such as "CO-OWNER", instead of "Co-Owner" or it appears with characters such as "CEO|Founder|co-owner" instead of CEO, founder and co-owner. I find myself still manually going through each column to ensure that the formatting looks good, and that it makes sense. Any tips on a smoother way of doing this? https://app.clay.com/workspaces/237559/tables/t_T3XiSDY7gA3M/views/gv_kWtUfk6dGhdV Thanks
Hi Support. I had an overage of 9300 credits that I wanted to restore. Can you help me please?
I should have about 30k in credits. I was planning on doing a large campaign to use it all.. i didn't realize that the billing happened today. What can I do to get my unused portion back? I don't want to just waste the 9300 that I had. I thought it rolled over.
Hey Omar! Thanks for reaching out. Happy to help✨. Formatting Job Titles: The best option for formatting/cleaning up job titles to follow the same structure is the AI integration. We have a template called "Clean Job Titles" that can help with this. I made a quick recording below showing how to select this. Let me know if this helps! Credits: We can provide a one-time rollover for the 9300 credits. At the end of your current billing cycle, your credit balance will be capped to meet the default rollover limits (2x your monthly credit allotment). For context, on your current plan, you're only able to accumulate a maximum of 20k credits in your balance. Let me know if this helps!
Hi Daniela, thank you so much for the explanation for the credits and formatting job titles. I will try this out! And thank you for your understanding for my credits. Some months i have too many and others, it not enough. I needed it for a large project that I am doing, and missed my time. Thank you for your help!
Do you know of a way to clean job titles using functions only, or is the best way through AI or credit usage?
Happy to help! It's possible to format the column using a formula, but this may not be as effective if you need to make multiple edits or if the values in the column vary significantly in structure. Here's an example prompt (saved in your table) that you can use to format text to sentence case and limit it to a single job title if the input includes 'CEO,' 'Founder,' or 'Co-owner. Also sharing a guide for creating AI formulas: https://www.clay.com/university/lesson/ai-formulas-conditional-runs-clay-101 Let me know if this helps! https://downloads.intercomcdn.com/i/o/w28k1kwz/1288808777/27aae6f7d37ed666a40a6bfb8f18/CleanShot+2024-12-09+at+18_21_45%402x.png?expires=1733767200&signature=335979d7201c28b642ccf41e8debba80f1082803794eeb681ba20c6b9634108b&req=dSIvHsF%2BlYZYXvMW1HO4zTbB353CC0WXzeWOL1UFqtb2OkIwygh79s894iAp%0Aj99%2B%0A
Hi Support. Can you help me on my table? Today, I am getting an 'error' code when usually I can work through it. I can't describe it, but its a 'hard' error meaning, it just removes the entire row. I;ve included a Loom https://www.loom.com/share/07f2f5db8e41456e9e99bcc6e603c25d?sid=3c952646-603b-434d-ad47-cb2fafe3d401 https://app.clay.com/workspaces/237559/tables/t_2o5p8ASF4qsQ/views/gv_DvXdVKq9jt6z
I increased my chatgpt budget. Was that maybe the problem? Also, which is the most cost effective model to run? I am running o1 and I have to keep logging into Open to adjust my budget.
Hey Omar! Thanks for the message. Happy to help✨. The error is related to your monthly quote on Open AI, which means that you have exhausted all the credits allocated to your Open AI API. Credit costs vary across different models. Models like GPT 4o-mini tend to have lower costs while models like GPT 4o or O1 cost more. Here's a quick resource for model pricing: https://openai.com/api/pricing/ To resolve the error, you'll need to check the billing section of your account to buy more credits for your Open AI account. Here's a resource for this: https://platform.openai.com/settings/organization/billing/overview Let me know if you run into any issues! https://downloads.intercomcdn.com/i/o/w28k1kwz/1291633969/a18c54c8e6f75145b7c263eff573/CleanShot+2024-12-10+at+19_03_15%402x.png?expires=1733856300&signature=64db6a67fc47e7da42c52c8064f27fd88155c233db151ac8ab60415473d718ed&req=dSIuF899nohZUPMW1HO4zY5XlApiGJx4hfYaU9WMsuFOnmWUADJ6wEwKTmN0%0A7cSR%0A
Nice, I'm good to go! I was in the wrong section in Open thinking I fixed it when I didn't. Thanks for providing the link
If I change the model now, while I already have outputs for it, will it create a new trigger and start a new output at the new model? When should I change models or is that something that I should consider initially?
Hey Omar! It's best to pick your model at the start, as changing it mid-way means your existing outputs won't update automatically. You'd need to re-run everything to get the new model's outputs and it'll cause stale data. Example of stale or outdated data: https://www.loom.com/share/1a9204dc588f42efa6fc84e26fcf0d13?sid=e6b02ed6-a2b5-4922-8b0d-2c8d2a7a0596
Hello. I am having trouble in Smartlead with a custom field not showing up in the {{ . The statement I am looking for is 'First Sentence Extraction'. Here is the table: https://app.clay.com/workspaces/237559/tables/t_tYPehmXXdszZ/views/gv_CarXRjEXBMyT
I realized I was using the wrong table. I solved that one problem, and now I can't upload to Smartlead. Any tips on refreshing?
I solved it using an old chat recommendation! Thanks team
Got it! Of course, let me know how this goes and if the issue persists, happy to dive deeper here :)
Hi Daniel or Support, thanks for the follow up. Can you tell me where the output is for this column:
Hi Omar, thank you for reaching out. To view all the rows imported from your enrichment, follow these steps: First, click on any cell within your enrichment. In the example below, I am expanding the "Lookup Single Row" enrichment, but this works the same for any enrichment containing a JSON object. https://downloads.intercomcdn.com/i/o/w28k1kwz/1291688510/c228d2db458f66f6d2e1e54f3d73/CleanShot%2B2024-12-10%2Bat%2B13_31_27-402x.png?expires=1734369300&signature=f6afafeea72f5d30d0ba940db6a2058060be66fa7cb45cd508f037e72b5748e5&req=dSIuF892lYReWfMW1HO4za5lxIfVqPGePnuppUTs4NFQsw%3D%3D%0A In the menu that appears on the right, hover over the column you want to view. Then, select "Add as Column," give your column a name, and click "Create New Column." In the example below, I am creating a column to display the query, called "Query". https://downloads.intercomcdn.com/i/o/w28k1kwz/1291688508/ac33d3a5906f750aa441c12168ac/CleanShot%2B2024-12-10%2Bat%2B13_31_38-402x.png?expires=1734369300&signature=eb8e689c778ddb05c8566d4039d6b16105e122feed176efd857e7899049de322&req=dSIuF892lYRfUfMW1HO4zRCzPr11hKk2J4%2BgGQYpV0VWAA%3D%3D%0A Once you do this, a new column will automatically populate with the desired information. In the example below, you can see that the "Query" column has been created. https://downloads.intercomcdn.com/i/o/w28k1kwz/1291688504/bf379747252a998d79c9a1d69ce2/CleanShot%2B2024-12-10%2Bat%2B13_31_57-402x.png?expires=1734369300&signature=dcec1a3b4b4d015d0de701b09e99a01a8b2a6ba202f2283b817f98bd4516e57f&req=dSIuF892lYRfXfMW1HO4zWZB3rRYFUU1%2BW0UjTjyT9jbtw%3D%3D%0A Let me know if this helps!
Yes!! That works, thank you
I have another one for you: I have a current campaign out that has some mistakes. I should have used Claygent, but used Chatgpt to give me website and linkedin info. I have a 1900 person list that sent out to a few hundred today already through Smartlead. Can I SAFELY update my campaign so that I am using Claygent now, without having 'holes' within my campaign copy? Thanks
Hi, could you explain what your concern is? I am confused by what you mean by " Can I SAFELY update my campaign so that I am using Claygent now, without having 'holes' within my campaign copy?"
If I were to change my column to a new prompt, and removed the one that I wrote the copy for that was mapped out, is there a potential that Smartlead won't update with the new prompts if I were to remove the old ones? I guess what I'm asking is, what is the best way that I can fix a mistake for a current campaign without making more mistakes?
You can definitely create a new column, generate a new output, and map that output to Smartlead instead of the previous one. Everything should work smoothly. However, I’m a bit unclear on why you’d prefer using Claygent over ChatGPT for this task. When it comes to writing emails, ChatGPT is generally a better choice, while Claygent is more suited for web research. I’d be happy to help you set up something else if needed, but it seems like you're already on the right track! Let me know if this helps.
Thanks for the critical thinking. I used Chatgpt to search the web and cross reference the target's linkedin for "what they do". Although the output looked good in Clay, the received messages from people said that "I don;t do X, I do Y". I know that GPT doesn't web scrape, but Claygent does. After comparing the two, I recognize Claygent is more accurate for that task. I do prefer Chatgpt to do the writing tho, I agree. Thank you so much for the help
Happy to help! Let me know if there is anything else I can help you with!