Matomo Data into Google Sheets using API/Macro issue

Using this walkthrough I had successfully ported Matomo data into Google Sheets to use in Data Studio. It was functioning as planned for several weeks, and all of a sudden stopped. I tried redoing it 3 different times and still haven’t figured out what’s going on. When deploying the macro, Google says it was successful, in Google Sheets it simple says “No data available”.

The only variable between the walkthrough and my execution, is that I use the URL that comes from a Custom Report, as opposed to the walkthrough which uses a general URL