Get Sheets: The caller does not have permission [403]

Could anyone in the forum help with this error??

RemoteException wrapping Google.GoogleApiException: The caller does not have permission [403]
at Google.Apis.Requests.ClientServiceRequest1.<ParseResponse>d__35.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Google.Apis.Requests.ClientServiceRequest1.d__31.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.GSuite.Sheets.Services.SheetsServiceProxy.<>c__DisplayClass24_0.<b__0>d.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Shared.TelemetryService.NullTelemetryService.d__11.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.GSuite.Sheets.Services.SheetsServiceProxy.d__24.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.GSuite.Activities.GetSheets.d__16.MoveNext()
— End of stack trace from previous location where exception was thrown —
at UiPath.Shared.Activities.AsyncTaskCodeActivityImplementation.EndExecute(AsyncCodeActivityContext context,
IAsyncResult result)
at UiPath.Shared.Activities.AsyncTaskCodeActivity.EndExecute(AsyncCodeActivityContext context,
IAsyncResult result)
at UiPath.Shared.Activities.ContinuableAsyncCodeActivity.EndExecute(AsyncCodeActivityContext context,
IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context,
IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor,
BookmarkManager bookmarkManager)

@SAMANTA_COTTACKAL1

As per error you might not have the permissions on the drive where sheet is present as you are getting sheetid

Cheers

Hi @Anil_G ,

I am the owner of the google sheet mentioned here.

@SAMANTA_COTTACKAL1

As I said the place where it is created there might be other sheets also…so please check the prent access

Cheers

@Anil_G How to know whether we ahve access to the folder of not? The owner is a different person. Is there a way i can check that

Hi @SAMANTA_COTTACKAL1

Check out this thread. This might help you.

Regards

@SAMANTA_COTTACKAL1

Are you able to access all the sheet in it? and have edit permissions
you can check the folder access by goign to properties…please ask the admin to share the access

chers

Hi @Anil_G / Team,

The owner has replied that I am provided with completed folder edit access. But still, I am facing this issue.

image

Hi @SAMANTA_COTTACKAL1

Please check on below post

Hope this helps!!

@SAMANTA_COTTACKAL1

As per message i see you git edit access for files only but not the folder

Cheers

I confirmed with the user and they tell that in both prod and UAT, I have been given direct edit access

@Anil_G PFA

Current error:

RemoteException wrapping Google.GoogleApiException: The caller does not have permission [403]
at System.Activities.Statements.Throw.Execute(CodeActivityContext context)
at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance,
ActivityExecutor executor,
BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor,
BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor,
BookmarkManager bookmarkManager,
Location resultLocation)

@SAMANTA_COTTACKAL1

On Sheet you have edit access?

or on the drive where the sheet is present?

you need the second one,…you should be able to view or edit all the sheets in the drive but not only the one you need…as you are using get sheets

cheers

Hi @Anil_G ,

Yes, I do have access to all files in the drive.

@SAMANTA_COTTACKAL1

In thescope can you try with only the spreadsheet relatedscopes please

Cheers

Hi @Anil_G ,

when i give the path to other locations, say Smartsheet / Microsoft etc, the output file get written there as expected, but not in the folder ‘Lucid Software’

image