This post walks through the serverless ETL pipeline I built using Google Cloud Functions that takes a Monefy CSV export from Google Drive and loads it into a BigQuery table for analysis. It’s a configuration-driven, event-based system that automatically processes files uploaded to Google Drive, parses the data and loads it into BigQuery.

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!