Google Workspace / Apps Script Developer: Custom Construction Management Forms & Automated Dashboard
Budget: ₹1,500 – ₹12,500 INR
Job Title
Google Workspace / Apps Script Developer: Custom Construction Management Forms & Automated Dashboard
Job Description
Project Overview:
We are a premium construction and real estate development firm specializing in high-end villa and farmhouse projects. We are looking to digitize our field operations by moving away from manual/WhatsApp-based reporting to a structured, mobile-friendly Google Workspace ecosystem.
We require an experienced Google Apps Script developer to design a set of interconnected Google Forms, optimize the backend Google Sheets, and automate daily report generation.
Scope of Work:
1. Google Forms Development:
Design a Daily Progress Report (DPR) form optimized for mobile use by on-site supervisors (heavy use of dropdowns, minimal manual text entry, restricted number-only fields).
Include secure File Upload fields for site progress photos and material delivery challans/invoices.
Design a secondary Material Requisition Form for site engineers to request specific material grades and quantities.
2. Backend Google Sheets Architecture:
Set up a centralized Master Ledger spreadsheet that automatically captures form responses.
Organize the sheets using =FILTER() or query functions so data can be easily viewed by individual project sites or specific dates.
Ensure user access controls are configured so site supervisors can only input data, while management retains full editing control of the master dashboard.
3. Workflow Automation (Google Apps Script):
Program an automated trigger: When a DPR is submitted, the script must generate a clean, professionally formatted PDF summary report containing the day's text, metrics, and uploaded photos.
Set up automated email routing so this daily PDF is automatically sent to management.
Configure a conditional alert system: If a supervisor selects a critical project bottleneck (e.g., "Material Shortage" or "Design Delay"), an immediate email notification must be sent to the operations team.
Required Skills:
Expert-level knowledge of Google Sheets formulas, data structuring, and access permissions.
Proficient in Google Apps Script (JavaScript-based) for document generation and email triggers.
Experience integrating third-party tools (like Form Publisher, Document Studio, or Autocrat) is a plus, though native Apps Script solutions are preferred.
Previous experience building workflows for civil engineering, construction, or logistics businesses is highly valued.
Project Type: One-time project
Budget Type: Fixed Price / Milestone-based
Google Workspace / Apps Script Developer: Custom Construction Management Forms & Automated Dashboard
Job Description
Project Overview:
We are a premium construction and real estate development firm specializing in high-end villa and farmhouse projects. We are looking to digitize our field operations by moving away from manual/WhatsApp-based reporting to a structured, mobile-friendly Google Workspace ecosystem.
We require an experienced Google Apps Script developer to design a set of interconnected Google Forms, optimize the backend Google Sheets, and automate daily report generation.
Scope of Work:
1. Google Forms Development:
Design a Daily Progress Report (DPR) form optimized for mobile use by on-site supervisors (heavy use of dropdowns, minimal manual text entry, restricted number-only fields).
Include secure File Upload fields for site progress photos and material delivery challans/invoices.
Design a secondary Material Requisition Form for site engineers to request specific material grades and quantities.
2. Backend Google Sheets Architecture:
Set up a centralized Master Ledger spreadsheet that automatically captures form responses.
Organize the sheets using =FILTER() or query functions so data can be easily viewed by individual project sites or specific dates.
Ensure user access controls are configured so site supervisors can only input data, while management retains full editing control of the master dashboard.
3. Workflow Automation (Google Apps Script):
Program an automated trigger: When a DPR is submitted, the script must generate a clean, professionally formatted PDF summary report containing the day's text, metrics, and uploaded photos.
Set up automated email routing so this daily PDF is automatically sent to management.
Configure a conditional alert system: If a supervisor selects a critical project bottleneck (e.g., "Material Shortage" or "Design Delay"), an immediate email notification must be sent to the operations team.
Required Skills:
Expert-level knowledge of Google Sheets formulas, data structuring, and access permissions.
Proficient in Google Apps Script (JavaScript-based) for document generation and email triggers.
Experience integrating third-party tools (like Form Publisher, Document Studio, or Autocrat) is a plus, though native Apps Script solutions are preferred.
Previous experience building workflows for civil engineering, construction, or logistics businesses is highly valued.
Project Type: One-time project
Budget Type: Fixed Price / Milestone-based
Related categories:
Project Management
Mobile App Development
HTML
Google Sheets
Construction Management