I built an automated CRM

I built an automated CRM data pipeline that syncs Pipedrive data into Google BigQuery, cleans it, prevents duplicates, and prepares it for advanced reporting in Looker Studio. The goal was to eliminate: Manual exports Inconsistent deal data Duplicate records Broken reporting logic ⚙️ Tech Stack Pipedrive API n8n (API orchestration & pagination) Google BigQuery (Data Warehouse) dbt (Data modeling) Looker Studio (Reporting layer)