Construction Management Software in Google Sheets + Apps Script | ERP + CRM Web App with AI

A complete construction management system built on Google Sheets and Google Apps Script. It takes a contractor from the first lead to the retention release after handover, so the BOQ, the site, the store and the bills stop living in separate Excel files and WhatsApp chats. Google Sheets is the database, and the whole system runs as a mobile-friendly web app from your own Google account.

What it does

Sales starts on a leads board with follow-ups. Estimates are priced from the BOQ at cost plus markup, and a win wizard turns an accepted estimate into a project. Every project opens in a 360 view with its BOQ (quantities done feed the progress), a schedule shown as a list or a Gantt chart, change orders that revise the contract, and documents with revisions.

On site, engineers keep a daily diary with photos, a crew roster and attendance register, workers and RFIs with due dates and cost or schedule impact. The store runs on purchase orders with an approval limit, goods received against the PO, and issue, transfer, return and stock count, all posted to a moving-average stock ledger. An issue larger than the stock on hand is refused.

Subcontractors get work orders and certificates with retention and deductions, and plant gets hour-meter logs. Finance covers running bills (interim payment certificates) with retention, advance recovery and sales tax, receipts with withholding tax, payment vouchers, expenses with approvals, cash and bank accounts and party statements.

Highlights

• Inspections with checklists, a snag list, safety incidents with TRIR and LTIFR, and handover and close-out
• 14 reports including WIP over and under billing, project profit and loss, receivables and payables aging, wages, stock, plant, safety and retention
• Role dashboards with KPIs and a Needs attention list
• Seven roles: Owner, Admin, Project Manager, Site Engineer, Storekeeper, Accountant and Client
• Project staff see only their assigned projects, and clients see only their own
• Company details, logo, currency, tax rates and retention defaults in Settings

Who it is for

Small and mid-size contractors and builders who run projects on Excel and WhatsApp and want their own construction software, and Apps Script developers looking for a large real-world Google Sheets project to customize for a client.