Solar/Construction

Custom Solar Measurement Tool Replacement (Aurora API Integration)

Automated, branded roof-measurement reports with instant updates across ops systems.

1 week

Timeline

Challenge

What was slowing the business down?

Slow, manual measurement workflows decoupled from downstream systems.

Solution

What we built or automated

  • Secure Aurora API ingestion with Python; normalization incl. externally-hosted images
  • Dynamic PDF report generation (ReportLab) with tables and screenshots
  • Zapier + GCF: attach to Odoo, set up Slack channels, update Sheets, create QuickBooks customer records
  • Robust error handling and documentation; historical data backfill
Outcomes

Business impact

  • 100% automated from contract signing to report
  • Professional multi-page PDFs
  • Instant updates in Odoo/Slack/Sheets/QuickBooks
Tools

Tech stack

Aurora Solar APIPythonReportLabZapierGoogle Cloud FunctionsOdooSlackGoogle SheetsQuickBooksAWS S3

Replaced a third-party tool with a tailored pipeline that's faster, branded, and fully integrated.