update_spreadsheet.yml

name: Update spreadsheet

concurrency:
  group: ${{ github.workflow }}-${{ github.ref }}
  cancel-in-progress: true

on:
  push:
    branches: [ main ]

  # to trigger update manually from the Action tab in github
  workflow_dispatch:
    inputs:
      log:
        description: "convert spreadsheet"
        required: false

jobs:
  update_spreadsheet:

    runs-on: ubuntu-latest

    if: github.repository_owner == 'INCF'

    steps:
    - name: Checkout repository
      uses: actions/checkout@v4

    - name: Set up Python
      uses: actions/setup-python@v5
      with:
        python-version: 3.9

    - name: Install dependencies
      run: |
        python -m pip install --upgrade pip setuptools
        make install

    - name: Convert table
      run: make convert

    # if there have been changes,
    # a PR is created using the checkout branch for this workflow
    # https://github.com/peter-evans/create-pull-request
    - name: Create Pull-Request
      uses: peter-evans/create-pull-request@v6
      with:
        commit-message: Update spreadsheets
        delete-branch: true
        title: 'MNT: Update spreadsheets'