sync-team-data.yml

name: Sync Team Data from Google Sheets

on:
  schedule:
    # Run daily at 2 AM UTC
    - cron: '0 2 * * *'
  workflow_dispatch:  # Allow manual trigger

jobs:
  sync-team-data:
    runs-on: ubuntu-latest
    
    steps:
    - name: Checkout repository
      uses: actions/checkout@v3
      with:
        token: ${{ secrets.GITHUB_TOKEN }}
    
    - name: Set up Python
      uses: actions/setup-python@v4
      with:
        python-version: '3.9'
    
    - name: Install dependencies
      run: |
        pip install google-auth google-auth-oauthlib google-auth-httplib2 
        pip install google-api-python-client PyYAML
    
    - name: Sync from Google Sheets
      env:
        SERVICE_ACCOUNT_KEY: ${{ secrets.SERVICE_ACCOUNT_KEY }}
      run: |
        # Debug: Check if secret is set
        if [ -z "$SERVICE_ACCOUNT_KEY" ]; then
          echo "Error: SERVICE_ACCOUNT_KEY secret is not set!"
          exit 1
        fi
        
        # Create service account key file from secret
        echo "$SERVICE_ACCOUNT_KEY" > service-account-key.json
        
        # Debug: Check file was created
        ls -la service-account-key.json
        
        # Run the sync script
        python sync_team_service_account.py
    
    - name: Check for changes
      id: verify-changed-files
      run: |
        git diff --quiet _data/*.yml || echo "changed=true" >> $GITHUB_OUTPUT
    
    - name: Commit and push if changed
      if: steps.verify-changed-files.outputs.changed == 'true'
      run: |
        git config user.name "GitHub Actions"
        git config user.email "actions@github.com"
        git add _data/*.yml
        git commit -m "Update team data from Google Sheets"
        git push