This post walks through a serverless ETL pipeline I built on Google Cloud that automatically processes CSV files from a specific Google Drive folder and loads them into a BigQuery table for analysis. It’s a secure, configuration-driven, and event-based system that requires zero manual intervention once deployed.

WhatsApp is one of the most popular messaging apps in the world, with over 2 billion active users. It’s no surprise that many people want to analyse their WhatsApp data to gain insights into their conversations, including myself! In this post, I’ll detail how I used Python and BigQuery to analyze my WhatsApp data, covering everything from parsing the raw TXT export to visualizing the data. Let’s get started!