Fix Google Sheets Internal Error 500 in Skyvia

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.

Useful Links

    • Related Articles

    • Zoho CRM: invalid_code Login Error

      Overview If you encounter the error "An error occurred during login operation. Error: invalid_code" while connecting to Zoho CRM in Skyvia, it means the wrong Domain is selected in your Zoho CRM connection settings. Resolution Open your Zoho CRM ...

    • Mapping the RowNo Column for UPDATE/UPSERT Operations in Google Sheets

      Overview When performing UPDATE or UPSERT operations on Google Sheets data in Skyvia, the RowNo field is mandatory. RowNo is a unique auto-generated row number assigned to each row in the sheet. Skyvia uses it to identify which row to update. Without ...

    • Salesforce Connect: Can't Sync Schema Metadata (Error Code: Null)

      Overview This error occurs because the object used in your endpoint does not have a primary key column. Salesforce requires a primary key for external objects, which is why you encounter an error when validating and syncing your External Data Source ...

    • PostgreSQL: A call to SSPI failed, see internal exception

      Overview The error "A call to SSPI failed, see internal exception" indicates that the security protocol (SSL/TLS) used in your PostgreSQL connector does not match the version supported by your server. Resolution Try different SSL/TLS protocol ...

    • Zoho CRM: Inactive User Cannot Access the API Error

      Overview This error is returned by the Zoho CRM API. Skyvia connects to data sources through their APIs and is subject to their features and limitations. Unfortunately, there are no additional details available beyond what their API returns. ...