G Suite: Requested Entity Was Not Found

News Knowledge Base
1

How to resolve the error received while trying to access Google Sheets GSuite activities, when reading or writing data in sheets is not permitted? Error Message: Requested entity not found

Issue Description:
How to resolve the error received while trying to access Google Sheets GSuite activities, when reading or writing data in sheets is not permitted?

Error Message:
“Requested entity not found”

Resolution:
The error Requested entity was not found is a response that is received from the Google API servers when the details like Sheet ID, Spreadsheet ID etc do not match with any of the entities(sheets) available under the target Google account.

Verify the SpreadsheetID (Document ID) value along with the SheetName value. Also, ensure that the provided value is the same as the on available in the sheet URL.(Below for reference)

https://docs.google.com/spreadsheets/d/spreadsheetId/edit#gid=0

If all of these configurations are correct, try to use the same API(Write Range/Read Range) from Postman and compare the two. Refer to the following document on Google Sheets API endpoints.

Also, within the Google Cloud Console, select the desired project and enable all required scopes. For Google Sheets, mandatory to enable:

  • https://www.googleapis.com/auth/spreadsheets.readonly for read access.
  • https://www.googleapis.com/auth/spreadsheets for write and read access.

Contact UiPath Product Support: If the issue persists, create UiPath Support Ticket for further troubleshooting.

Ensure to provide/attach the below list of details in the new ticket:

  1. Google API Permissions screenshot.
  2. Please share the event viewer logs (ETVX Logs) upon reproducing the issue.