Lumekara
IDEN
All projects
Client Project: Automation

Devans Egg Partner Forms to WhatsApp

Reseller, partnership, tester, and giveaway forms that open WhatsApp with a prefilled message, with Google Sheets logging ready to switch on.

Status
Live
Layers
IntegrationAutomationFrontend
Used by
Would-be resellers, agents, business partners, and giveaway entrants, plus the owner who follows up with them.
Ask about this project
The Devans Egg reseller and agent section with its partner sign-up form; partner prices are blurred
Screenshot

The problem

Would-be resellers ask in chat without complete details, and the owner has no tidy record of who is interested.

The solution

One form component serves four purposes. On submit, WhatsApp opens with a ready-to-send message; when the Apps Script endpoint is set, the entry is also logged to Google Sheets with spam checks, plus a duplicate check for giveaway sign-ups.

How it works

What happens, step by step, from the user's point of view.

  1. 01

    The visitor picks a form

    There are forms for a free tester, reseller or agent, business partnership, and the giveaway. All four share one component.

  2. 02

    Short details, filled on phone

    The visitor enters their name, WhatsApp number, city, and what they need. Required fields and the number format are checked before sending.

  3. 03

    Bots are quietly filtered

    A hidden trap field (honeypot) and a minimum fill time catch bots. Their submissions look successful but go nowhere.

  4. 04

    WhatsApp opens, message ready

    After submitting, WhatsApp opens with a message containing those details. The visitor just taps send to the owner.

  5. 05

    Logging to Google Sheets

    Ready to switch on: once the Apps Script address is added, every submission lands in the owner's spreadsheet and an email alert goes out.

  6. 06

    Giveaway limited to its dates

    Giveaway entries are only accepted during its dates, and a number or Instagram account already entered is refused. This also runs once Sheets is switched on.

System design

Who uses it, what they see, what works behind the scenes, and where the data lives. Read it from left to right.

  1. 1Visitors

    • Prospective partnersResellers, agents, communities, or businesses wanting to team up

  2. 2What they see

    • Partner formsOne form for testers, resellers, partnerships, and the giveaway
    • Giveaway pageShows the giveaway dates and its sign-up form

  3. 3Behind the scenes

    • Form checkerChecks required fields, the WhatsApp number, and the bot trap in the browser
    • Google Apps ScriptReady to switch on: receives entries, checks spam and duplicates

  4. 4Where data goes

    • Owner's WhatsAppReceives the prefilled message from the visitor
    • Google SheetsThe owner's spreadsheet for logging and rating leads
    • Email alertTells the owner about each new lead, once switched on

Key features

  • One form, four purposes
  • Prefilled WhatsApp message
  • Google Sheets logging, ready
  • Honeypot and minimum fill time
  • Time-boxed giveaway sign-ups

Built with

  • React
  • TypeScript
  • Google Apps Script
  • Google Sheets
  • WhatsApp

What the business gets

  • Would-be resellers arrive with full details, not just "I have a question".
  • No server or paid CRM needed; the data lives in the owner's own Google Sheet.
  • Bot submissions never reach the owner's WhatsApp.
  • Once Sheets is switched on, the owner has a lead list they can mark with status and quality.

Terms on this page

Honeypot
A form field hidden from people; only bots fill it in, so their submissions are easy to spot.
Google Apps Script
Small code that runs free in the owner's Google account, here to receive form entries and write them to a spreadsheet.
Lead
A potential buyer or partner who has left their contact details and shown interest.

Can it work for your business?

For businesses that sell over WhatsApp: you get tidy lead data in a spreadsheet without paying for servers or a CRM.

Ask about this project