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.

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!

Did this answer your question?