Release Notes
November 2020
We have expanded the public API endpoints Create a Connector and Modify a Connector. Now you can authorize the following connectors by adding the auth section to payloads:
September 2020
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.
July 2020
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.
June 2020
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.
August 2019
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_deleted column.
Fivetran now fetches unformatted data from the Google Sheets API for new connectors. For example, if A1 is 1.23 and A2 is =A1 and formatted as currency, then A2 would return the number 1.23.
January 2019
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.