We simplified setup for our Google Sheets connector. We now only require the URL of the Google spreadsheet. You no longer need to identify the value between the “/d/” and the “/edit” in your spreadsheet URL when setting up new connectors.
We added a button to the setup form that allows you to check that the Service Account has access to the selected spreadsheet. Learn more about setting up in our Google Sheets connector documentation.
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.