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.
Digital Marketing Specialist for Website Growth Category: Content Marketing, Digital Marketing, Email Marketing, Facebook Marketing, Internet Marketing, SEO, Social Media Marketing, Twitter Budget: $30 - $250 USD
10 Jul 2025 21:55 GMT
Mise à jour de Design de Fichiers .pdf Category: Photoshop, Brochure Design, Design, Graphic Design, Icon Design, Illustration, Label Design, Print Design, Typography, Visual Design Budget: $10 - $30 USD
10 Jul 2025 21:55 GMT
Windows App Web Design Needed Category: App Design, Graphic Design, PHP, UI / User Interface, User Experience Research, User Interface / IA, Web Design Budget: $250 - $750 USD
Professional Blog on Developmental Games Category: Article Writing, Blog, Blog Writing, Content Creation, Content Writing, Copywriting, Creative Writing, Writing Budget: ₹2000 - ₹3000 INR
10 Jul 2025 21:49 GMT
Developmental Game Ideas Blog Category: Article Writing, Blog Writing, Content Creation, Content Development, Content Writing, Copywriting, Creative Writing, Game Design, Game Development, Ghostwriting Budget: ₹1500 - ₹12500 INR
10 Jul 2025 21:48 GMT
Fantasy RPG Vertical Slice Development (Bid Request) Category: 3D Animation, 3D Modelling, 3D Rendering, Animation, C++, Programming, Game Design, Game Development, OpenGL, Unity 3D, Unreal Engine Budget: $25 - $50 CAD
Motivational Video Editing Category: Adobe Premiere Pro, After Effects, Audio Editing, DaVinci Resolve, Final Cut Pro, Video Editing, Video Production, Video Services, Visual Effects, YouTube Budget: ₹1500 - ₹12500 INR
10 Jul 2025 21:46 GMT
Website Design and Development Category: ECommerce, Graphic Design, HTML, Payment Gateway Integration, User Interface / IA, UX / User Experience, Web Design, Web Development, Website Optimization Budget: $250 - $750 USD
Fix Rust FFmpeg-Sys-Next Encoder Bugs Category: Computer Vision, Debugging, Performance Tuning, Rust, Software Development, Video Editing, Video Processing, Video Streaming Budget: $30 - $250 USD
10 Jul 2025 21:45 GMT
Setup Social Media Accounts Category: Affiliate Marketing, Branding, Content Strategy, Facebook Marketing, Pinterest, Social Media Management, Social Media Marketing, Twitter Budget: $15 - $25 USD
