ImportXML not loading due to number of requests

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

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

Google Sheets + ImportXML

Updated September 17, 2018 20:03 PM

IMPORT XML not updating for unknown reason, any ideas?

Updated February 24, 2019 05:03 AM

How to match XPath for Sheets IMPORTXML formula?

Updated June 21, 2018 21:03 PM

Help me with a importxml query

Updated October 26, 2018 11:03 AM

Get URL from web page using IMPORTXML

Updated January 22, 2019 11:03 AM