Google Sheets cannot load query to editor

I cannot modify my queries in the sidebar.  These are facebook ads queries.  I have previously had no problems.  The sidebar is stuck in this screen.  I see this issue has been brought up previously in the forums, but has not been resolved.

How can I regain access?


  • I have the same problem with a Facebook Ads query. Would love to see a solution.

  • Hi Jacob,

    very sorry the issue persists. This is usually related to authentication issues - for some reason Supermetrics is not able to validate the login to the query data source and it just keeps on trying.

    1. Try clearing the cache and cookies of the browser. 
    2. Try another browser
    3. Sometimes, certain plugins and extensions interfere in the functionality of the Google Drive, disabling plugins and extension may help.
    4. Completely log out of Facebook Ads in Supermetrics (make sure your cursor is in a cell that does not contain a query) and also log out of Facebook Ads in your other browser windows. Then try to log in again via the Supermetrics sidebar.



    Let me know if any of these helped.

    Best regards,

    Supermetrics team

Login to post a comment