Zum Inhalt springen
NEUMarktplatz und dein Team: Verkaufe, was du baust, und bekomm Pläne und Änderungen, die getestet sind, bevor du sie siehst. Neuigkeiten ansehen

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

  1. Request a code
  2. Check a code
  3. OTP settings
  4. Read request
  5. Valid request?
  6. Respond: invalid request
  7. Send or check?
  8. Send code by SMS
  9. Code sent?
  10. Respond: code sent
  11. Respond: code not sent
  12. Check code
  13. Code valid?
  14. Log verified number

Insgesamt 16 Schritte.

Ähnliche Automatisierungen