import pandas as pd
import logging

logger = logging.getLogger(__name__)

def load_and_merge_google_sheets(sheet_urls):
    """Fetch and merge data from multiple Google Sheets."""
    merged_data = pd.DataFrame()
    for i, sheet_url in enumerate(sheet_urls):
        try:
            logger.info(f"Fetching data from Google Sheet {i+1}...")
            data = pd.read_csv(sheet_url, low_memory=False)
            logger.info(f"Data from Google Sheet {i+1} loaded successfully.")
            merged_data = pd.concat([merged_data, data], ignore_index=True)
        except Exception as e:
            logger.error(f"Error loading data from Google Sheet {i+1}: {e}")
    return merged_data