There are 2 aspects to this project
We have a travel website with several destinations, we use importxml to get our top 15 accommodations (or less) and get the name, price, origin, destination, image and URL, these all get stored in separate spreadsheets
I have 3 functions, one that gets a list of URLS, one that goes into every URL and retrieves the data, and the last one that formats all the data for use in google adwords business data.
All of this works, but the code is intensive and often exceeds the time limit, this script needs to work a lot more efficiently.
The last script takes takes all the files in the folder and gets the contents of each spreadsheet and then creates a master list with all the accommodation properties.