search

kalnyc67 / analytics-issues

Automatically exported from code.google.com/p/analytics-issues
0 stars 0 forks source link

Login Required when using Analytics API in Google Spreadsheet #554

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Hi,

I am trying to get some Google Analytics data into a shared Google spreadsheet. 
I wrote a custom function and it works find when I debug it. However, when I 
call the function as a cell function in the sheet, I got an error called "Login 
Required" at the line calling the Analytics.Data.Ga.get() function. Is that 
because the spreadsheet is shared or do I need to add any authenticate 
information in the custom function? 

I am looking forward to your reply. Thank you very much!
Ting

---------------------------------------------------------------------------
NOTE: This issue tracking system is for Google Analytics developer products
only.
If you are not a developer/programmer visit:
http://www.google.com/analytics/support.html
---------------------------------------------------------------------------
Name of affected component: Core Reporting API

Name of related library and version, if applicable (e.g. Java, Python,
HTTP, Objective-C, etc.):

Issue summary:
Provide a brief summary of the issue you're experiencing.

Steps to reproduce issue:
1.
2.
3.

Expected output:
What do you expect to see after performing the above steps?

Actual results:
What do you actually see after performing the above steps?

Notes:
Provide any additional information which might be useful here. Feel free to
attach screenshots or sample code which demonstrates the issue being
described.

Original issue reported on code.google.com by chiting...@gmail.com on 19 Dec 2014 at 8:17

GoogleCodeExporter commented 9 years ago 
The issue tracker is for reporting bugs or feature requests for Google 
Analytics developer related features.

I suggest you take a look at the Google Analytics spreadsheet add-on if you 
want to export GA data into Google Sheets: 
https://ga-dev-tools.appspot.com/spreadsheet-add-on/

If you'd prefer to write your own script then you should look for assistance in 
the Help section of the Apps Scripts documentation on how to carry-out 
authentication of Google APIs in Sheets.
https://developers.google.com/apps-script/support

Original comment by pfrise...@google.com on 22 Dec 2014 at 5:07