survey-extraction/.github/workflows/hubspot_to_invoice.yml

# name: HubSpot Deals to DB loading and Invoice Calculator
# on:
#   # schedule:
#   #   - cron: '0 19 * * 0'
#   workflow_dispatch:

# jobs:
#   hubspot-deals-to-db:
#     runs-on: ubuntu-22.04
#     steps:
#       - uses: actions/checkout@v3

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

#       - name: Install dependencies
#         run: |
#           pip install poetry
#           poetry install --no-root

#       - name: run script
#         run: |
#           pwd
#           ls -la
#           poetry run python etl/hubspot_to_invoice_rewrite.py
#         env:
#           PYTHONPATH: ${{ github.workspace }}
#           DATABASE_URL: postgresql://postgres:makingwarmhomes@terraform-20250331175522503500000002.cdgzupxvdyp0.eu-west-2.rds.amazonaws.com:5432/surveyDB
#           SOUTH_COAST_INSULATION_SERVICE_SHAREPOINT_ID: ${{ secrets.SOUTH_COAST_INSULATION_SERVICE_SHAREPOINT_ID }}
#           JJC_SERVICE_SHAREPOINT_ID: ${{ secrets.JJC_SERVICE_SHAREPOINT_ID }}
#           BAXTER_KELLY_SERVICE_SHAREPOINT_ID: ${{ secrets.BAXTER_KELLY_SERVICE_SHAREPOINT_ID }}
#           SGEC_SERVICE_SHAREPOINT_ID: ${{ secrets.SGEC_SERVICE_SHAREPOINT_ID }}
#           SHAREPOINT_CLIENT_ID: ${{ secrets.SHAREPOINT_CLIENT_ID }}
#           SHAREPOINT_CLIENT_SECRET: ${{ secrets.SHAREPOINT_CLIENT_SECRET }}
#           SHAREPOINT_TENANT_ID: ${{ secrets.SHAREPOINT_TENANT_ID }}