data-refresh.yml

name: Refresh Volumes

on:
    schedule:
        - cron: '0 0 * * 0' # Runs every Sunday at midnight UTC. You can customize the schedule using cron syntax.
    workflow_dispatch: # This allows manual triggering from the GitHub Actions UI.

jobs:
    refresh:
        runs-on: ubuntu-latest

        steps:
            - name: Checkout code
              uses: actions/checkout@eef61447b9ff4aafe5dcd4e0bbf5d482be7e7871 # v4

            - name: Setup Node.js
              uses: actions/setup-node@v4
              with:
                node-version-file: '.nvmrc'

            - name: Setup pnpm
              uses: pnpm/action-setup@v3
              with:
                  run_install: true

            - name: Refresh Radar Datasets
              env:
                GOOGLE_SHEET_ID: ${{ vars.GOOGLE_SHEET_ID }}
                GOOGLE_CLIENT_EMAIL: ${{ secrets.GOOGLE_CLIENT_EMAIL }}
                GOOGLE_PRIVATE_KEY: ${{ secrets.GOOGLE_PRIVATE_KEY }}
              run: |
                  export GOOGLE_SHEET_ID=$GOOGLE_SHEET_ID
                  export GOOGLE_CLIENT_EMAIL=$GOOGLE_CLIENT_EMAIL
                  export GOOGLE_PRIVATE_KEY=$GOOGLE_PRIVATE_KEY
                  pnpm start

            - name: Create Pull Request
              uses: peter-evans/create-pull-request@v7
              with:
                  token: ${{ secrets.GITHUB_TOKEN }}
                  commit-message: |
                    Automated dataset refresh
                  branch: automated/volume-updates
                  delete-branch: true
                  title: "Radar Volumes Refresh"
                  body: |
                    Refresh technology radar datasets from latest sources.
                  labels: |
                    data-refresh
                  reviewers: setchy