Question

My Google Sheets syncs sometimes result in no data in the warehouse.

Environment

Connector: Google Sheets

Answer

• Equation running on the sheet: You will need to review and update the equation to prevent the data from being erased on the sheet.

Causes

Fivetran calls the Google Sheet API at the time of the sync schedule, and we sync the data based on the API response. When Google responds with an empty range, we delete data from the warehouse. This can occur due to:

• Equation running on the sheet: An equation can periodically erase the sheet data. This results in an empty range.