How can i utilze features such as Claygent to pull the job description of a job opening using the job opening URL as an input? I would love to have a prompt that works, my current prompt keeps failing. Here is the link to my table: https://app.clay.com/workspaces/236310/tables/t_VkeDpNZ8Opwt/views/gv_K6RSRlBIxhwz
๐ Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Hi sujda, thanks for reaching out! I don't see a Claygent column in your table, but I do see that you created a ChatGPT column that summarizes the job description you scraped! You're on the right track weith using Zenrows to scrape the job posting, but here are a few improvements I would make to achieve your goal: 1. Run Zenrows with the Autoparse setting on - as you can see from your current Zenrows column the scrape data is currently not structured, making it hard to clearly extract the Job Description. I created a second Zenrows column for you with autoparse on and you can see now that the description was segmented as a field in the scrape. https://downloads.intercomcdn.com/i/o/w28k1kwz/1218711776/88fc3edfce31947722ba6baa5476/CleanShot+2024-10-16+at+18_54_38%402x.png?expires=1729121400&signature=2de12f542011462c085a2d79b4c7c80064946735377dd3dad3442a51c9174bea&req=dSImHs5%2FnIZYX%2FMW1HO4zXzV%2Bi0hasrbWQbbHm%2Bz6md5isSqIiVNc%2FTFouUA%0Ab0qb%0A 2. Use Claygent's web scraping abilities to format this description to remove special characters. As you can see from the description field in the second Zenrows scrape, it returns some special hidden characters that are in the job posting. I've used Claygent to correctly format the scraped description text and referenced the job posting link to show the output we are looking for. You can see this final output in the "Job Description Cleanup Response" Column! https://downloads.intercomcdn.com/i/o/w28k1kwz/1218712629/0cbfc59e87c74d963eff4d213c25/CleanShot+2024-10-16+at+18_56_57%402x.png?expires=1729121400&signature=4074ebf10902efb6e465cbe846e6ba67ae1e82751653cb909eb7bb63aa424167&req=dSImHs5%2Fn4ddUPMW1HO4zZC9cUDD3UmWX4vUljU7iU9n3cQjN%2B0Y40DAGHL2%0A70AJ%0A Take a look at these results and let me know if this is what you're looking for. Feel free to run this on the rest of your column if so! ๐
Thanks, Tanvi!