
Closed
Posted
Paid on delivery
I have a Google Sheet that holds our tenant roster (name, WhatsApp number, unit, rent amount, due date, payment status). I want a Python-built bot that polls this sheet every day and, based on the status column, automatically pushes personalised WhatsApp reminders: • 1st reminder on the 7th • 2nd reminder on the 14th • Final reminder on the 31st Only tenants still marked “unpaid” should receive a message that clearly states their outstanding amount and due date. I also need a simple command-line or webhook-style endpoint that lets me resend a reminder to any single number on demand. Key preferences – Language: Python. – WhatsApp delivery: a 3rd-party gateway that is not the Meta Business API; feel free to suggest Twilio, Vonage or another cost-effective option that can be self-hosted or run on a small VPS. – Error strategy: if the Sheet contains incomplete or malformed data, just log the problem and keep processing the rest. Architecture constraints No Zapier, [login to view URL] or other paid middleware. I’m looking for a lightweight, self-hosted solution (Flask/FastAPI + cron, Cloud Functions, or a Dockerised microservice—your call). Please outline the stack you plan to use when you reply. Deliverables 1. Fully working bot with source code. 2. Brief README covering setup, environment variables, and how to trigger the manual resend. 3. Short hand-over call or screen-share so I can see it in action. If you’ve built anything similar—especially WhatsApp or Google Sheets integrations—include a link or short summary. I’ll prioritise applicants who can point to live examples and who offer a clear plan for hosting and ongoing maintenance.
Project ID: 40650511
258 proposals
Remote project
Active 3 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
258 freelancers are bidding on average $243 USD for this job

Hi, this is a good fit for my Python automation background. I’d build this as a lightweight Python service using FastAPI or Flask, Google Sheets API, scheduled cron execution, and a non-Meta WhatsApp gateway such as Twilio or Vonage depending on cost and reliability for your use case. The bot will check unpaid rows only, send dated reminders, skip bad records while logging them, and include a simple resend trigger for any number on demand. I can also provide clean source code, setup documentation, and a short hand-over call here on the platform.
$250 USD in 7 days
9.4
9.4

Hello, As someone who has been in the development industry for over 15 years, I have an extensive background in creating robust and scalable web applications - including automation projects. I am confident that I can leverage my expertise in Python and AI Automation to build an exceptional Rent Reminder Bot for you. I understand the value of clean code and timeliness when it comes to project delivery. I employ these principles to develop applications that are efficient and easy to maintain. Regarding your project, I have experience with integrating Google Sheets API, WhatsApp APIs like Twilio and understand the importance of third-party gateway options that guarantee smooth functioning and self-hosting feasibility. Additionally, I have worked with Flask, FastAPI, also Dockerised microservices which gives me flexibility in providing you a lightweight and easily manageable solution. You need not worry about potential issues with your Google Sheet as well; I am well-prepared to handle incomplete or malformed data gracefully while logging problems for future reference. In conclusion, not only do I bring extensive technical prowess to the table but also a commitment to long-term client support. My goal is to give you a Rent Reminder Bot that will not only meet your immediate needs but also be a tool that you can rely on for years to come. Let's talk about how my skills can turn into a reliable product for your business! Thanks!
$280 USD in 2 days
8.6
8.6

Hi there, I understand you need a Python WhatsApp rent reminder bot that integrates with your Google Sheet tenant roster. This is exactly the kind of automation project I specialize in. My approach involves creating a Python script using the google sheets api to read your tenant data daily, checking payment statuses against due dates. For WhatsApp messaging, I'll implement the twilio api to send automated reminders to tenants based on their payment status. The system will run as a scheduled task on a linux server, ensuring consistent daily polling. The bot will handle different scenarios - sending payment reminders before due dates, follow up messages for overdue payments, and status updates when payments are marked as received. I'll structure the code with flask for any webhooks needed and ensure secure handling of tenant data. This solution will save you hours of manual follow ups while maintaining professional communication with your tenants through automated, timely reminders. Best Regards, Khorshed Alam, RS Software
$265 USD in 6 days
9.5
9.5

Hi, I reviewed your Python WhatsApp rent reminder bot request: poll a Google Sheet daily, send personalized WhatsApp reminders on the 7th/14th/31st only for tenants marked “unpaid,” and include outstanding amount and due date. I’ll build a lightweight FastAPI service with Google Sheets reading, a small scheduler/cron loop, and an endpoint to resend a reminder to any single WhatsApp number on demand. I’ll include clear Software Architecture separation (sheet access, rules engine, message rendering, and delivery) and use a self-hostable WhatsApp gateway like Twilio or Vonage. I’ll keep it clean, reliable, and easy to maintain, logging malformed rows and continuing the rest. Let’s discuss here now.
$280 USD in 7 days
8.4
8.4

