ImportXML not loading due to number of requests

by Fernando   Last Updated July 11, 2019 02:03 AM

I am working on this sheet and it has a lot of importxml requests between columns N-Q. And because of the high number of requests it seems like the importxml function is not working properly (it keeps loading forever on the majority of cells).

So as a beginner I was wondering if is there any way to import XML data from different URLs (based on data in column E) without making so many requests? What's the best approach to solve this problem since I really need to import a lot of data from different URLs?

Thanks in advance



Related Questions


Updated September 17, 2018 20:03 PM

Updated February 24, 2019 05:03 AM

Updated June 21, 2018 21:03 PM

Updated October 26, 2018 11:03 AM

Updated January 22, 2019 11:03 AM