Zillow Listing → Social Media Video Generator (Python)

Zillow Listing → Social Media Video Generator (Python) Overview I need a tool that takes a Zillow listing URL and turns it into a short vertical video (Reels/TikTok/Shorts format) with the property's key details, ready to post or drop into a video editor. Output should land automatically in Google Drive, organized by listing. Also should create folder with listing photos What it needs to do Input: a Zillow listing URL Extract: address, price, beds/baths, square footage, description, listing agent, and photos Generate: a vertical (1080x1920) video — title card with property stats, photo slideshow, description/agent outro card Organize: auto-create a Google Drive folder named after the property address, and upload the video (and photos) into it IDEALLY will export to a google sheet, and link drive photos to spreadsheet so we can post etc Output format — please read The final output is a standalone MP4 file, ready to manually download and upload to Instagram Reels, TikTok, YouTube Shorts, etc. yourself. This does not need to auto-post to any platform, and does not need to export as an editable project file for other software — just a finished vertical video sitting in the right Drive folder. Important constraint — please read before applying Zillow actively blocks automated scraping (bot protection), and there's no official API for listing data. Scraping success will vary listing to listing — some pages return full data, others block or partially load. The tool needs a manual-entry fallback (a simple form or template file to paste in address/price/description/photos when scraping fails) so the workflow never gets stuck. I'm not looking for someone to "solve" Zillow's bot protection — I'm looking for a tool that degrades gracefully when it can't get through. Starting point I have a working Python prototype already (scraper with fallback, video generator using moviepy, Google Drive uploader via OAuth). I can share it as a reference to speed this up — this is meant to be a refinement/productionization job, not a from-scratch build. Deliverables Working script or simple app, source code included Brief setup/usage documentation Google Drive integration using proper OAuth (no hardcoded credentials/tokens) Nice to have (optional — mention if you'd want to scope this in) Batch processing from a CSV/spreadsheet of URLs instead of one at a time A simple web UI instead of command-line only Background music or a branding overlay on the video Per-photo captions (e.g. "Kitchen," "Primary Bedroom") instead of a generic slideshow Skills needed Python (requests/BeautifulSoup or similar) Video generation (moviepy/ffmpeg) Google Drive API / OAuth2 Comfortable working around real-world scraping limitations rather than promising 100% reliability Similar past projects (scraping, video automation, or Drive/API integration) How you'd handle inconsistent/partial data from Zillow listings Your estimated timeline