# BigQuery to Google Sheets Data Pipeline

> Implemented a robust data pipeline using SyncWith and SQL to extract and sync data from BigQuery to Google Sheets for real-time analytics and reporting.

Section: Google Apps Script

Page: https://mburhan.com/case/gas-bigquery-to-google-sheets-data-pipeline

## Project Overview

This project uses SyncWith and SQL to extract and synchronize data from BigQuery to Google Sheets, supporting analytics and reporting.

**Technology:** Google Apps Script, BigQuery, Google Sheets, SQL, SyncWith

## 01. The Solution

A data pipeline was implemented using SQL queries and SyncWith to retrieve data from BigQuery and sync it into Google Sheets for reporting.

## 02. How It Works

- Query data in BigQuery using SQL.
- Join employer and sign-up data by month.
- Schedule the query to support regular KPI reporting.
- Sync the resulting data to Google Sheets.

## 03. Workflow

Image (https://mburhan.com/uploads/5f6044dc57ed42f4c9e276e5.png)

## 04. Implementation

The SQL query shown in the screenshot groups records by year and month and joins employer and sign-up data for KPI reporting.

Image: A scheduled BigQuery SQL query joining employer and sign-up data by month for the KPI sheet. (https://mburhan.com/case-content/google-apps-script-portfolio/image4.png)

## 05. Outcome

The pipeline supports synchronized data reporting from BigQuery to Google Sheets, helping make KPI data available for analytics.
