Google Sheets: Internal error encountered. Error code: 500
Overview
The error "Internal error encountered. Error code: 500" is returned by the Google Sheets API and is typically caused by processing a large volume of data in a single request.
Resolution
To resolve this issue, reduce the Batch Size value in your integration settings. For example, set it to 500:
You may also try other values to find the optimal setting for your specific scenario.
After updating the Batch Size, run your integration again and check if the issue is resolved.