PRO SOW GPT

Automated Statement of Work (SOW) generation workflow for PRO suite.

Overview

This repository contains the workflow automation for generating PRO SOW documents, including:

• Google Apps Script integration
• YAML-based workflow configuration
• Automated data extraction from Excel calculators
• API integration for SOW payload submission

Repository Structure

PRO_SOW_GPT/
├── google_apps_script.gs          # Google Apps Script main file
├── pro_sow_gpt_manifest.yaml      # Workflow manifest configuration
├── pro_sow_gpt_action.yaml        # API action definitions
├── pro_sow_gpt_global_intructions.txt  # Global instructions
├── setup_github.py                # GitHub setup script
├── github_integration.py          # GitHub API helper
└── README.md                      # This file

GitHub Integration Setup

Prerequisites

1. Install Git

   • Download from: https://git-scm.com/download/win
   • Or use: winget install Git.Git

2. Create a GitHub Personal Access Token

   • Go to: https://github.com/settings/tokens
   • Click "Generate new token (classic)"
   • Select scopes: repo (full control of private repositories)
   • Copy the token (you'll need it for setup)

Quick Setup

1. Run the setup script:

   python setup_github.py

2. Or manually set up:

   # Initialize Git repository
   git init
   
   # Configure Git user
   git config user.name "surajdeval"
   git config user.email "your-email@example.com"
   
   # Add remote repository
   git remote add origin https://github.com/surajdeval/PRO_SOW_GPT.git
   
   # Create initial commit
   git add .
   git commit -m "Initial commit: PRO SOW GPT workflow"
   
   # Push to GitHub (you'll be prompted for credentials)
   git push -u origin main

Using GitHub Token

Option 1: Environment Variable

# Windows PowerShell
$env:GITHUB_TOKEN = "your_token_here"

# Windows CMD
set GITHUB_TOKEN=your_token_here

Option 2: Token File Create a file named .github_token in the project root:

your_token_here

Option 3: Pass to Script

python github_integration.py
# Enter token when prompted

Verify Integration

Run the GitHub integration helper:

python github_integration.py

This will:

• Verify your GitHub token
• Display your GitHub profile information
• Check if the repository exists
• Optionally create the repository if it doesn't exist

Workflow Files

pro_sow_gpt_manifest.yaml

Defines the workflow steps for SOW generation, including:

• Data extraction from Excel files
• JSON payload construction
• Use case generation
• API submission

pro_sow_gpt_action.yaml

OpenAPI specification for the SOW payload submission endpoint.

google_apps_script.gs

Google Apps Script for Google Sheets integration and automation.

Usage

1. Ensure all dependencies are installed
2. Configure your Google Apps Script credentials
3. Set up API endpoints as specified in pro_sow_gpt_action.yaml
4. Run the workflow through your automation platform

Contributing

1. Create a feature branch
2. Make your changes
3. Commit with descriptive messages
4. Push to GitHub
5. Create a pull request

License

[Add your license information here]

Contact

• GitHub: @surajdeval
• Repository: https://github.com/surajdeval/PRO_SOW_GPT

Notes

• Keep your GitHub token secure and never commit it to the repository
• The .gitignore file excludes sensitive files and backup directories
• Backup directories (bkup_*/) are excluded from version control