⭐⭐⭐⭐⭐ Build a Python Bot for WhatsApp Reminders from Google Sheets ❇️ Hi My Friend, I hope you're doing well. I've reviewed your project requirements and noticed you're looking for a Python bot to send WhatsApp reminders based on your tenant roster. You have no need to look any further; Zohaib is here to help you! My team has successfully completed 50+ similar projects for automation and messaging systems. I will create a bot that polls your Google Sheet daily and sends personalized reminders to tenants marked "unpaid." ➡️ Why Me? I can easily build your WhatsApp reminder bot with 5 years of experience in Python automation, Google Sheets integration, and messaging APIs. My skills include data processing, error handling, and API integration. I also have a strong grip on Flask and FastAPI, ensuring a lightweight and efficient solution. ➡️ Let's have a quick chat to discuss your project in detail and let me show you examples of my previous work. Looking forward to discussing this with you in chat. ➡️ Skills & Experience: ✅ Python Programming ✅ Google Sheets API ✅ WhatsApp API Integration ✅ Data Processing ✅ Task Automation ✅ Error Handling ✅ Flask Development ✅ FastAPI Development ✅ Webhook Implementation ✅ Command-Line Interface ✅ Logging and Monitoring ✅ Docker Deployment Waiting for your response! Best Regards, Zohaib
$220 USD in 2 days
8.1
8.1

I can build this lightweight Python + Google Sheets + WhatsApp automation without Zapier/Make. Stack: Python, Google Sheets API, FastAPI/Flask, cron, and a cost-effective WhatsApp gateway such as Twilio/Vonage. I’ll implement the 7th, 14th and 31st reminders, unpaid-status filtering, personalized amounts/due dates, malformed-data logging, and a manual resend endpoint. Timeline: 3–5 days Delivery: Source code, README, environment setup, testing and handover walkthrough. Ready to start immediately. Best regards, Muhammad Rizwan LA
$250 USD in 7 days
8.2
8.2

Hi, You’re not just asking for reminders, you’re trying to stop rent follow-ups from slipping through the cracks. I can build this as a lightweight Python service that reads your Google Sheet daily, filters only unpaid tenants, and sends personalised WhatsApp reminders on the 7th, 14th, and 31st with clean logging for bad rows. I’ve handled similar Python automation and Google Sheets/API workflows, and I’d structure this with Flask or FastAPI, a cron job or scheduled task, and a cost-effective WhatsApp gateway such as Twilio or Vonage that can run on a small VPS. I’ve shared an initial estimate based on your description, and once we go over a few technical or functional details, I’ll confirm the exact cost and delivery schedule. I’ll also include a simple manual resend endpoint, a concise README, and a smooth handover so you can see the full flow in action. Would you prefer the reminders to be triggered by the tenant’s due-date cycle or strictly by calendar dates like the 7th, 14th, and 31st? Best regards, Asad
$280 USD in 3 days
8.2
8.2

Hi,-----------I can build this lightweight, self-hosted Python reminder bot using Google Sheets API + FastAPI/Flask + cron + a WhatsApp gateway such as Twilio/Vonage, with no Zapier or Make. The bot will validate rows, log malformed data, process only unpaid tenants, send the 7th/14th/31st reminders, and support manual resends through a simple CLI or webhook. I’ve worked with Python, Google Sheets APIs, WhatsApp integrations, REST APIs, Docker, and automation workflows, and can provide clean source code, README, deployment setup, and handover. Quick question: Do you already have a preferred WhatsApp gateway, or should I compare Twilio/Vonage and recommend the most cost-effective option? Thanks! Parminder
$300 USD in 5 days
8.1
8.1

Hello, your brief is quite clear and this can be done nicely with a small Python microservice instead of any heavy middleware. I’d recommend Flask or FastAPI with Google Sheets API access, scheduled daily checks via cron, and WhatsApp delivery through a third-party provider like Twilio/Vonage, with failed or incomplete sheet rows simply logged while the rest continue processing. I can deliver the source code, setup guide, env variable notes, and a simple manual resend option for single numbers on demand. Happy to also walk you through the flow on a call through the platform after delivery.
$228 USD in 7 days
7.7
7.7

Hi, I've built a LAMP web app with Twilio SMS delivery and REST API integration, including on demand resend of messages, which is close to what you need here. LAMP with SMS via Twilio: 5 star Upwork contract, "Great job! Will hire again." For the stack I'd go FastAPI plus a cron job on a small VPS, with the Google Sheets API read on each poll. Twilio's WhatsApp sandbox works for testing, but for production it still routes through a WhatsApp Business template approval. Are you fine with template messages, or do you want a gateway that avoids that entirely? That changes which provider I'd pick. Malformed rows get logged and skipped so the rest keep sending. Manual resend as a simple webhook endpoint. First milestone on the daily poller and one working reminder, so you only release once you see a real message land. Adil
$275 USD in 7 days
7.5
7.5

The need for a reliable Python bot to send automated WhatsApp reminders to tenants based on their payment status is clear. I propose building this using Python with Flask or FastAPI, along with a third-party gateway like Twilio for WhatsApp delivery. The bot will poll your Google Sheet daily, sending reminders on specified dates only to those tenants marked “unpaid,” while logging any data errors without interruption. My skill set includes extensive experience with Python, web automation, and third-party API integrations. With a 4.9-star rating across 200 client reviews and 220 projects completed, I ensure quality in every project. What specific thresholds do you want for processing the data from your Google Sheet?
$255 USD in 10 days
7.4
7.4

