I have filled a google spreadsheet with around 10 URLs and Xpaths. After discovering that ImportXML has some drawbacks (it is getting perpetual loading errors, even when there are only 1 or so functions running). I am looking for another way to populate the sheet.

My first solution was to delete the importxml and implement a write and repeat macro. However, after about two months, all the seats suddenly stopped working.

Is there a way to solve this with a script?

There is a sample sheet that has stopped.

https://docs.google.com/spreadsheets/d/10Ljo7SESFdGj1Xc7U_Tg3gljHhfqbuyVV5Whulezyv4/edit?usp=sharing

CodePudding user response：

This week is look like global problem importdata in google spreadsheet

https://www.reddit.com/r/googlesheets/comments/t5blgz/is_importxml_broken_was_working_for_months/

https://www.reddit.com/r/googlesheets/comments/t5vixb/importhtml_error_loading_data_taking_forever/

CodePudding user response：

https://support.google.com/docs/thread/153166088

IMPORTXML function was working for two months then stopped this morning