{"product_id":"searchbug-ssn-name-match-to-google-sheets-via-n8n-form-trigger","title":"Searchbug SSN Name Match to Google Sheets via n8n Form Trigger","description":"\u003ch3\u003eValidate SSN + Name submissions and log matched results to Google Sheets (via n8n)\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n automation workflow\u003c\/strong\u003e collects a first name, last name, and SSN from an \u003cstrong\u003en8n Form Trigger\u003c\/strong\u003e, checks the combination using the \u003cstrong\u003eSearchbug SSN Name Match API\u003c\/strong\u003e, normalizes the response, and \u003cstrong\u003eappends a consistent, masked-result row to Google Sheets\u003c\/strong\u003e—so your team can track verification outcomes reliably.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives form submissions\u003c\/strong\u003e for \u003cem\u003efirst name\u003c\/em\u003e, \u003cem\u003elast name\u003c\/em\u003e, and \u003cem\u003eSSN\u003c\/em\u003e (supports full 9 digits or last-4) plus optional notes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCleans and classifies SSN input\u003c\/strong\u003e by extracting digits only, determining whether it’s a full SSN or last-4, and generating an \u003cstrong\u003eSSN masked\u003c\/strong\u003e value for storage.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls Searchbug\u003c\/strong\u003e using the endpoint \u003cstrong\u003eTYPE=api_ssnn\u003c\/strong\u003e, sending the name fields and cleaned SSN; the workflow \u003cstrong\u003econtinues even if the API returns an error\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes Searchbug JSON\u003c\/strong\u003e into consistent columns (e.g., match result\/score, SSN state\/year\/status, and any linked names\/DOBs\/cities) while keeping only the \u003cstrong\u003emasked SSN\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends to Google Sheets\u003c\/strong\u003e a new row including submission timestamp, notes, and all mapped result fields.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCapture SSN\/name verification requests through an \u003cstrong\u003en8n form\u003c\/strong\u003e and maintain an audit trail in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eRun repeatable checks for operational teams that need \u003cstrong\u003ematch_score\u003c\/strong\u003e, \u003cstrong\u003ematch_result\u003c\/strong\u003e, and \u003cstrong\u003essn_type\u003c\/strong\u003e logged per submission.\u003c\/li\u003e\n  \u003cli\u003eCentralize results for QA\/review workflows where you must store \u003cstrong\u003emasked SSNs\u003c\/strong\u003e and preserve API error information.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e set, sticky note, form trigger, http request, google sheets\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearchbug credentials:\u003c\/strong\u003e provide \u003cem\u003eCO_CODE\u003c\/em\u003e and \u003cem\u003ePASS\u003c\/em\u003e in the HTTP request body parameters\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e configure the target spreadsheet document ID and the sheet\/tab name; create headers matching the appended fields (e.g., \u003cem\u003esubmitted_at, fname, lname, ssn_masked, ssn_type, status, api_error, match_score, match_result\u003c\/em\u003e, plus additional mapped result columns).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45824201523379,"sku":"N8N-18175","price":29.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/faJAHnM4KEUFyAmCVEZKk_ZPH5pIMZ.png?v=1786612080","url":"https:\/\/buyflowscripts.com\/products\/searchbug-ssn-name-match-to-google-sheets-via-n8n-form-trigger","provider":"N8N Commerce","version":"1.0","type":"link"}