Hi I can make a bot for you that can message the tenant or you can send a reminder when you want. If the sheet system feels difficult for you i can also build a system that will be hosted over the web and handle your data with CRUD operations. Lets chat
$750 USD in 7 days
7.7
7.7

I can build this in Python with Google Sheets, FastAPI and a WhatsApp gateway. Ready to provide a quick sample. Which gateway do you prefer?
$250 USD in 2 days
7.3
7.3

Hi, I’ve handled API-based automations and this can be done in a clean, lightweight way without relying on Zapier or Make. I would use Python with Flask/FastAPI, Google Sheets integration, a scheduler for the 7th/14th/31st reminder cycle, and a webhook-style manual resend option, with robust logging so incomplete sheet rows do not interrupt processing. You’ll receive full source code, setup steps, env variable documentation, and a short demo session after delivery. The final setup will be easy to host on a small VPS or in Docker.
$250 USD in 7 days
7.1
7.1

Hi. I will build a secure, real-time AI Collections Dashboard that seamlessly integrates Splynx and Zoho Books for accurate financial reconciliation. My approach ensures your unique transaction identifiers are correctly mapped while allowing configurable refresh intervals for data synchronization. The dashboard will be designed to support both human agent recommendations and automated outbound actions based on account status. I have extensive experience with payment gateway APIs and can deliver a scalable solution within your $30 to $250 budget. Please let me know your preferred refresh schedule so I can tailor the initial setup to your specific workflow needs.
$250 USD in 4 days
6.9
6.9

I Have multiple of these projects that are live , which have remonders , some of them use Twiolio , Also one of them is for a Out service task management that uses whatsapp api its in php but can be translated to python. What are you looking for Server based script installation or the one on you your machine. Regards
$350 USD in 7 days
7.1
7.1

As a seasoned software engineer with extensive experience in Python, Software Architecture, and API integrations, I am confident that I am your best bet for your project. Throughout my 14-year career, I have developed and automated various applications, like data pipelines similar to what your project demands. With tools such as Lambda and S3 and my proficiency in Python, I can efficiently design a lightweight, self-hosted solution for you. One of the standout features of my portfolio is my expertise in Amazon Web Services (AWS), where I have successfully worked on projects involving data ingestion and pipelines - a skill crucial for your bot to effectively pull data from the Google Sheet. Another relevant skill comes from my Web Scraping background. For example, I have scraped over 50K email addresses and contact numbers and can apply this same level of precision to targeted message delivery. To ensure your preference for architecture constraints is met, I propose we use Flask/FastAPI plus cron or possibly a Dockerised microservice. During our handover call, I will walk you through the setup process including environmental variables that must be properly configured for optimal performance - guaranteeing 100% actionability on your end. Don't miss this opportunity to work with a proven professional whose skills align perfectly with your needs!
$300 USD in 14 days
6.9
6.9

Understanding your need for an efficient reminder system, our team can develop a Python bot that integrates seamlessly with your Google Sheet. This solution will ensure timely reminders for tenants marked as "unpaid," enhancing communication while minimizing manual effort. We will utilize Flask for the backend and incorporate Twilio for WhatsApp messaging, as it provides a reliable and cost-effective gateway. Our approach includes logging any data issues without halting the process, ensuring smooth operations. Our expertise in Python, Google Sheets integration, and API communication will guarantee a robust solution. Also, communication, quality, and on-time delivery are priorities. If you'd like, I can also share similar work we've completed and discuss the best approach for your project. Regards, JP
$200 USD in 7 days
6.8
6.8

Hi there, I can create a Python-based bot that will efficiently poll your Google Sheet daily and send personalized WhatsApp reminders to your tenants based on their payment statuses. I suggest using Twilio due to its simplicity and cost-effectiveness for WhatsApp integration. My plan is to use FastAPI for a lightweight framework, ensuring smooth operation with scheduled tasks. The deliverables will include the source code, a straightforward README, and a screen-sharing session to demonstrate the bot's functionality in action. Your satisfaction is my priority and I guarantee that I will deliver you a high-quality result. Regards, Ali
$200 USD in 7 days
6.4
6.4

Hi Sir, I have 7 years of experience in Python, Whatsapp bot development.I will build it using zapier. Let’s connect.I can complete this in 1 day
$201 USD in 2 days
6.5
6.5

shah alam, Malaysia
Payment method verified
Member since Jun 16, 2020
$19-20 USD
$10-11 USD
$390-400 USD
$19-20 USD
$110-130 USD
$30-250 USD
$15-25 USD / hour
₹1500-12500 INR
$15-25 USD / hour
₹100-400 INR / hour
$250-750 USD
₹600-1500 INR
₹12500-37500 INR
$30-40 USD
$30-250 USD
$10-30 USD
₹750-1250 INR / hour
$30-250 USD
$30-250 CAD
₹12500-37500 INR
₹750-1250 INR / hour
₹750-1250 INR / hour
$30-250 USD
£2-5 GBP / hour
$250-750 USD