Optimizing Claygent for Unique Domain Link Retrieval in HubSpot Lists

Hi - I am trying to run claygent over an imported hubspot list to retrieve all website links. The hubspot list has lots of contacts from the same company. How can I configure the claygent to only run once per domain & then apply the results to the rest of the list rather than spending a credit to re-run & acquire the same results for people with the same domain?

6 comments

Parker O.
·
·
https://app.clay.com/workspaces/332842/tables/t_8kfE6yD7PwnA/views/gv_gPETiYdjxXRD
Channeled
APP
·
·
Thank you so much for sharing your feedback Parker O.!
Parker O.
·
·
Tomi F. - I'm getting an error here on step 1 - I'm unable to copy over the column w/ URLs (see screenshot):
Arturo O.
·
·
Hey Parker, thanks for the follow up and sharing this issue. At first glance, it looks like that's actually not a list (array of values nested inside a cell) but rather a single string being pulled. In this video going over the integration I show what a typical list looks like in cells, but if your values aren't in such format, you can skip that field by leaving it empty and focus on the "Add other data" section alone where you should be able to insert and write over those values. Let me know if you still run into any issues!
Parker O.
·
·
Hi Artur G. - got it. I've moved past this. I'm on the last step from above. I've created a seperate table w/ all of the company info & am now trying to import it back into my original people table. The 'Lookup row' function just returns the result of 'Record Found'. How do I get it to populate the rows in the people table w/ the corresponding info from the company table?
Tanvi R.
·
·
Hi Parker, if you click on a cell and open the Records data set you will see an entire array of all the info from your company table for that row. From here you can add each data point as a column to your people table, or take other actions on this data such as filtering or using an AI formula. Quick video below, let me know if you have any other questions https://downloads.intercomcdn.com/i/o/1170349265/26a86637c59fd2e9ae22bc94/CleanShot+2024-09-05+at+15_35_22.gif?expires=1725567300&signature=a36d46e030f67e254c3e37b44e324b044c1c63ba01ba1c1a12ddb8a6065e82ae&req=dSEgFsp6lINZXPMW1HO4zTn13PnzafWAsDp1u8FV6y9jH6BTcKPUxXP2cDgv%0AWS0V%0A