Confirm webinar places, waitlist the rest

Webinars have a limit, and people want to know where they stand. When someone submits your sign-up form, this counts the people already marked Confirmed in your sign-ups sheet. While there are places left, they are added as Confirmed and emailed a confirmation; once it is full they are added as Waitlisted and told so.

The form needs the questions Full name and Email, and the sheet the columns Name, Email and Status. Type the number of places when you set it up.

TypeformWhen someone submits a Typeform. Save it as signup.When someone submits a Typeform. Save it as signup.

Webinar sign-ups sheetSet sheetUrl to blank.

Number of places in the webinarSet places to 100.

People already confirmedRead the rows of sheetUrl. Save it as confirmed_so_far.Google Sheets

If confirmed_so_far.count is less than placesIf confirmed_so_far.count is less than places

Yes

Add them as confirmedAdd a row in sheetUrl. Save it as confirmed_row.Google Sheets

Email: your place is confirmedSend an email to signup.email. Save it as confirmation. Subject: You're signed up for the webinarHi signup.first_name, Your place in the webinar is confirmed. We'll send the joining details before it starts.Gmail

No

Add them to the waitlistAdd a row in sheetUrl. Save it as waitlist_row.Google Sheets

Email: you are on the waitlistSend an email to signup.email. Save it as waitlist_note. Subject: You're on the webinar waitlistHi signup.first_name, The webinar is full, so we've put you on the waitlist. If a place opens up we'll let you know.Gmail