generate-data-member.yml

name: Generate Data Member in Json
on:
  push:
    branches: [master]
  workflow_dispatch:

jobs:
  generate_data_member:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v3
      - name: Download csv file of member form in gsheet
        run: |
          curl -L -o ./scripts/dataMember.csv https://docs.google.com/spreadsheets/d/1SaXnuRt-1KXyDGS18KqU7cus4_IWNxpGhiVy0J1vz-U/export?format=csv
      - name: run python script to convert csv to json
        run: |
          cd ./scripts
          python script.py
          git checkout -b production
          cp ./dataMember.json ../data/dataMember.json
          cd ..
          rm -rf ./scripts
          git add ./data/dataMember.json
          
       # Commit the changes
      - name: Commit changes
        run: |
          git config --local user.email "action@github.com"
          git config --local user.name "GitHub Action"
          git commit -m "Update data member from GitHub Action" || true

      # Push the changes back to the repository
      - name: Push changes
        uses: ad-m/github-push-action@master
        with:
          github_token: ${{ secrets.GITHUB_TOKEN }}