Waitlist form stored in GoogleSheet with email verification step

Instructions

This automation streamlines the process of collecting user information using a Form Node, enabling individuals to join a waitlist managed via Google Sheets.

It also generates a verification code, prompting users to input this code in the Second Form Step. If the code is nvalid, the workflow keeps the user in a verification loop until a valid code is entered.

Once a valid code is provided, the workflow proceeds to the final step, where additional information can be collected.

All entered data and intermediate states are securely stored in the Google Sheet.

Structure of the GoogleSheet

Firstname | Lastname | Email | Company | Verification-Code | Verified | Intended Use Marcel | Claus-Ahrens | foo[at]bar| foobar | abc123 | TRUE | Just testing

Setup