Internal CRM + Quote Automation for NorthernLED
A custom-built Airtable + Softr solution that empowers NorthernLED’s sales and HQ teams to manage client leads, auto-generate quotes with install pricing, and organize delivery & install batches. Includes dynamic PDF generation, multi-product quoting, and driver delivery photo uploads — all in one centralized, mobile-ready portal.
From the partner
The NorthernLED Internal CRM & Operations Portal is a fully customized solution built for NorthernLED Industrial & Commercial — a Canadian provider of LED lighting, EV charging stations, and renewable energy systems.
The platform centralizes the entire operational workflow, connecting sales, quoting, invoicing, delivery scheduling, and installation tracking in one integrated system built on Softr + Airtable.
Previously, the team relied on manual spreadsheets, emails, and disconnected systems to track leads and manage client deliveries. This often led to errors, duplicated work, and inefficiencies between sales representatives and the head office.
To solve this, a fully digital CRM was developed to help NorthernLED’s internal team streamline daily operations.
Core Features
Sales CRM Dashboard – Sales reps can log new leads, update contact statuses (New, Contacted, Quoted, Closed), and upload client details in real time.
Quote & Invoice Automation – Once a deal is marked Closed/Won, the system automatically generates a quote using company-branded PDF templates, including cost breakdowns, installation options, and tax calculations.
Multi-Product Support – Each quote supports up to three products with different quantities, cost types, and installation requirements.
Automated Calculations – The Airtable backend computes total costs dynamically depending on whether installation is required, applying formula logic to determine tax and grand totals.
Delivery & Installation Scheduling – HQ can batch deliveries and installations manually when total fixtures reach threshold values, simplifying logistics management.
Proof of Delivery – Drivers upload photos of delivered items on-site, which are linked to delivery batches for verification.
Admin Dashboard – Head office has full oversight to manage leads, approve quotes, and track every batch through to completion.
Technical Stack
Frontend: Softr – used for user-friendly dashboards, role-based portals, and PDF access.
Backend: Airtable – serves as the core database for leads, quotes, and product data.
Automation: Make.com – used for automated PDF generation and file organization.
Storage: Google Drive integration for file storage and retrieval.
Impact
After implementation, NorthernLED’s workflow became faster and more transparent.
Sales reps can now submit client data and generate quotes in minutes instead of hours. HQ no longer needs to manually assemble delivery or installation lists. Each record, photo, and document is now stored securely in a centralized, accessible database.
Results
The launch of the NorthernLED Internal CRM & Operations Portal transformed how the company manages sales and field operations. The platform replaced multiple disconnected tools with a unified, no-code solution — giving NorthernLED complete visibility from lead submission to final delivery.
Operational Efficiency:
Manual data entry and document creation were reduced by more than 70%. Sales reps can now create and submit quotes within minutes, and HQ can instantly review and generate invoices without waiting for spreadsheets or emails.
Improved Accuracy & Transparency:
All pricing calculations, taxes, and installation fees are automated through Airtable formulas, ensuring consistent and error-free quotes. HQ can track every lead, delivery, and installation with photo documentation directly tied to each record.
Faster Turnaround Time:
What previously required multiple handoffs between sales and operations is now streamlined through an integrated Softr dashboard — enabling same-day quoting, faster approvals, and better communication between teams.
Data Centralization:
Every record, document, and photo is stored in one connected database, eliminating file duplication and confusion. The system allows instant retrieval of historical quotes, batch details, and proof-of-delivery images.
Business Impact:
3× faster quote processing time
50% reduction in admin overhead
100% visibility across delivery and installation workflows
Enhanced client experience with professional, branded quotes and invoices
This project highlights how no-code tools like Softr and Airtable can transform traditional business operations — giving teams enterprise-level efficiency without complex software development.
Find the right partner for your project
Tell us a bit about your project and the Softr Partners team will match you with up to 3 of the best-fit partners in our network.





