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.
Comments
0 comments
Please sign in to leave a comment.