Connect to private Google Drive Sheet

[blaubner]

Evening,

Is it possible to retrieve a google sheet from a private Google Drive using SAS? I found this discussion from a long time ago, but this example is using a google document URL that is public.

https://blogs.sas.com/content/sasdummy/2012/12/18/using-sas-to-access-data-stored-on-dropbox/

The data that I would like to retrieve is private and requires a username. 

I was just introduced to a solution for R, so I'm wondering if SAS has a solution. The goal is to directly connect to the private Google Drive Sheet and bring the data into the SAS work folder. 

Is this possible?

[Reeza]

I suspect so but don't have time to develop a solution. 

You'll likely need to use the Google Sheets API REST interface and PROC HTTP. 

SAS & REST API

https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2020/4426-2020.pdf

Google Sheets API

https://developers.google.com/sheets/api/reference/rest