data_loader.py

import pandas as pd
from dotenv import load_dotenv
import os

load_dotenv()

SHEET_ID = os.getenv("SHEET_ID")
SHEET_NAME = os.getenv("SHEET_NAME")
url = f"https://docs.google.com/spreadsheets/d/{SHEET_ID}/gviz/tq?tqx=out:csv&sheet={SHEET_NAME}"

def load_data():
    return pd.read_csv(url)