Generate Ambassador Submissions CSV and Reviewer Sheets #39

	name: Generate Ambassador Submissions CSV and Reviewer Sheets

	on:
	workflow_dispatch:

	permissions:
	contents: write

	jobs:
	export-submissions:
	runs-on: ubuntu-latest

	steps:
	- name: 📥 Checkout repository
	uses: actions/checkout@v3

	- name: 🐍 Set up Python
	uses: actions/setup-python@v4
	with:
	python-version: '3.10'

	- name: 📦 Install Python dependencies
	run: \|
	pip install PyGithub openpyxl pandas

	- name: 🧠 Run extraction + reviewer script
	env:
	GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
	GITHUB_REPOSITORY: ${{ github.repository }}
	run: python .github/scripts/extract_submissions.py

	- name: ✅ Commit and Push Submissions and Reviewer Sheets
	run: \|
	git config --global user.email "[email protected]"
	git config --global user.name "GitHub Actions"
	git add "ambassador/*.csv"
	git add "ambassador/*.xlsx"
	git add "ambassador/reviewer_sheets_excel/*.xlsx"
	git commit -m "Update Ambassador Submissions and Reviewer Sheets (CSV + Excel)" \|\| echo "Nothing to commit"
	git push

Provide feedback