main.yml

name: Update Google Sheets

on:
  workflow_dispatch:
  schedule:
    - cron: '*/5 1-11 * * *'
    # `*/10 3-11 * * 1-5` runs at every 10th minute past every hour from 8:30 through 4:30 IST on every day-of-week from Monday through Friday
    # Note: 8:30 to 4:30 in IST is 3-11 for UTC

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

      - name: Checkout repository content
        uses: actions/checkout@v3

      - name: Setup Python Version
        uses: actions/setup-python@v4
        with:
          python-version: '3.10' 
          cache: 'pip'
          # cache-dependency-path: '**/requirements.txt'
      - name: Install Python dependencies
        run: pip install -r requirements.txt
      - name: Execute Python script
        env:
          CRED: ${{ secrets.SERVICE_ACCOUNT }}
          WB: ${{ secrets.WORKBOOK_NAME }}
          WKS: ${{ secrets.WORKSHEET_NAME }}
        run: python main_g.py