Build Private Google Form + Apps Script Tool for Behavioural Scoring (Future Licensing Tool)
I’m looking for an experienced freelancer to help me build a secure, private-use tool using Google Forms, Google Sheets, and Google Apps Script
This tool is part of a licensed behaviour and emotion analysis framework I’ve developed called **Affect to Action™. It helps identify someone’s emotional state using three numeric inputs — Enjoyment, Excitement, and Power — and calculates the closest emotional match from a predefined database using distance-based logic (already built in Excel).
What You'll Be Building:
* A branded Google Form with inputs for:
Name Email Three numeric scores (0–100) A linked Google Sheet to store and process responses A hidden scoring engine (using Apps Script or protected formulas) to:
Calculate emotional distance Match the closest emotion Return a recommended shift strategy Display the result privately to me — possibly also emailed to user Ensure logic is protected and cannot be reverse-engineered Build in future-proofing for licensing and restricted access
Assets Provided:
Existing Excel file with scoring logic and emotion mapping Shift strategy text for each emotion Sample form content Brand colours/logo if needed
Deliverables:
Fully functional and secure Google Form + Sheet + Script Logic hidden from end-users Instruction guide or Loom walkthrough Optional: embedded result view or admin dashboard
Important:
This tool is proprietary IP and will be licensed in future. It must be:
Fully private and secure Not copied, reused, or shared Configured so I retain full control over access and usage
To Apply:
Please send:
Examples of relevant work (Forms + Apps Script) Brief outline of how you’d approach scoring and security and how I can give access manually per user and they don't have access to use more than once at this stage Your fixed quote + delivery estimate
