I am using Supermetrics Pro for sheets. When selecting Google Search Console as my data source and selecting a single site from the Select sites menu, I ultimately get the following error:
Query failed: Invalid account object: [selected site]
I have access to the site and data in the search console interface, so not clear why I am encountering this error. I also tried logging out and back in from the Data source menu in SM, but encountered the same result.
sounds like insufficient permissions levels for that site. Please go through them first. (documentation on the subject: https://support.google.com/webmasters/answer/2453966?hl=en)