Function for reading Google Sheets open to public

read_public_sheets.py

from io import BytesIO
import requests
import pandas as pd

def read_public_sheets(file_url: str) -> pd.DataFrame:
    """Read a publicly available Google Sheets file as a Pandas Dataframe.

    Parameters
    ----------
    file_url : str
        URL adress to the spreadsheet CSV file.

    Returns
    -------
    pd.DataFrame
        Dataframe loaded from the CSV adress.

    """
    response = requests.get(file_url)
    return pd.read_csv(BytesIO(response.content))