Accessing and Refreshing Job Descriptions in Clay Table

I would also like to take data from job descriptions in this table: https://app.clay.com/workspaces/346206/tables/t_Hizjx8bwPS3Z/views/gv_RihWVvEgrkCG . Problem is that the description is linked to another page and I don't know how to access it. Also, this table is old and now contains old jobs. How can I refresh it with a new search from the same companies?

4 comments

Stefano
·
·
Hi Mark! To find the job descriptions, use a web scraper, which will pull the details directly from the job listing URL. I’ve added a 'Zenrows' column to your table for this. After scraping the data, we can use ChatGPT to summarize the description, as the scraping output is returned as unstructured data. I’ve also included a GPT column to handle this part of the process. As for the second part of the question, I would recommend doing the following to find newer jobs from the same companies: -Right click on the "Imported Jobs" column header and select sources. https://downloads.intercomcdn.com/i/o/w28k1kwz/1242226405/4100e9f4301c65375edc9f3badab/Screenshot%2B2024-11-06%2Bat%2B1_28_19-E2-80-AFPM.png?expires=1730919600&signature=e8744402fa0844433b212d987dfd5d1081e4c6b0090b8ab30b5679fdbb61eba6&req=dSIjFMt8m4VfXPMW1HO4zdWaF4hgGEBdwHvsKkh4JXxsjSyZNUA8KV82Arli%0ATq6T%0A -After this, a pop up table will appear on the top right, press the "Edit Source" blue button. https://downloads.intercomcdn.com/i/o/w28k1kwz/1242226403/01ae9b06ed8e3d67afe569ffdf50/image.png?expires=1730919600&signature=5b326e5a8264afd4dbef043e3973c3d6292e8007291190e0d1d500d5c2b2ab00&req=dSIjFMt8m4VfWvMW1HO4zWFzMpTBT5%2BjE2Jzh4iHBl0g0uBIvw4HLt84na%2Fn%0AuCYQ%0A -This will then prompt you to insert parameters for the jobs you are looking for(if you are looking for the same companies and job types I don't believe there is any need to change this). -After inserting all the parameters for your search you can then press on "Update Table". This should update your table with the new jobs found that match the previously given parameters. I hope this was helpful, please let me know if there is anything else you would need.
Channeled
APP
·
·
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
Channeled
APP
·
·
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Channeled
APP
·
·
Hi Mark S.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: