
In Progress
Posted
Paid on delivery
I need a lightweight program that watches a live Google Sheet used as our dispatch log. The moment the “Status” column receives its first entry, the script must pull the Docket Number and Client Name from that same row and fire a WhatsApp message through Twilio to a fixed list of mobile numbers. When the Status field later changes to “Delivered”, a second message with the updated status should go out to the same recipients. Key points to build in: • Google Sheets API connection with read-only polling or webhook so it reacts quickly without hammering the quota. • Message composition that inserts the Docket Number and Client Name directly into the WhatsApp template. • Twilio WhatsApp integration; authentication details will be supplied once the code is ready to test. • An easy place (JSON, YAML, or .env) where I can edit the target phone numbers and the column names if the sheet layout ever shifts. Deliverables: 1. Well-commented source code (command-line script or small web app—your choice—as long as it runs on a standard Linux server). 2. A short README covering setup, required Google credentials, Twilio configuration steps, and how to add or change recipients. 3. Proof of concept: demo video or live walkthrough showing both the initial dispatch notification and the later delivery update arriving in WhatsApp. Acceptance criteria: message must trigger within 30 seconds of the cell change, display the correct data, and send exactly once per event.
Project ID: 40515304
13 proposals
Remote project
Active 7 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Having spent over 6 years working as a Fullstack Developer, proficient in .NET, Python, and Desktop Application development, I am primed to take on your Google Sheets to WhatsApp Notifier. My core competencies around ASP.NET, WinForms, and WPF would prove valuable for this project. Coming up with creative yet practical solutions to complex problems has always been my forte, specifically relevant to your requirement of a desktop application for Windows platform. Moreover, my past experience working with APIs in both .NET and Python capacities will certainly aid me in handling Google Sheets API effortlessly and efficiently. Furthermore, I deem it important to provide you with a tool that is easy-to-use for non-technical users hence guarantee a clean UI design along with detailed instructions. Crafting your recipient lists editable without breaking the code is imperative and I will ensure that - be it through a local config file or via a hidden sheet tab. Finally, to smoothen the entire process for you I offer to include documentation be it Markdown or PDF for easy future access. Looking forward to contributing my expertise towards your project ensuring swift data pulls and delivering WhatsApp notifications as desired.
₹4,000 INR in 7 days
5.4
5.4
13 freelancers are bidding on average ₹7,923 INR for this job

Hi, your "Google Sheets to WhatsApp Alerts" project is right in my wheelhouse. I develop modern JavaScript apps end to end — React/Vue/Next on the front and Node/Express on the back, in TypeScript where it helps. Working with php, javascript, python, android, google app engine, json, twilio, api integration, I focus on responsive, fast UIs, clean component structure, and reliable APIs — no page-builder shortcuts. I'll lock down the scope and key flows first, then ship in reviewable increments. Can we hop on a quick chat to align on your requirements? ⭐ 5.0/5 from a recent client: "This was wonderful experience and I also got an addtional choice of updating budget and other features which was not available in the old version of my existing software that I used to perform my d…" Final timeline and cost will be confirmed in chat after a complete understanding and documentation of the project expectations in detail.
₹10,000 INR in 2 days
8.0
8.0

Hi I have gone through the requirements. Good experience in creating custom scripts. Will do this script using PHP to send whatsapp alerts. I'm available to start now. Please contact for further discussions. Regards, Mohan
₹2,000 INR in 2 days
6.3
6.3

With an extensive experience in Android, JavaScript, PHP, and Python development, I am confident that I am the right fit for your Google Sheets to WhatsApp Alerts project. Over the years, I have honed my skills in creating efficient scripts that connect various platforms and automate processes. Your project's goal of reactively monitoring a specific column in a Google Sheet and sending corresponding updates via Twilio on WhatsApp aligns flawlessly with my expertise. My understanding of Google Sheets API ensures I can develop a streamlined program that swiftly detects changes without pushing the quota limits. Furthermore, I am highly knowledgeable in message templating and dynamic data integration as required in your project. For instance, using the Docket Number and Client Name from the spreadsheet directly within the Twilio WhatsApp messages is well within my capabilities. To ensure your convenience and ease even in case of future changes or adjustments, I will use a JSON or YAML format for storing target phone numbers and column names—making it simple for you to edit them. Lastly, given my passion for continuous learning and finding innovative solutions to problems faced by today's society,
₹7,000 INR in 7 days
4.9
4.9

As a multifaceted professional with exceptional skills ranging from Software Dev and DevOps to Data, AI/ML, and even Web3 and Blockchain, I am more than ready to tackle this project. First and foremost, my proficiency in languages like Python, Node.js, and JavaScript makes me the perfect candidate to handle the Google Sheets API connection and integrate it with Twilio. Additionally, my experience with CI/CD tools like GitHub Actions and cloud platforms such as AWS and GCP ensures optimal performance while staying within the given quota. Furthermore, notable among my rich skill set is my expertise in Chatbots and AI Automation. I have honed these skills through immersion with LangChain, Dialogflow, Rasa and can readily apply them to build an automated Whatsapp script that pulls data from Google Sheets into tailor-made alerts for your dispatch log. Whether you need to edit phone numbers or column names without hassle or employ the power of APIs for a microservices approach - rest assured I have everything under control.
₹12,000 INR in 2 days
4.7
4.7

Hello, I can deliver the Google Sheets to WhatsApp alerts efficiently with a lightweight script that watches the Status column, pulls the Docket Number and Client Name, and sends exactly once per event through Twilio. I will keep the setup flexible with editable config for recipients and column names, and provide clear README steps for Google and Twilio setup. With 5 plus years of experience, I can handle this cleanly. Send a message for a quick demo or similar samples. Thanks, Adegoke. M
₹7,500 INR in 3 days
4.0
4.0

The workflow you need depends on reliable event detection rather than constant polling, ensuring the first Status entry and the later Delivered update each trigger exactly one WhatsApp notification within your required timeframe. I will build a lightweight Python script that monitors the Google Sheet efficiently, extracts the Docket Number and Client Name, and sends dynamic WhatsApp messages through the Twilio API. Configuration such as recipients and column names will be kept in a simple .env or JSON file so future changes are straightforward. The code will be well commented, include a clear README for Google credentials and Twilio setup, and I will demonstrate both notification scenarios so you can verify the complete flow before delivery. Let's discuss your preferred deployment method and get started.
₹2,000 INR in 1 day
3.2
3.2

Hi, The dispatch log polling is the part I'd handle with Google Sheets API push notifications (webhooks via Apps Script) rather than a polling loop — that's how you hit the 30-second trigger window without hammering quota. Stack I'd use: - Python script with gspread + google-auth for Sheets API connection - Twilio WhatsApp integration for both status events - .env file for phone numbers, column names, and credentials - systemd service or cron to keep it running on your Linux server Message composition will insert the Docket Number and Client Name directly into the WhatsApp template strings, and I'll add a simple dedupe flag per row so each event fires exactly once. I've built Python automation scripts with webhook triggers and third-party API integrations in production — clean, commented code with a README is standard for me. One question: should the Twilio WhatsApp messages use pre-approved template messages (required for business-initiated conversations) or is this on a sandbox number for now?
₹12,500 INR in 2 days
0.0
0.0

Hi, This is a clean automation workflow, and I can deliver a reliable solution that reacts quickly and sends WhatsApp notifications without duplicates. I’d implement this using the Google Sheets API with efficient polling (or webhook if preferred), combined with a lightweight Python service that tracks row state to ensure each event triggers exactly once. Flow: * Monitor “Status” column changes * On first entry → send dispatch message (Docket + Client Name) * On “Delivered” update → send second notification * Maintain a small state store to prevent duplicate messages Integration: * Twilio WhatsApp API for message delivery * Configurable .env/JSON for phone numbers and column mapping * Clean, modular code with clear comments You’ll receive: * Ready-to-run script for Linux server * Step-by-step README (Google + Twilio setup) * Demo showing both trigger scenarios working in real time I focus on making these systems stable, simple to maintain, and easy to extend. Happy to discuss polling vs webhook approach depending on your preference. Best regards, Michael
₹7,000 INR in 7 days
0.0
0.0

Hello, I am a dedicated PHP web developer, I will create flow in your project description as long as the twilio API authentication given. I also have experience using twilio API in earlier, for laravel development website usage. Let's discuss the detail. Also please feel free to see my portfolios on my portfolio page.
₹7,000 INR in 7 days
0.0
0.0

Gurgaon, India
Payment method verified
Member since Feb 19, 2026
₹600-1500 INR
₹12500-37500 INR
₹12500-37500 INR
₹1500-12500 INR
₹1500-12500 INR
£250-750 GBP
₹10000-12000 INR
$30-250 USD
₹1500-12500 INR
$30-250 AUD
₹1500-12500 INR
$750-1500 USD
₹1500-12500 INR
$30-250 USD
₹1500-12500 INR
₹1500-12500 INR
$250-750 USD
₹150000-250000 INR
₹750-1250 INR / hour
$30-250 AUD
$250-750 USD
₹600-1500 INR
₹2500-5000 INR
$30-250 USD
₹1500-12500 INR