name: Sync Meta Ads Data

on:
  schedule:
    - cron: "0 1 * * *"   # UTC 01:00 = 北京时间 09:00
  workflow_dispatch:
    inputs:
      days_back:
        description: "拉取最近几天的数据"
        required: false
        default: "7"

jobs:
  sync:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v4

      - uses: actions/setup-python@v5
        with:
          python-version: "3.12"

      - name: Install dependencies
        run: pip install requests pandas gspread google-auth pyyaml python-dotenv openpyxl

      - name: Sync Meta data to Google Sheets
        env:
          META_ACCESS_TOKEN: ${{ secrets.META_ACCESS_TOKEN }}
          META_AD_ACCOUNTS: ${{ secrets.META_AD_ACCOUNTS }}
          GOOGLE_OAUTH_REFRESH_TOKEN: ${{ secrets.GOOGLE_OAUTH_REFRESH_TOKEN }}
          GOOGLE_OAUTH_CLIENT_ID: ${{ secrets.GOOGLE_OAUTH_CLIENT_ID }}
          GOOGLE_OAUTH_CLIENT_SECRET: ${{ secrets.GOOGLE_OAUTH_CLIENT_SECRET }}
        run: |
          python -c "
          import sys, os, logging
          sys.path.insert(0, '.')
          logging.basicConfig(level=logging.INFO, format='%(asctime)s %(message)s')

          from src.meta_api import fetch_meta_data
          from src.loader import write_api_data_to_sheets

          days = int('${{ github.event.inputs.days_back || 7 }}')
          print(f'Fetching Meta data (last {days} days)...')
          df = fetch_meta_data(days_back=days)

          if df.empty:
              print('No data fetched.')
              sys.exit(0)

          print(f'Fetched {len(df)} rows, date range: {df[\"date\"].min()} ~ {df[\"date\"].max()}')
          result = write_api_data_to_sheets(df)
          print(f'Written to Sheets: {result[\"added\"]} new rows')
          "