Skip to main content

Home

Ask Me Anything
Clay Announcements
Clay Club Hub
Clay Cohorts
Clay Cup
Discussion
Introduce Yourself
Share Jobs
Share Resources

Community Guidelines

Attend a Clay Club Event

Powered by Tightknit

Share Content and Events

Share Content and Events

Using Clay to Extract Podcast Guests and Their Companies

·Nov 14, 2024 06:04 PM·

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

6 comments

· Sorted by Oldest

Using Clay to Extract Podcast Guests and Their Companies | Clay

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?
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
·
·
Hi Dana L.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: