How to turn a messy waitlist into a launch-ready pipeline

A waitlist is not one audience. It includes people who need your product now, people who may need it later, and people who are simply curious.

Here's a workflow that reviews each signup, groups similar people together, and helps you focus on the people who are most likely to buy.

The tools

• Jotform: Creates the waitlist form and collects signup information.
• Zapier Professional or higher: Moves the signup between the tools, classifies it with AI, and chooses the correct email path. (Note: AI by Zapier and Paths are not available on the Free plan.)
• Google Sheets: Saves the signup and its launch group.
• Gmail: Sends a different welcome email to each group.

Step 1 — Define your three launch paths first

Don't begin by creating the form. First, open a blank document and create these groups:

1. Beta: Good fit and urgently needs a solution.
2. Nurture: Possible fit, but the problem isn't urgent.
3. Education: Wrong fit or just exploring.

Then write one sentence that describes your ideal customer.

Here's an example: Our target customer is a SaaS founder with a team of 2–20 people who manually tracks customer onboarding.

Later, you will use this sentence in the AI prompt so the AI knows who your ideal customer is.

Step 2 — Build a waitlist form that captures buying signals

Open your Jotform workspace.

• Click: Create
• Click: Form
• Select: Start From Scratch
• Select: Classic Form

In the Form Builder:

• Click: Add Form Element
• Open: Basic

Add these fields:

• Name
• Email
• Which option best describes your role?
• How large is your company or team?
• What problem are you trying to solve?
• When do you need a solution?
• How would you use this product?

Make the urgency question a Single Choice field.

Use options like these:

• I need a solution this week
• I need a solution this month
• I may need it later
• I am just exploring

Avoid questions like, "How interested are you?" Many people say they are interested even when they are not ready to buy. Asking when they need a solution gives you a better buying signal.

For the problem question, add this description (or something similar): "Be specific. What are you doing now, and what is going wrong?" This helps people explain the problem they have today instead of giving a general answer like "I want to save time."

When the form is ready:

• Click: Publish
• Click: Copy Link

The shareable form link is in the Publish section.

Step 3 — Create the waitlist sheet

Open Google Sheets.

• Create: Blank spreadsheet
• Name the sheet: Launch Waitlist
• Add these headers to row 1: Date, Name, Email, Role, Company Size, Problem, Urgency, Use Case, Pain Segment, Intent Level, Fit, Score, Launch Group, Reason

The first row must contain the headers. Zapier uses them to know where to save each value

Step 4 — Trigger the workflow from a new signup

Before you open Zapier, submit your Jotform once using realistic answers. Use an example that is a strong fit and needs an urgent solution. Zapier will use this submission to test the workflow.

Now, open Zapier.

• Click: Create
• Click: Zap
• Click: Trigger
• Search: Jotform
• Select: Jotform
• Select event: New Submission (Instant)
• Connect: Your Jotform account
• Select: Your waitlist form
• Click: Test trigger

Publish your form before connecting it to Zapier.

If the test is successful, you should now see the answers from your submission inside Zapier.

Step 5 — Classify and score the signup

Click: +

• Search and Select: AI by Zapier

• Select: The lowest-cost text model available in your account

Paste this prompt (or something similar):

Classify each person who joins this product waitlist.

Target roles: [INSERT YOUR TARGET ROLES]
Target company sizes: [INSERT YOUR TARGET COMPANY SIZES]
Allowed pain segments: [INSERT 3 TO 5 PAIN LABELS]

Review this signup:
Role: {{Role}}
Company size: {{Company Size}}
Problem: {{Problem}}
Urgency: {{Urgency}}
Use case: {{Use Case}}

Return these fields only:
Pain_segment
Intent_level
Fit
Score
Launch_group
Reason

Calculate the score:
+4 if urgency is "I need a solution this week" or "I need a solution this month"
+2 if urgency is "I may need it later"
+0 if urgency is "I am just exploring"
+2 if the problem is specific
+2 if the use case is clear
+2 if the role and company size match the target profile

Maximum score: 10

Assign launch_group:
beta = score 8-10 and fit is core
nurture = score 4-7 and fit is not wrong
education = score 0-3 or fit is wrong

Write the reason as one short sentence. Return only the requested fields.

Open: Settings → Output Fields
Add:

• Pain_segment
• Intent_level
• Fit
• Score
• Launch_group
• Reason
  Click: Preview

Review the output before moving on. The launch_group should only be beta, nurture, or education. Otherwise, the next Path may not work.

Step 6 — Save the result before sending anything

Click: +

• Search: Google Sheets
• Select event: Create Spreadsheet Row
• Select spreadsheet: Launch Waitlist

Map each Jotform answer and AI output to its matching column.

Click: Test step

Open the spreadsheet and make sure the test created one complete row.

Step 7 — Send each signup down the correct path

Click: +

Search: Paths

Create three branches.

1st path: Beta

• Name: Beta
• Set the rule: _launch\group exactly matches beta.
• Add: _Gmail_Select event: Send Email
• Use this subject (or something similar): “You may be a strong fit for our beta”

Use this email body (or something similar): "Thanks for joining. You look like a good fit for our beta. Reply and tell us what tool or process you use today and what is not working well."

2nd path: Nurture

• Name: Nurture
• Set the rule: _launch\_grou_p exactly matches nurture.
• Send helpful information instead of a beta invitation.
• End with this question (or something similar): “What would need to happen for this problem to become urgent?”

Their answer may show they are ready to join the beta.

3rd path: Education

• Name: Education
• Set the rule_: launch\group exactly matches education.

Send educational content that explains the problem your product solves. Don't invite them to the beta at this stage.

Step 8 — Create the weekly launch-readiness report

Create a second sheet.
Name it: Summary.

Enter the following values and formulas:

• A1: Group
• B1: Count
• A2: beta
• B2: =COUNTIF(Signups!K:K,"beta")
• A3: nurture
• B3: =COUNTIF(Signups!K:K,"nurture")
• A4: education
• B4: =COUNTIF(Signups!K:K,"education")

Create a second Zap.

• Select trigger: Schedule by Zapier
• Select event: Every Week
• Choose day: Monday
• Choose time: 9:00 AM

Add a Google Sheets action:

• Select event: Lookup Spreadsheet Row
• Select spreadsheet: Launch Waitlist
• Select worksheet: Summary
• Select lookup column: Group
• Enter lookup value: beta

Duplicate this action twice. Change the lookup value to nurture in the second action and education in the third. Each action will return that group’s count.

Finally:

• Add: Gmail
• Select event: Send Email
• Use this subject (or something similar): “Weekly waitlist readiness: {{beta count}} beta candidates”

Include the beta, nurture, and education counts in the email, along with a link to the spreadsheet.

Test before launch

Submit five test signups:

• Strong fit
• Wrong fit
• Urgent
• Low urgency
• Vague

Check that each signup receives the correct score, launch group, and email. Fix any problems before publishing.