Bibliothek / Sicherheit & Compliance
Sicherheit & Compliance
Telefonnummern per SMS-OTP verifizieren und bestätigte Nummern in Google Sheets protokollieren
Webhook-gesteuerter Ablauf, der einen 6-stelligen SMS-Code an eine Telefonnummer sendet, ihn innerhalb von fünf Minuten einmal prüft und bestätigte Nummern in einem Google Sheet protokolliert.
Was sie bewirkt
## Verify phone numbers with a one-time SMS code (OTP) ### How it works Two webhooks give your sign-up or checkout form a phone verification step, with no code to host: 1. Request a code (POST /sms-otp/send with { "phone": "..." }) checks the number and sends a 6-digit code by SMS with the generate_otp tool of the SMS Vert Pro MCP server. The code is valid for 5 minutes. 2. Check a code (POST /sms-otp/verify with { "phone": "...", "code": "123456" }) checks it with verify_otp. A code works only once. 3. Each verified number is added to a Google Sheet with the date, and the form gets a clear JSON answer: 200, 400 (invalid number), 401 (wrong or expired code), 429 (a code was already sent a moment ago). ### Setup steps 1. Create a Google Sheet with the columns phone and verified_at, and connect your Google account in Log verified number. 2. Create a Bearer Auth credential with your SMS Vert Pro API V2 token (log in at smsvertpro.com, then open https://www.smsvertpro.com/api/doc-v2.php) and select it in the two MCP Client nodes. 3. In OTP settings, set your sender name (11 characters max), your sheet URL, your default country code (numbers starting with 0 are converted) and the country codes you accept. 4. Activate the workflow and call the two production webhook URLs from your form. ### Customization Replace the Google Sheet with your CRM or database, or add a step that unlocks the user account once the number is verified.
Die Schritte
- Request a code
- Check a code
- OTP settings
- Read request
- Valid request?
- Respond: invalid request
- Send or check?
- Send code by SMS
- Code sent?
- Respond: code sent
- Respond: code not sent
- Check code
- Code valid?
- Log verified number
Insgesamt 16 Schritte.
Ähnliche Automatisierungen
Chatbots & Messaging-BotsSMS-Kursassistent mit Twilio, Airtable und OpenAI11 SchritteWarnungen & BenachrichtigungenSMS-Nachrichten weltweit senden13 SchritteKalender & TerminplanungZweiseitige SMS-Terminerinnerungen mit VoxiSMS und PostgreSQL versenden20 SchritteE-Mail-AutomatisierungFormularübermittlungen in Google Sheets protokollieren und OTP-Bestätigungscodes per SMTP per E-Mail senden14 Schritte