Using Clay to Extract Podcast Guests and Their Companies

does anyone know a way to use Clay to upload a list of podcasts, and have it output all the guests plus their company names and domains? Clay usually starts with either a person or a company, of which the podcast is neither. I’ve been trying to do this with ChatGPT but the results are underwhelming

8 comments

Arturo O.
·
·
Hey Dana, thanks for the inquiry! Happy to check it out. 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=1731616200&signature=4e253fa59c6a9c73581d1c98800b18343797adc5204514824c0e6ed5d4707e8a&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSr6B5EU2BKsam%2FhVPsGtg%3D%3D%0A Would like to check out what the podcast link includes, if there's a transcript or body of text where this information is mentioned. If it's present, then Claygent or other page scraping tools may be able to collect that data for you, otherwise, it would require finding out where that information lives.
Dana L.
·
·
I’ve actually been able to do this already by scraping the podcast pages for individual episodes and then using claygent to find other details. The rea question though is if I could enter links to the podcast itself, and not links to individual episodes and have some enrichment feature go through each episode individually and extract the guest names, episode titles etc. I’d be sure to only use podcasts that have detailed descriptions
Bo (.
·
·
Hi! Great job on finding a solution with page scraping! Yes, you could enhance this process using Claygent along with our AI Metaprompter for crafting a prompt that would help you automatically extract guest names, episode titles, and other details directly from podcast landing pages. Make sure you specify the outputs of the claygent so they are properly being returned Would you like me to help you set up the Metaprompter for your podcast data extraction?
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.
Dana L.
·
·
the AI Metaprompter link says it doesn’t exist
LuisArturo
·
·
Hey there Dana thanks for reaching out, 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=1731710700&signature=cfaea22e660e04abd1db6a6b49e38909f3503b594c9310ce2b7625103f859c95&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSr7B5cR2BKsam%2FhVPvMuQ%3D%3D%0A
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 Dana L.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: