Hi there WOXO friends! I'm back with another article/video, ready for it? This time today we're going to learn a cool trick that will allow us to take those Zillow dream houses and turn them into β¨videosβ¨. Let's go find our next video-house π‘
Topics
Tools and resources.
Finding a Template.
Getting the data.
Data curation in Google Spreadsheets.
Using Google Sheets formulas and references.
Importing Google Sheet into WOXO
Building and bulk exporting videos.
Tools and resources.
Web Scraper IO (Chrome Extension and Scraping Platform)
Google Sheets
Getting the data
If you are using Web Scraper IO just copy/paste this sitemap when using the import sitemap option (as shown in the video!).
Sitemap
{"_id":"zillow_real_state","startUrl":["https://www.zillow.com/homedetails/485-Brickell-Ave-APT-4606-Miami-FL-33131/92449405_zpid/","https://www.zillow.com/homedetails/45-SW-9th-St-APT-2104-Miami-FL-33130/247679336_zpid/","https://www.zillow.com/homedetails/60-SW-13th-St-APT-2618-Miami-FL-33130/92445715_zpid/"],"selectors":[{"delay":0,"id":"PropertyImage1","multiple":false,"parentSelectors":["_root"],"selector":".media-stream-tile:nth-child(1) img","type":"SelectorImage"},{"delay":0,"id":"PropertyImage2","multiple":false,"parentSelectors":["_root"],"selector":".media-stream-tile:nth-child(2) img","type":"SelectorImage"},{"delay":0,"id":"PropertyImage3","multiple":false,"parentSelectors":["_root"],"selector":".media-stream-tile:nth-child(3) img","type":"SelectorImage"},{"delay":0,"id":"Price","multiple":false,"parentSelectors":["_root"],"regex":"","selector":".ds-home-details-chip .ds-summary-row-content > div > span > span > span","type":"SelectorText"},{"delay":0,"id":"Address","multiple":false,"parentSelectors":["_root"],"regex":"","selector":"#ds-chip-property-address","type":"SelectorText"},{"delay":0,"id":"Overview","multiple":false,"parentSelectors":["_root"],"regex":"","selector":".zsg-tooltip-viewport > li:nth-child(2) .ds-expandable-card-section-default-padding > div:nth-of-type(2)","type":"SelectorText"},{"delay":0,"id":"PropertyImage4","multiple":false,"parentSelectors":["_root"],"selector":".media-stream-tile:nth-child(4) img","type":"SelectorImage"},{"delay":0,"id":"PropertyImage5","multiple":false,"parentSelectors":["_root"],"selector":".media-stream-tile:nth-child(5) img","type":"SelectorImage"}]}
Spreadsheet used in the video
https://docs.google.com/spreadsheets/d/1yd91oRToUATB7ceIMiz6VR5ekFrUhzjPmsFNhL8FDwc/edit?usp=sharing
Final Videos π₯³
https://woxo.tech/watch/@belen.koffman/JX-mZrPtWZvkz
And that's it: CONGRATULATIONS! You're ready to create as many real-state videos as you'd like and take your video marketing game to the next level π
If you've got any questions δΈ really, any δΈ don't be shy and just give a call out at our Support Chat or contact us at [email protected], we'll be more than happy to help you!