Extract and Deduplicate Ambassador Applications #16

	name: Extract and Deduplicate Ambassador Applications

	on:
	workflow_dispatch:

	permissions:
	contents: write

	jobs:
	summarize:
	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.x'

	- name: 📦 Install Dependencies
	run: pip install PyGithub openpyxl

	- name: 🧠 Run Extraction + Deduplication Script
	env:
	GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
	GITHUB_REPOSITORY: ${{ github.repository }}
	run: python .github/scripts/summarize_applications.py

	- name: ✅ Commit and Push Results
	run: \|
	git config --global user.email "[email protected]"
	git config --global user.name "GitHub Actions"
	git add ambassador/submissions_all.csv ambassador/submissions_deduped.csv ambassador/submissions_duplicates.xlsx \|\| true
	git commit -m "Update extracted and deduplicated ambassador application data" \|\| echo "No changes to commit"
	git push

Provide feedback