Hey there! I'm struggling to collect the results in bulk in a new column from an Apify Actor. Can you help? Here's a short video explaining to you guys what I want to achieve: https://www.loom.com/share/b3986a7e14ee445f9c70e866876177b0?sid=cb7f3086-055c-477e-8282-03c220a3ceb7 Looking forward to hearing from you 🙂
Here's how to collect Apify Actor results in a new column: 1. Click on the cell containing your Apify enrichment data to open the Cell details panel on the right.
2. Find the specific endpoint/data point you want to extract from the results.
3. Hover over that endpoint and click the Add as column button that appears on the right.
4. In the Add description as new column section:
• Enter your desired column description
• Click Create column to generate the new column with your selected data.The new column will automatically populate with the specific data point you selected from your Apify actor results.
Sources:
Apify integration overview | Documentation | Clay University
Table columns overview | Documentation | Clay University
Yeah, I know but I want to do it in bulk because I have 5 results within each row. Is there a way to do it automatically?
To collect multiple Apify Actor results in bulk: 1. Click into the Source Cell containing your Apify actor data 2. In the Cell details panel, locate the specific data points you want to extract 3. For each data point: • Hover over the endpoint • Click the "Add as column" button • Enter your desired column description • Click "Create column"The system will automatically populate new columns with each selected data point from your Apify results. You can repeat this process for all 5 results you want to extract from each row. Source: Apify integration overview | Documentation | Clay University
may I chat with the team?
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Ok
Hi David, thanks for reaching out. Can you tell me what you're trying to achieve with these results? My recommendation is to directly enrich the results instead of adding them as a column. If you need to add them as a column, you can use formulas to extract the desired values and then write them to a new table. You can also transform the table into a workbook by clicking on the table name. Happy to provide more detailed step by step after hearing what you'd prefer and please send me the table URL :)
I tried to use formulas but I didn't get the result that I want In the following video you can see what I want to achieve https://www.loom.com/share/b3986a7e14ee445f9c70e866876177b0?sid=cb7f3086-055c-477e-8282-03c220a3ceb7
David - 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=1736983800&signature=ab759535f99be4b2f4394148b5915247c60b24f40310be7014de10580c1360eb&req=dSEgF85%2FmohWX%2FMW1HO4zYTywS31DpQe2BKsam%2FhVPsIZw%3D%3D%0A
I recorded this walkthrough video showing exactly how to set this up: https://cln.sh/ZWLJ21zp Let me know if you have any follow-up questions!
Thanks for your video, Bo. I'm still not getting the results I want, though. I have five texts and an owner username in each row. In my new table, I need each text and each username in separate columns, maintaining the original order. Currently, I'm only seeing one text and one username
Hey David - So just to confirm, you want each of the values as individual columns (all the text and usernames) of all the comments. For example, fcbarcelona has 20 comments, so you would want the 40 columns (text and usernames) as columns. Correct? Trying to split multiple texts and usernames across columns on the same row will run into limitations with Clay's 72-column maximum, but it also isn't doable automatically other than adding each value as a column. Could you share what you're ultimately trying to accomplish with this? Understanding your end goal will help me recommend a better approach that works within Clay's design.
Hey Bo - Yes, I want each of the values as individual columns (all the text and usernames) of all the comments, and maintaining the same order. My end goal is to upload those individual values in Lemlist to create personalized messages
Got it - Since Clay has a 72-column limit, you'll need a different approach to handle multiple text/username values. Here's what you can do: Send the data to Google Sheets first - this gives you more flexibility with column structure for your Lemlist personalization. You can try this by using Clay's Google Sheets enrichment feature. Alternatively, you could use Clay's AI to identify the top 3 most relevant comments and store those as individual columns. This would stay within Clay's limits while giving you key content for personalization. Otherwise, you'll need to manually add all the values as columns, yes. In your table, I added a lookup to the write to other table, and this lookup will allow you to have it more sorted out and might actually help you add all of those columns as columns.
And how can I send all the data (all text and user name) to Google Sheet at once?
We would need to first connect with Google Sheet. You can do this by adding the integration "Add Row" in the enrichment panel by clicking the "add enrichment" button at the top right of the page. From there: 1. Create a new Google Sheet table 2. Add all the headers 3. Copy the URL 4. Paste it in the enrichment in Clay 5. Map the values one by one, 6. Run I'd recommend testing this out first with a sample to see if that is the right fit for you first before mapping all the 20 values + the other values like usernames as well.
How can I map each value individually (text and owner user name)? Remember I have those values in a row, and I need it as individual
Yes, I get it - you've got values nested in an object and need them split up in individual columns side by side in a sheet for importing it inside of Lemlist.. You need to map each value as its own separate field. (see GIF). After you add your URL and select the Sheet, you'll map each value individually to get them properly separated. Just make sure you correctly name the headers and that all the headers have different name (e.g text_1, username1, text_2, username_2) I know the initial setup might feel a bit tedious, but once your table is configured, all values will automatically go to their right columns. https://downloads.intercomcdn.com/i/o/w28k1kwz/1338399474/344dbcfac296e59d8fcdef91cfb8/CleanShot+2025-01-16+at+_34WAJ9B1Rb.gif?expires=1737045900&signature=d5e6c2ec0870fe6a57d04adf07025e025e00ab340f3822474ac963c72e3e30bc&req=dSMkHsp3lIVYXfMW1HO4zZmoQyHOi6exQ5AsfKkm57gL8Felu2zvqfNp604R%0A4IPA%0A
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.
.png){kind=logo}
