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 solving this problem since I really need to import a lot of data from different URLs?