Android Delivery Notification App
Budget: ₹600 – ₹1,500 INR
I have a Google Spreadsheet that logs our daily dispatches, and I want an AppSheet-based Android app that sits on top of that sheet. When a row is marked “Ready to ship”, the app should automatically pop up a pre-filled personal WhatsApp message to the customer letting them know their parcel is on the way. In addition, the same trigger needs to fire an email and an SMS with identical content so every customer receives the update through all three channels.
Key points of the build
• Data source is a single Google Sheet already structured with customer name, phone, email, order ID and status.
• The app must run on Android phones used by our dispatch team; no iOS support is required for now.
• WhatsApp messages must send from the user’s own WhatsApp account, not a business API, so the flow should open WhatsApp with the text ready for manual send and then return to the app.
• Email and SMS can be handled by AppSheet’s native actions or an attached Apps Script/Twilio—whichever is fastest and within AppSheet limits.
• Once messages are sent, the row should update to “Notified” with a timestamp so we can easily filter what still needs attention.
Deliverables
1. Fully functional AppSheet app linked to my Google Sheet, deployed for Android.
2. Tested workflows for WhatsApp, Email, and SMS notifications with clear setup instructions.
3. Brief written guide so I can adjust templates or add columns later without breaking the automations.
Key points of the build
• Data source is a single Google Sheet already structured with customer name, phone, email, order ID and status.
• The app must run on Android phones used by our dispatch team; no iOS support is required for now.
• WhatsApp messages must send from the user’s own WhatsApp account, not a business API, so the flow should open WhatsApp with the text ready for manual send and then return to the app.
• Email and SMS can be handled by AppSheet’s native actions or an attached Apps Script/Twilio—whichever is fastest and within AppSheet limits.
• Once messages are sent, the row should update to “Notified” with a timestamp so we can easily filter what still needs attention.
Deliverables
1. Fully functional AppSheet app linked to my Google Sheet, deployed for Android.
2. Tested workflows for WhatsApp, Email, and SMS notifications with clear setup instructions.
3. Brief written guide so I can adjust templates or add columns later without breaking the automations.