Google API Returns Internal Error 500

How to resolve when Google API returns an error. Google.Apis.Requests.RequestError Internal Error [500] ?

Avoid sending multiple requests for each record. Perform the below

  1. Build a datatable within UiPath of the data needed to be output from the For Each loop
  2. Send to Google as a Write Range for limiting the server calls to avoid the write request quota limit.