1001 Freelance Projects
Latest Projects from
Freelance Marketplaces
View Project
View this project in detail
(Note: you will be redirected to external marketplace)
Project title:
Build Prop Management System Google Sheets Full Auto app scripts
Posted by:
External project from PeoplePerHour
Started:
15-Apr-2025 11:54 GMT
Description:
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.
Project ID:
3429641
Project category:
Project budget:
View this project in detail
(Note: you will be redirected to external marketplace)
Last Projects / Browse Projects
  Project Started
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
10 Jul 2025 21:54 GMT
Comprehensive GLP-1 Support Needed
Category: Life Coaching, Nutrition, Personal Development
Budget: $2 - $8 USD
10 Jul 2025 21:51 GMT
Talented Python Scraping Developer Needed
Category: BeautifulSoup, Python, Scrapy, Selenium, Web Scraping
Budget: ₹600 - ₹1500 INR
10 Jul 2025 21:51 GMT
SQL & Apache Superset Expert for Financial Data Analysis
Category: Business Intelligence, Data Analysis, Data Integration, Data Visualization, Financial Analysis, PostgreSQL
Budget: $100 - $500 USD
10 Jul 2025 21:49 GMT
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
10 Jul 2025 21:48 GMT
Egyptian Arabic Voice Isolation & Cloning
Category: Audio Editing, Audio Engineering, Audio Production, Audio Services, Voice Acting, Voice Over, Voice Talent
Budget: $30 - $250 USD
10 Jul 2025 21:47 GMT
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
10 Jul 2025 21:45 GMT
Enhance Logo & Brand Identity Package
Category: Adobe Illustrator, Photoshop, Branding, Corporate Identity, Graphic Design, Logo Design, Typography
Budget: $30 - $250 USD
10 Jul 2025 21:45 GMT
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
10 Jul 2025 21:44 GMT
Browse All Projects
Projects by Skills ...
android
ajax
asp
aspnet
cms
cpp
csharp
css
delphi
design
drupal
excel
facebook
flash
html
java
javascript
joomla
iphone
mysql
photoshop
php
python
ruby
seo
sql
sysadm
translate
typing
twitter
vbnet
xml
wordpress
writing
New!
Проекты на русском
(Projects in Russian)

Copyright © 2005-2024
1001 Freelance Projects