GA add-on doesn't work

[Michal Nováček]

I would like to get some data from GA via spreadsheet add-on as I did a few weeks ago (I gathered ~200 000 rows). I am using same metrics, dimensions and rest of the settings but I am still getting this error :

https://i.stack.imgur.com/hTpIg.png

I found that I will get some data when I do not set up "max-results", but the default is set up on 1000 which is not enough for my needs. Why?

What I have tried to solve this problem and it doesn’t work:

1. change GA views
   
2. change dimensions and metrics
   
3. change time range
   
4. create new spreadsheet
   
5. set up sharing settings of spreadsheet to "public on web"
   
6. check developer console - nothing appeared there

I found the link regarding limits and quotas on API (https://developers.google.com/analytics/devguides/config/mgmt/v3/limits-quotas#) and I should pass only through 50 000 requests per project, which I actually exceed on the first run, so another question how is it even possible to get more data than I suppose to get?

There is no any interpretation for the error.

Perhaps I am missing something, appreciate your help.

[TPN]

I may be wrong but from your screen shot I dont see commas between your dimensions. When I remove the commas from mine and format the cell like yours with hard line breaks, I get an error. But its not the same error. Put the commas in and see if that gets you a different result?    Same thing with the metrics........

[Michal Nováček]

Thank you for your reply. It doesn’t help me at all :/

[Michal Nováček]

I already reproduced the query in query explorer (https://ga-dev-tools.appspot.com/query-explorer/) and it works perfectly, so I may be wrong but there could be a bug within GA add-on.

[Philip Walton]

That error you're seeing is coming from Sheets, and not from the add-on. It could be temporary. Are you still seeing it?

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spreadsheet-add-on+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/d0aca3e7-7b3e-4462-82fd-15dd30f00a8a%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Michal Nováček]

Yes, I am still seeing the error. I figure out that there is a problem within specific time range (I totally don't understand why :/)

Time range 08/05/2017 - 23/05/2017 - doesn’t work, getting error
Time range 09/05/2017 - 23/05/2017 - works great

Is the error really because of sheets error? Perhaps I am mistaken, but it looks like that there is a problem with API.

michal