{"product_id":"n8n-sms-otp-verify-workflow-with-google-sheets-logging","title":"n8n SMS OTP Verify Workflow with Google Sheets Logging","description":"\u003ch3\u003eSend and verify SMS OTPs with n8n—then log verified numbers to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation workflow provides two webhook endpoints to \u003cstrong\u003esend\u003c\/strong\u003e and \u003cstrong\u003everify\u003c\/strong\u003e 6-digit SMS one-time codes via \u003cstrong\u003eSMS Vert Pro MCP\u003c\/strong\u003e, and automatically \u003cstrong\u003elogs successfully verified phone numbers\u003c\/strong\u003e with timestamps into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExposes two webhook endpoints\u003c\/strong\u003e: \u003ccode\u003e\/sms-otp\/send\u003c\/code\u003e to initiate an OTP SMS, and \u003ccode\u003e\/sms-otp\/verify\u003c\/code\u003e to validate an OTP.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAccepts POST requests\u003c\/strong\u003e and normalizes the submitted phone number.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates inputs\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eChecks the phone number against \u003cem\u003eallowed country codes\u003c\/em\u003e.\u003c\/li\u003e\n      \u003cli\u003eFor verification, ensures the OTP is a \u003cstrong\u003e6-digit number\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns proper error responses\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003ccode\u003e400\u003c\/code\u003e for invalid requests.\u003c\/li\u003e\n      \u003cli\u003e\n\u003ccode\u003e429\u003c\/code\u003e for send requests when a recent code already exists.\u003c\/li\u003e\n      \u003cli\u003e\n\u003ccode\u003e401\u003c\/code\u003e when the OTP is wrong or expired.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends OTPs\u003c\/strong\u003e by calling SMS Vert Pro MCP \u003ccode\u003egenerate_otp\u003c\/code\u003e and returns success or an error response.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eVerifies OTPs\u003c\/strong\u003e by calling SMS Vert Pro MCP \u003ccode\u003everify_otp\u003c\/code\u003e. \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs verification results\u003c\/strong\u003e: when the OTP is valid, it appends \u003ccode\u003ephone\u003c\/code\u003e and \u003ccode\u003everified_at\u003c\/code\u003e to Google Sheets, then returns a \u003cstrong\u003e200 “verified”\u003c\/strong\u003e response.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eEnable SMS OTP verification for an n8n-powered signup or account recovery flow.\u003c\/li\u003e\n  \u003cli\u003eValidate customers’ phone numbers and maintain an audit trail in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eBuild a lightweight authentication layer for internal SaaS or onboarding processes.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e SMS Vert Pro MCP (API V2 token via Bearer Auth) and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e \u003ccode\u003ewebhook\u003c\/code\u003e, \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003egoogle sheets\u003c\/code\u003e, plus a \u003ccode\u003esticky note\u003c\/code\u003e for workflow documentation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfig you set:\u003c\/strong\u003e sender name, Google Sheet URL, default country code, and allowed country codes list.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46217899147443,"sku":"N8N-20862","price":27.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/7hg3WINW-aA2ACDYUlNh5_0sbM9cRO.png?v=1791882200","url":"https:\/\/buyflowscripts.com\/products\/n8n-sms-otp-verify-workflow-with-google-sheets-logging","provider":"N8N Commerce","version":"1.0","type":"link"}