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 ...

    • QuickBooks Online: The name supplied already exists error

      Overview The error "The name supplied already exists. Another customer, vendor, or employee is already using this name" is a limitation returned directly from QuickBooks. It occurs when the Display Name you are trying to create already exists in ...