Скачать или смотреть Using Github for free ETL pipeline

🧩 Project: Free Automated ETL Data Pipeline Using GitHub & Google Sheets

Description:
Built a fully automated ETL (Extract, Transform, Load) pipeline using open-source and free cloud resources.
The goal was to automate data extraction, transformation, and delivery without any recurring cost.

Implementation Steps:

Set up a free AWS EC2 instance as a lightweight cloud server.

Installed MySQL for data storage and management on AWS instance.

Configured WireGuard VPN to ensure secure, encrypted connections.

Developed a Python script hosted on GitHub for data extraction, manipulation, and transformation.

Integrated a Google Service Account to push processed data directly into Google Sheets for visualization and reporting.

Key Highlights:
✅ Fully automated and cloud-based
✅ Runs continuously (24/7 uptime)
✅ Zero infrastructure cost
✅ Ideal for learning ETL, data automation, and analytics integration

Outcome:
Successfully built and deployed a no-cost ETL data pipeline — demonstrating how analysts can leverage free tools to automate workflows and gain hands-on experience with data engineering concepts.

Github:https://github.com/sazidshihab/ETL-Automat...