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!


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!

Please im stuck with this will someone help me? a waj file that can do it? thanks a lot!!


1 person likes this

Also stuck, a simple picture of the Invoke Web Service  Action Input parameters would be appreciated.

It turned out to be super simple as follows


Open the Google Sheet of interest.

Click on the SHARE (upper right green)

Click on "change" in the get link window

From the drop-down select "anyone with the link"

From the other drop-down (right side) select "Editor"

Now click on copy link and paste that link into the "Invoke Web Service" URL

Login or Signup to post a comment