news_and_events_update.yml

name: Update News and Agenda

on:
  schedule:
    - cron: '40 11 * * *' #'0 0 * * 1,4' #   --  Runs at 00:00 UTC on Tuesday and Friday

jobs:
  build:
    runs-on: ubuntu-latest
    steps:

      - name: checkout repo content
        uses: actions/checkout@v3 # checkout the repository content

      - name: setup python
        uses: actions/setup-python@v4
        with:
          python-version: '3.10' # install the python version needed

      - name: install python packages
        run: |
          python -m pip install --upgrade pip
          pip install --quiet gspread pandas oauth2client
          pip install pyarrow

      - name: execute py script 
        env:
          GOOGLE_SHEET_ID: 1WKRWIkQ5qqr5caCEl5yaeHHuzDv_yF0fGpQs9dvBTgk
          API_KEY: ${{ secrets.GOOGLE_SHEETS_API_KEY }}
          GOOGLE_SHEETS_CREDS: ${{ secrets.GOOGLE_SHEETS_CREDS }}
        run: python news_and_events_update.py

      - name: commit files
        run: |
          git config --local user.email "valentina.pasqual2@unibo.it"
          git config --local user.name "ValentinaPasqual"
          git add -A
          git diff-index --quiet HEAD || (git commit -a -m "updated logs" --allow-empty)

      - name: push changes
        uses: ad-m/github-push-action@v0.6.0
        with:
          github_token: ${{ secrets.BOLDH_TOKEN }}
          branch: main