Reading Google Sheet data using Gsuite Activity

Hi everyone,

I am lost and I don’t know what to do anymore.

I am trying to pull data from a google sheet and save it in a data table.

My set up is below:

For some reason I am getting a run time error after I execute the workflow.

Can someone guide me though?

Thanks!

Hi,

First, can you check settings at ConfigureScopes (button) of GSuite application Scope?

Then, try to set FindFilesAndFolders activity just before RedRange in order to get exact SpreadshhetID, as the following document?

https://docs.uipath.com/activities/docs/gsuite-read-range

Regards,

Hi for my configure scope button I have

Hi,

For now, can you click auto-detect button, then try to check Spreadsheets checked?

Regards,

after trying the auto-detect button I’m getting this error

Hi,

It means there lacks permission to access it.
Perhaps you should check your OAuth settings in Google side.

Regards,