When your application requests private data, the request must be authorized by an authenticated user who has access to that data.
Again, that user would be me – the application developer. The users of my application will not have these sheets shared with them.
So I would like my meteor server to be “logged in”, so to speak, with my Google account. The users of my app, on the other hand, will be logged in with their own GitHub accounts.
I would then like to pull data from my private sheets and display it to the users of my application.
From what I’m reading in the Google API docs, I’m not sure this is possible – but it seems to me like it should be.
Thanks much, ddh. I have cloned your app and am running it locally.
Unfortunately, however, I can’t figure out where in the code the connection to the Google Sheets API via offline token is occurring. Can you point me to the correct lines?
Well, I guess I got over the hump of not being able to fetch the data. Now my problem is that the data in the spreadsheet is returned as formulas, not as results. So instead of getting “10” returned for a cell that contains a formula resulting in “10”, I get back something like “(A5 - B3) / F4”, etc. Needless to say, this is useless to me, since the whole point of using a spreadsheet in the first place is for the calculations it performs.