Description: We are looking for an experienced Google Sheets expert and Google Apps Script developer to build a property management system for our letting agency. The system should automate key property management processes, including rent collection, tenant communications, maintenance task management, and compliance tracking. Key Responsibilities: Set up Google Sheets for Property Management: Create separate sheets for tracking properties, tenants, rent payments, maintenance tasks, and compliance. Set up data validation for fields like task status (Pending, In Progress, Completed), rent payment status, and compliance status. Google Forms Integration: Create Google Forms to collect tenant applications and maintenance requests, automatically populating the data into the relevant Google Sheets. Automate Processes with Google Apps Script: Rent Payment Reminders: Automate email reminders for overdue rents and upcoming payments. Maintenance Task Automation: Automatically create tasks, assign them to contractors, and track progress. Certificate Expiry Automation: Automate certificate expiry alerts (e.g., EPC, Gas, EICR). Automated Communication: Create email templates for various processes such as tenant application confirmation, maintenance request updates, and rent reminders. Scripts will be provided. Reporting and Dashboards: Set up dashboard views to track key metrics (e.g., overdue rents, pending maintenance tasks, upcoming certificate renewals). Automate the creation of reports and send them periodically to stakeholders (agents, landlords). Testing & Validation: Ensure that all automation works seamlessly (e.g., email triggers, task creation, compliance tracking). Test the system end-to-end and provide guidance on system usage. A comprehensive list of testing requirements will be provided Skills and Experience Required: Advanced Google Sheets expertise: You must be highly proficient in Google Sheets, including formulas, data validation, conditional formatting, and VLOOKUPs. Google Apps Script expertise: Proven experience in writing Google Apps Script to automate workflows and email communication. Property Management Systems: Knowledge of property management tasks such as rent tracking, maintenance management, and tenant communication is a plus. Attention to Detail: Accuracy is key for automating financial data, task management, and compliance tracking. Communication: Must communicate effectively to ensure all features are implemented according to requirements and are working properly. Ability to Deliver on Time: Experience delivering functional systems with automated processes in a timely manner. What You Will Deliver: A Google Sheets-based property management system with automated workflows, reminders, and communication features. Google Apps Scripts for automating tasks such as rent reminders, maintenance tracking, and compliance monitoring. Reports and dashboards with automated data collection, tracking, and reporting features. A fully functional system that will significantly reduce manual effort in managing properties, tenants, maintenance, and compliance. Expected Timeline for Delivery: 4-5 weeks depending on the complexity of the features and automation. The setup should be complete in this time, including testing and refining the system for real-world use. Required Experience: Google Sheets: Advanced knowledge of data management and automation. Google Apps Script: Experience automating tasks and email communications in Google Sheets. Property Management Software: Familiarity with property management workflows (e.g., rent tracking, tenant communication, and maintenance task management).
How to Apply: Please provide:
Examples of previous work you’ve done with Google Sheets and Google Apps Script.
Estimated time frame to complete the project based on the description above.
Any questions or clarifications you have regarding the project.
Your hourly rate or a project price.
Why This Role is Important: This project will help streamline property management operations, reduce human errors, and ensure compliance in a more efficient manner. By automating routine tasks, the system will save time and improve the service provided to tenants and landlords alike.
Closing Thoughts: If you're skilled in Google Sheets and Google Apps Script, and have experience creating automated systems, this is an exciting opportunity to build a unique, valuable property management system for a growing letting agency. We look forward to working with a professional who can help us create this system and add automation to simplify our workflows. Final Notes: Simple, clear instructions will be provided for you to integrate the system. Collaboration with our team will ensure all required features are added and automated correctly. regular video calls will be required showing updates of work. samples of work must also be provided. there are approximately 20 sheets to set up. see attached.
Application anti-gaspillage alimentaire Gabon Category: Android, API Development, Graphic Design, Mobile App Development, UI / User Interface, User Interface / IA, UX / User Experience, Web Development Budget: €30 - €250 EUR
14-Mar-2026 17:01 GMT
Abdelhadi 0012010 Category: Data Cleansing, Data Entry, Data Extraction, Data Processing, Excel, PDF Budget: £20 - £250 GBP
14-Mar-2026 17:01 GMT
Textile Inventory Tracking Excel Sheet Category: Copy Typing, Data Entry, Data Processing, Excel, Excel VBA, PDF, Visual Basic, Word Budget: ₹100 - ₹400 INR
14-Mar-2026 17:00 GMT
Residential Floor Plan and 3D Renderings Category: 3D Architecture, 3D Design, 3D Modelling, 3D Rendering, Architectural Visualization, AutoCAD, Building Design, Interior Design Budget: $250 - $750 USD
14-Mar-2026 17:00 GMT
Cartoonish Hockey Team Logo Patch Category: 2D Animation, Character Illustration, Creative Design, Design, Digital Art, Graphic Design, Illustration, Logo Design, Photoshop Budget: $250 - $750 USD
14-Mar-2026 17:00 GMT
Web Design & Branding Setup Category: Adobe XD, Branding, Graphic Design, Logo Design, Sketch, Typography, UI / User Interface, User Interface / IA, Web Design, Web Development Budget: ₹600 - ₹1500 INR
14-Mar-2026 16:59 GMT
Comprehensive Article on Photosynthesis for Students Category: Academic Writing, Article Rewriting, Article Writing, Biology, Content Writing, Education & Tutoring, Medical Writing, Research Writing, Scientific Writing, Technical Writing Budget: $30 - $250 USD
14-Mar-2026 16:58 GMT
Reparar evento Purchase AnyTrack Category: API, API Integration, Debugging, Laravel, PHP, Software Development, Web Application Budget: $10 - $30 USD
Stamped Foundation Design, Steel Building Category: AutoCAD, Building Architecture, Building Design, Building Information Modeling, CAD / CAM, Civil Engineering, Construction Management, Engineering Drawing Budget: $250 - $750 USD
