Query breaks at 37%

Hi, can anybody give me some clue to fix this problem?

I have a google sheets file witch has a trigger scheduled to run everyday até 02:00 a.m.

It has been working perfectly until yesterday, but today the file crashed.

When I've tried to refresh the query, it goes until 37% and then stays there forever.

Any hint? The query parameters are attached.


  • Hi Alejandro,

    Thanks for contacting us. Sorry to hear about the issues.

    There could have been a temporary issue with the connection to GA, does the issue persist?

    First, start by clearing cookies and temp data in your browser, and open your report in an Incognito window.

    Please try logging out and back in in the Data Source panel, to see if that helps. Deleting and setting up the trigger again may also help.

    Last resort would be to create the query from scratch in another sheet, if the old one has some conflict in it that prevents the update.

    Let me know the outcome.

    Best regards,

    Heidi / Supermetrics

Login to post a comment