Refresh project workbook #9

	name: Refresh project workbook

	on:
	workflow_dispatch:
	push:
	paths:
	- "sources/**"
	- "pipeline/**"
	- ".github/workflows/refresh-project-workbook.yml"
	schedule:
	- cron: "0 13 * * 1"

	permissions:
	contents: write

	concurrency:
	group: refresh-project-workbook
	cancel-in-progress: true

	jobs:
	refresh:
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v4

	- uses: actions/setup-python@v5
	with:
	python-version: "3.11"

	- name: Refresh workbook computed columns
	env:
	GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
	run: python3 pipeline/fetch.py

	- name: Commit workbook changes
	run: \|
	git config user.name "github-actions[bot]"
	git config user.email "github-actions[bot]@users.noreply.github.com"
	git add sources/Public\ Invention\ Projects.xlsx
	if git diff --staged --quiet; then
	echo "No workbook changes."
	else
	git commit -m "chore: refresh project workbook"
	git push
	fi

Navigation Menu