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
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.