Podcast Data & Summaries Report

I want a single, easy-to-read report that brings together all key metrics and context for every episode of one specific podcast for the month that appears on both YouTube and Spotify, instagram. For each episode you will capture the title, direct links on both platforms, original publish date, view or listen count, number of likes, and total public comments. Please also note the guest’s name and the main topic discussed.

Beyond the raw numbers, I need a detailed written summary for every episode. This summary should be crafted from the full content itself—not just the description—so listeners can quickly understand the substance of the conversation without pressing play.

Deliverables
• A spreadsheet (Excel or Google Sheets) listing: episode title, YouTube link, Spotify link, publish date, views/listens, likes, comments, guest name, topic, and your detailed summary
• A brief methods note outlining how you gathered the data (e.g., API calls, manual scrape, transcripts used) so the process can be repeated later

Acceptance criteria
• Every episode currently published on both platforms is included
• Metrics match platform figures at the moment of capture
• Summaries accurately reflect the episode content and run 150-250 words each

Feel free to use YouTube Data API, Spotify API, automated transcript tools, or your own workflow—just make sure the final report is complete and reliable.