Support Portal

for ProcessRobot and WinAutomation

Start a new topic
Answered

Reading data from Google sheets using Google APIs

Has anyone tried reading Google Sheets data from WinAutomation?

 

I have read quite a bit on the Google APIs and OAuth2.0, but as I am not a programmer. I have ascertained (I think) that there needs to be a handshake with the WinAutomation application and Google's authentication servers to get an access token, although I don't know how, and then this token is submitted in the Google Sheet API call (which can then be as a web service action I presume). There also has to be a 'scope' of the API (I reckon I want to use:

 

Get https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}

 

with a scope of...

https://www.googleapis.com/auth/spreadsheets.readonly

 

And I have created an API key and a client ID

 

Anyway there seems to be alot of different things to cram into one web service action in WinAutomation... so any ideas?


Best Answer

Hi Jon


Thank you for getting in contact with us.


Please note that google APIs seem to be no different than a normal HTTP REST API service.

As discussed in the ticket you posted, please refer to relevant api documenation regarding any web services.


Thank you and best Regards!

1 Comment

ADMIN
Answer

Hi Jon


Thank you for getting in contact with us.


Please note that google APIs seem to be no different than a normal HTTP REST API service.

As discussed in the ticket you posted, please refer to relevant api documenation regarding any web services.


Thank you and best Regards!

Login or Signup to post a comment