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.