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