Repository Overview¶
This section provides detailed documentation for each of the 6 Smartsheet integration repositories in the suite.
Repository Comparison¶
| Repository | Language | Type | Complexity | Best For |
|---|---|---|---|---|
| Supabase Smartsheet Promax Offload | Python | Data Sync | Medium | Database → Sheet sync |
| Smartsheet Supabase Sync | TypeScript | Data Sync | Medium | Sheet → Database sync |
| Master to Sibling | Python | Replication | Low | Sheet → Sheet copy |
| Generate Job Numbers | Python | Automation | Low | Auto-numbering |
| Generate Weekly PDFs | Python | Reporting | High | PDF generation |
| Resiliency PDF Restructure | Python | Validation | Medium | PDF validation |
By Use Case¶
Need to sync data between Smartsheet and a database?¶
Smartsheet → Supabase
TypeScript, GitHub Actions, scheduled runs
- Reads from Smartsheet
- Writes to Supabase PostgreSQL
- Runs on schedule via GitHub Actions
Supabase → Smartsheet
Supabase Smartsheet Promax Offload
Python, manual/scheduled execution
- Queries Supabase database
- Bulk upserts to Smartsheet
- Handles large datasets
Need to replicate data between Smartsheet sheets?¶
Master-Sibling Pattern
Master to Sibling Smartsheet Function
Python, on-demand execution
- Copy from one master sheet
- Replicate to multiple sibling sheets
- Maintains data consistency
Need to automate job number assignment?¶
Job Numbering
Python, webhook/manual trigger
- Auto-assigns sequential job numbers
- Prevents duplicates
- Configurable starting number
Need to generate weekly PDF reports?¶
PDF Reporting
Generate Weekly PDFs DSR Resiliency
Python, weekly cron job
- Merges ProMax and Excel data
- Generates PDF per foreman
- Updates Smartsheet with links
Need to validate PDF structure?¶
PDF Validation
Resiliency PDF Restructure UG Work
Python, post-generation execution
- Validates PDF structure
- Extracts CU codes
- Updates validation status
Technology Breakdown¶
Python Repositories (5)¶
Python is the primary language for most integrations, chosen for: - Rich ecosystem of data processing libraries - Excellent Smartsheet SDK - Easy scripting and automation - Strong PDF manipulation capabilities
| Repository | Python Version | Key Libraries |
|---|---|---|
| Supabase Smartsheet Promax Offload | 3.9+ | smartsheet-python-sdk, supabase-py |
| Master to Sibling | 3.9+ | smartsheet-python-sdk |
| Generate Job Numbers | 3.9+ | smartsheet-python-sdk |
| Generate Weekly PDFs | 3.9+ | smartsheet-python-sdk, pandas, openpyxl, reportlab |
| Resiliency PDF Restructure | 3.9+ | smartsheet-python-sdk, PyPDF2, pdfplumber |
TypeScript Repository (1)¶
TypeScript powers the GitHub Actions workflow:
| Repository | Node Version | Key Libraries |
|---|---|---|
| Smartsheet Supabase Sync | 16+ | @supabase/supabase-js, axios, dotenv |
Deployment Patterns¶
GitHub Actions (Serverless)¶
- Smartsheet Supabase Sync
- No infrastructure needed
- Runs on schedule
- Uses GitHub secrets
Cron Jobs (Server)¶
- Generate Weekly PDFs
- Resiliency PDF Restructure
- Scheduled execution
- Requires server/VM
- Uses systemd or crontab
On-Demand (Manual/Webhook)¶
- Supabase Smartsheet Promax Offload
- Master to Sibling
- Generate Job Numbers
- Triggered by events
- Can be manual or automated
- Flexible execution
Repository Details¶
Explore each repository for comprehensive documentation:
Data Synchronization¶
- Supabase Smartsheet Promax Offload
- Database to Smartsheet sync
- Bulk operations
-
Python-based
- Smartsheet to database sync
- GitHub Actions workflow
- TypeScript-based
Data Replication¶
- Master to Sibling Smartsheet Function
- Sheet-to-sheet replication
- Master-sibling pattern
- Python-based
Automation¶
- Generate Job Numbers
- Automated job numbering
- Duplicate prevention
- Python-based
Reporting & Validation¶
- Generate Weekly PDFs DSR Resiliency
- Weekly PDF generation
- ProMax and Excel integration
-
Python-based
- PDF structure validation
- CU code extraction
- Python-based
Common Patterns¶
All repositories share these characteristics:
Configuration¶
- Environment variables via
.envfiles - Separate configs for dev/staging/production
- Secure API token management
Error Handling¶
- Retry logic for API failures
- Comprehensive logging
- Graceful failure modes
Scalability¶
- Batch processing for large datasets
- Rate limit awareness
- Efficient API usage
Maintainability¶
- Clear code structure
- Documentation
- Example configurations
Getting Started¶
- Choose Your Repository: Based on your use case above
- Read the Docs: Click through to detailed repository pages
- Follow Setup: Each page has setup instructions
- Test First: Use dry-run mode before production
- Monitor: Set up logging and monitoring
Quick Links¶
- Master Index - Complete catalog
- Usage Guide - Setup instructions
- Smartsheet Integration - Data flows
- Troubleshooting - Common issues
Ready to dive deeper?
Select a repository above to see detailed documentation, code examples, and configuration guides.