We now skip the
_fivetran_synced column if it is exist in the source Google Sheet. We use this name for the system column that keeps track of when each row was last successfully synced.
Fivetran no longer uses the
_fivetran_deleted column. During each sync, we now delete all the data in each table and re-pull all its contents. This change means that deleted data will be absent from the destination instead of being marked as deleted in the
Fivetran now fetches unformatted data from the Google Sheets API for new connectors. For example, if
=A1 and formatted as currency, then
A2 would return the number
Moving forward, Fivetran will only sync the named range to the destination when changes are detected. You can track your syncs on the Connection Details page of your Fivetran dashboard. The "Last Synced Changes (UTC)" field will show when your data was last synced to the destination.