Possibly for public use, but more likely not published -- the ability to open a Google Sheet and read one or more cells based off voice input from the user. I tend to store information, updated real time, for stock prices, net worth, commodity prices, etc. and would like to be able to be able to ask Alexa questions like below and have it pull specific cell data and read it aloud: Alexa, what is the value of my retirement portfolio? Alexa, what is the price of gold? Alexa, what is my net worth? These cells could also be populated with any other kind of information. Thanks.
I know I enabled an IFTTT setup that stores songs played by alexa on my own Google Spreadsheet. I was looking to do something like that, but it sounds like I would have to manage an intermediate page to handle accepting/submitting the Google OAuth2 info, which is unfortunate -- but not terrible. Was just hoping there was a more 'direct' way. I don't fully understand how the IFTTT stuff is actually 'tied in'. I was also reading up on the threads for testing, and was disappointed to see there isn't an easy way to get a small number of non-developers setup for testing. Seems like this is a critical need for anything that should go through a Beta phase before release.
Account Linking just lets you link to your own web app. It doesn't do anything magic. There's no way that you can use it to "OK" access to a 3rd party application.
If you want to do this just for you, do what Stephan said. If you want to do it and release it for wide use, you're going to need to create the web app, use account linking to link to it. Have the user enter in their Google credentials into that. Store them in your own off-site store. And use them when they invoke the skill to access the google spreadsheet.
If it's just for private use, there's no need to go through account linking....you can just hard code in the keys you need to access the sheet on your drive.
(I wrote a "skill" that did that a long time ago, before ASK came out and people were hacking away scraping the text off the history card in the Alexa app.)
I've also been trying to figure out how to get at a particular user's Google Drive to be able to persist data there, and (e.g) update a spreadsheet. I have been trying to read up some on the Link Account capability, but it seems like that is something you might deal with on your own web-site/account. I I've been trying to figure out how to get the Skill setup to allow a user to "OK" access to a Google Spreadsheet, and then access that from within the skill.
If you are asking for an intrinsic feature for The Echo, this is not the forum for that.
If you are asking if this can be done with the Alexa Skill Kit, then the answer is "yes". There is an API to Google Docs and you can use that to read spreadsheets stored in it. I've done that before with a mobile app.
You will not be able to implement a skill that is launched with those requests. Only native features can be invoked that way. It will need to be:
Alexa, ask for the value of my retirement portfolio
Alexa, ask for the price of gold
Alexa, ask for my net worth
And other similar variants.