Skip to content

Master Repository Index

This comprehensive index provides an overview of all Smartsheet integration repositories, their relationships, and data flows.

Repository Catalog

Active Repositories

Repository Language Description GitHub Last Updated
Supabase Smartsheet Promax Offload Python 94.7% Offloads data from Supabase database to Smartsheet sheets. Handles bulk upsert operations with retry logic. View Repo 2025
Smartsheet Supabase Sync TypeScript 40.5% GitHub Actions workflow that syncs data from Smartsheet to Supabase on a schedule. View Repo 2025
Master to Sibling Smartsheet Python 100% Replicates data from a master Smartsheet to multiple sibling sheets. Maintains data consistency across sheets. View Repo 2026
Generate Job Numbers Python 100% Automatically assigns job numbers to Smartsheet rows. Prevents duplicates and handles incremental numbering. View Repo 2025
Generate Weekly PDFs DSR Python 98.9% Generates weekly PDF reports for each foreman from ProMax data. Integrates Excel data and updates Smartsheet. View Repo 2025
Resiliency PDF Restructure Python 66% Validates PDF structure and extracts CU codes. Updates Smartsheet with validation results. View Repo 2025

Cross-Reference Matrix

This matrix shows the data flow and dependencies between repositories:

From / To Supabase Smartsheet Master Smartsheet Siblings PDFs ProMax
Smartsheet ✅ SSS Sync - ✅ MSS Copy - -
Supabase - ✅ SPS Offload - - -
ProMax ERP - - - ✅ GPF Generate -
Excel Files - - - ✅ GPF Process -
PDF Validator - ✅ RPR Update - ⬅️ RPR Read -
Job Generator - ✅ GJN Assign - - -

Legend: - ✅ = Active data flow - ⬅️ = Read operation - ➡️ = Write operation - SSS = Smartsheet-Supabase-Sync - SPS = Supabase-Smartsheet-Promax-Offload - MSS = Master-to-Sibling-Smartsheet - GJN = Generate-Job-Numbers - GPF = Generate-Weekly-PDFs - RPR = Resiliency-PDF-Restructure

Integration Flow Diagram

sequenceDiagram
    participant SS as Smartsheet
    participant SB as Supabase
    participant PM as ProMax
    participant EX as Excel
    participant PDF as PDFs

    Note over SS,PDF: Daily Operations

    SS->>SB: SSS: Scheduled sync (GitHub Actions)
    Note right of SB: TypeScript GitHub Action<br/>Reads Smartsheet data<br/>Upserts to Supabase

    SB->>SS: SPS: Offload data back
    Note right of SS: Python Script<br/>Bulk upsert from DB<br/>Updates multiple sheets

    SS->>SS: MSS: Master to sibling copy
    Note right of SS: Python Script<br/>Replicates master data<br/>to dependent sheets

    SS->>SS: GJN: Assign job numbers
    Note right of SS: Python Script<br/>Auto-increment numbering<br/>Prevents duplicates

    Note over SS,PDF: Weekly Reports

    PM->>PDF: GPF: Export weekly data
    EX->>PDF: GPF: Merge Excel data
    PDF->>SS: GPF: Update with PDF links
    Note right of SS: Python Script<br/>Generate foreman PDFs<br/>Store until Sunday

    PDF->>SS: RPR: Validate & update
    Note right of SS: Python Script<br/>Extract CU codes<br/>Verify structure

Repository Quick Access

By Function

Data Synchronization

Automation & Processing

By Technology

Python Repositories (5)

  1. Supabase Smartsheet Promax Offload
  2. Master to Sibling Smartsheet Function
  3. Generate Job Numbers
  4. Generate Weekly PDFs DSR Resiliency
  5. Resiliency PDF Restructure UG Work

TypeScript Repositories (1)

  1. Smartsheet Supabase Sync (GitHub Actions)

Common Components

Shared Dependencies

All repositories depend on:

  • Smartsheet API: Primary data source and destination
  • Environment Variables: Configuration management via .env files
  • API Tokens: Secure authentication for all services
  • Error Handling: Robust retry logic and logging

Common Environment Variables

Variable Purpose Used By
SMARTSHEET_ACCESS_TOKEN Smartsheet API authentication All repos
SUPABASE_URL Supabase project URL SSS, SPS
SUPABASE_KEY Supabase API key SSS, SPS
SHEET_ID_* Specific sheet identifiers All repos (varies)
COLUMN_ID_* Column identifiers for mapping All repos (varies)

Security Notice

Never commit API tokens or sensitive credentials to version control. Always use environment variables or secure secret management.

Update Frequency

Repository Execution Frequency Trigger
Smartsheet-Supabase-Sync GitHub Actions Daily/Hourly Scheduled cron
Supabase-Smartsheet-Offload Manual/Scheduled As needed Manual or cron
Master-to-Sibling Manual/Triggered On demand Webhook or manual
Generate-Job-Numbers Manual/Triggered On new rows Webhook or manual
Generate-Weekly-PDFs Scheduled Weekly (Monday) Cron job
Resiliency-PDF-Restructure Scheduled Weekly After PDF generation

Getting Started

To work with these repositories:

  1. Review: Start with the Usage Guide for setup instructions
  2. Understand: Read Smartsheet Integration for data flows
  3. Be Careful: Check Watch Out For for critical warnings
  4. Maintain: Follow the Maintenance Guide for updates
  5. Troubleshoot: Use the Troubleshooting Guide when issues arise

Next Steps

📖 Read the Guides

Start with the Usage Guide to understand setup and configuration.

🔍 Explore Repositories

Visit the Repositories section for detailed documentation on each tool.

⚠️ Learn the Pitfalls

Review Watch Out For to avoid common mistakes.