Hello great Woxians! Today we're going to show you a cool tech way to create multiple videos with all the latest tips from TripAdvisor, have you packed your bags yet? Let's go - the adventure awaits ✈️🌎

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.

Sitemap

{"_id":"things_to_do_tripadvisor","startUrl":["https://www.tripadvisor.com/Attractions-g60763-Activities-New_York_City_New_York.html","https://www.tripadvisor.com/Attractions-g34438-Activities-Miami_Florida.html","https://www.tripadvisor.com/Attractions-g187147-Activities-Paris_Ile_de_France.html","https://www.tripadvisor.com/Attractions-g187791-Activities-Rome_Lazio.html","https://www.tripadvisor.com/Attractions-g294217-Activities-Hong_Kong.html","https://www.tripadvisor.com/Attractions-g60713-Activities-San_Francisco_California.html","https://www.tripadvisor.com/Attractions-g294265-Activities-Singapore.html","https://www.tripadvisor.com/Attractions-g255060-Activities-Sydney_New_South_Wales.html"],"selectors":[{"id":"AttractionName1","type":"SelectorText","parentSelectors":["Element"],"selector":"span[name=\"title\"]","multiple":false,"regex":"","delay":0},{"id":"AttractionImage1","type":"SelectorImage","parentSelectors":["Element"],"selector":"li:nth-child(1) img","multiple":false,"delay":0},{"id":"Element","type":"SelectorElementScroll","parentSelectors":["_root"],"selector":"section[data-automation=\"AppPresentation_WebCategoryListShelf\"] > div > span[data-ft=\"true\"] > div span[data-ft=\"true\"]:nth-child(1)","multiple":false,"delay":2000},{"id":"CityName","type":"SelectorText","parentSelectors":["_root"],"selector":"div:nth-of-type(3) span.UxSWkNM1","multiple":false,"regex":"","delay":0},{"id":"Element2","type":"SelectorElement","parentSelectors":["_root"],"selector":"section[data-automation=\"AppPresentation_WebCategoryListShelf\"] > div > span[data-ft=\"true\"] > div span[data-ft=\"true\"]:nth-child(2)","multiple":false,"delay":0},{"id":"AttractionName2","type":"SelectorText","parentSelectors":["Element2"],"selector":"span[name=\"title\"]","multiple":false,"regex":"","delay":0},{"id":"AttractionImage2","type":"SelectorImage","parentSelectors":["Element2"],"selector":"li:nth-child(1) img","multiple":false,"delay":0},{"id":"Element3","type":"SelectorElement","parentSelectors":["_root"],"selector":"section[data-automation=\"AppPresentation_WebCategoryListShelf\"] > div > span[data-ft=\"true\"] > div span[data-ft=\"true\"]:nth-child(3)","multiple":false,"delay":0},{"id":"AttractionName3","type":"SelectorText","parentSelectors":["Element3"],"selector":"span[name=\"title\"]","multiple":false,"regex":"","delay":0},{"id":"AttractionImage3","type":"SelectorImage","parentSelectors":["Element3"],"selector":"li:nth-child(1) img","multiple":false,"delay":0},{"id":"AttractionReview3","type":"SelectorText","parentSelectors":["Element3"],"selector":"._3i08HEfn > a","multiple":false,"regex":"","delay":0},{"id":"AttractionReview2","type":"SelectorText","parentSelectors":["Element2"],"selector":"._3i08HEfn > a","multiple":false,"regex":"","delay":0},{"id":"AttractionReview1","type":"SelectorText","parentSelectors":["Element"],"selector":"._3i08HEfn > a","multiple":false,"regex":"","delay":0}]}

Spreadsheet used in the video

https://docs.google.com/spreadsheets/d/1ViqVGJtJEhu2YZTZ06kxd7j2GR6f9rA5iD7onqFI_yA/edit?usp=sharing

Final Videos πŸ₯³

https://woxo.tech/watch/@belen.koffman/JX-S2TkcG6Q0Y


And that's it: CONGRATULATIONS! You're ready to create as many travel 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?