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.
TripAdvisor (website with tips and information regarding travel)
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.
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!