Drone Quote Calculator Web App
Budget: $250 – $750 USD
I need a lightweight web page that lets my uncle and me create spray-job quotes without touching spreadsheets. All item data already lives in a Google Sheet that stores only the item name and its base price. The app must:
• Authenticate visitors through Google OAuth and check the signed-in email against a simple whitelist I will maintain, so only approved addresses see the page.
• Read item names and prices from the existing Sheet, present them in a friendly interface, let us enter quantities, then calculate the total with a variable, per-quantity rate (price × quantity, plus room for a small future formula tweak).
• On submission, write the full quote—items, quantities, line totals, grand total, date, and the user’s email—to a separate “Quotes-Archive” Google Sheet for backup and tracking, while keeping the original price sheet untouched.
• Allow us to reopen any saved quote for quick edits and resave it.
Tech stack is up to you—Vanilla JS, React, Vue, or a lightweight Flask/Node backend—so long as it stays simple to host and relies on Google Sheets API for data operations. A clean, mobile-friendly UI is a bonus.
Acceptance will be based on:
1. Successful OAuth sign-in restricted to my whitelist.
2. Real-time price calculation from live Sheet data using quantity inputs.
3. Accurate write-back of each quote to the archive Sheet.
4. Clear deployment instructions so I can host it on Firebase, Vercel, or similar.
That’s the whole scope; keep it straightforward so two people can run it day to day.
• Authenticate visitors through Google OAuth and check the signed-in email against a simple whitelist I will maintain, so only approved addresses see the page.
• Read item names and prices from the existing Sheet, present them in a friendly interface, let us enter quantities, then calculate the total with a variable, per-quantity rate (price × quantity, plus room for a small future formula tweak).
• On submission, write the full quote—items, quantities, line totals, grand total, date, and the user’s email—to a separate “Quotes-Archive” Google Sheet for backup and tracking, while keeping the original price sheet untouched.
• Allow us to reopen any saved quote for quick edits and resave it.
Tech stack is up to you—Vanilla JS, React, Vue, or a lightweight Flask/Node backend—so long as it stays simple to host and relies on Google Sheets API for data operations. A clean, mobile-friendly UI is a bonus.
Acceptance will be based on:
1. Successful OAuth sign-in restricted to my whitelist.
2. Real-time price calculation from live Sheet data using quantity inputs.
3. Accurate write-back of each quote to the archive Sheet.
4. Clear deployment instructions so I can host it on Firebase, Vercel, or similar.
That’s the whole scope; keep it straightforward so two people can run it day to day.