Real Estate & ConstructionEnd to End Automation for Asana PMS Platform
The Real Estate company is an Sydney, Australia based estate agency, providing specialization in all type of real estate consultation and services.
Tech Stack
Python, PostGreSQL, AWS
Project Type
Company Project
Service Type
Automation Backend
Industry
Real Estate
About Client & Project
The client’s organization operates in the real estate, construction, and land development industry, managing projects related to residential construction and land subdivision. The company handles activities such as building houses, developing land, subdividing plots, and setting up essential infrastructure including roads, gas pipelines, electricity, stormwater systems, and internet connectivity.
Most projects typically take 8–12 months from initiation to completion and require coordination across multiple teams and tasks. The organization manages different project workflows depending on the level of development required.
Some projects involve constructing houses on land where utilities and infrastructure already exist, while others require partial or complete development of infrastructure such as roads and utility networks before construction can begin. Each workflow consists of hundreds of interdependent tasks, making structured planning and efficient project management critical for successful execution.
Challenges For Client
The Key Features We Integrated
Automated Project Creation
The system automatically creates a complete Asana project structure from the uploaded Excel file, eliminating the need for manual project setup.
Bulk Task Generation
It automatically generates 300–400 root and dependent tasks in bulk, significantly reducing the time required for manual task creation.
Automatic Section Mapping
Tasks are automatically assigned to the correct sections based on the Excel structure, ensuring organized project setup.
Dependency Linking Between Tasks
The system automatically links root tasks with dependent tasks, ensuring the correct sequence in project workflow.
Intelligent Date Synchronization
If a root task is delayed, all dependent tasks automatically reschedule to maintain proper task order.
Automated Completion-Based Scheduling
When a root task completes, dependent tasks are automatically scheduled using predefined date calculation logic.
Product Development Cycle
Requirement Discovery & Workflow Analysis
Conducted client discussions to analyze manual Asana project creation, identifying issues with sections, tasks, dependencies, and timelines.
Excel Data Structure & Mapping Design
Analyzed Excel template and designed mapping logic to convert fields into structured Asana project components.
Backend Automation Architecture Development
Developed backend automation to process Excel data, manage task relationships, and prepare structured payloads for Asana.
Asana API Integration & Project Creation
Integrated Asana APIs to automatically create projects, sections, root tasks, and dependent tasks from Excel.
Dependency Logic & Intelligent Date Synchronization
Implemented automation ensuring dependent tasks automatically reschedule when root task delays occur, maintaining correct project timelines.
System Testing & Workflow Validation
Performed comprehensive testing to verify Excel ingestion, task creation accuracy, dependency linking, and timeline adjustments.
Deployment & Automation Enablement
Deployed solution enabling Excel uploads to automatically generate fully configured Asana projects, significantly reducing setup time.
Ready to build your next AI-powered solution?
Let's explore how PragetX can deliver measurable results for your business — from workflow automation to custom software at scale.