G2

Jose Maria P.

Business Operations Analyst

Enterprise (> 1000 emp.)

7/21/2026

"Fast, Reliable No-Code Data Integrations with Huge ROI"

4.5/5

What do you like best about Fivetran?

I use Fivetran regularly to manage our data integrations, especially connecting Google Sheets with our warehouse. One major issue we had was operations staff deleting sheet rows; Fivetran solved this instantly by automatically providing the _fivetran_deleted boolean column, giving us full historical visibility.

The UI/UX is intuitive and clean, making setup completely no-code. In terms of performance, syncs are fast, reliable, and handle automatic schema changes effortlessly. The support and onboarding experience was smooth with clear documentation. Overall, the ROI is massive because it saves our engineering team hours of manual pipeline work each week, and the automated metadata scheduling almost feels like having built-in intelligence monitoring our data integrity! Review collected by and hosted on G2.com.

What do you dislike about Fivetran?

One thing I dislike is how Fivetran handles column ordering during syncs, particularly with Google Sheets connectors. It doesn't preserve the original column order from the source sheet, often reorganizing them alphabetically or dynamically in the destination table. While it doesn't break the data itself, it makes quick manual checks and SQL queries slightly annoying when you expect columns in the same layout as the source. Additionally, the pricing can scale up quickly if you have high-volume tables with frequent updates. Review collected by and hosted on G2.com.

What problems is Fivetran solving and how is that benefiting you?

Fivetran solves the major problem of data silos and manual ETL pipeline maintenance. By seamlessly connecting sources like Google Sheets, Zoho CRM, and Google Drive directly into our data warehouse, it centralizes our data automatically while keeping sync speeds fast and reliable.

One feature I absolutely love is its ability to merge and unify multiple CSV files uploaded to Google Drive into a single target table automatically. This eliminates manual file stitching and saves tons of time. Furthermore, system columns like _fivetran_synced and _fivetran_deleted give us full visibility, allowing us to track exactly when data was updated and know if any rows were deleted in source systems. Ultimately, it radically simplifies our data operations, saving engineering hours and letting us focus directly on running analytics and generating business insights. Review collected by and hosted on G2.com.