I built a great Google Sheets spreadsheet which has been working for a year with no hickups. It pulls data from websites using importHTML. I then tried to add the importJSON function to the spreadsheet from https://github.com/bradjasper/ImportJSON

The new importJSON works great but all of a sudden my importHTML formulas stopped working and started saying "error getting data". Sometimes randomly they'll just populate the desired information and stop working again.

I tried removing the script for importJSON but it doesn't change anything. If I copy the importHTML formulas into a new spreadsheet they were perfectly.

Does anyone have any idea why the importJSON script has cause this to happen or any ideas on a fix?

Any insight is hugely appreciated.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.