Searchbug SSN Name Match to Google Sheets via n8n Form Trigger

Validate SSN + Name submissions and log matched results to Google Sheets (via n8n)

This n8n automation workflow collects a first name, last name, and SSN from an n8n Form Trigger, checks the combination using the Searchbug SSN Name Match API, normalizes the response, and appends a consistent, masked-result row to Google Sheets—so your team can track verification outcomes reliably.

What this workflow does

• Receives form submissions for first name, last name, and SSN (supports full 9 digits or last-4) plus optional notes.
• Cleans and classifies SSN input by extracting digits only, determining whether it’s a full SSN or last-4, and generating an SSN masked value for storage.
• Calls Searchbug using the endpoint TYPE=api_ssnn, sending the name fields and cleaned SSN; the workflow continues even if the API returns an error.
• Normalizes Searchbug JSON into consistent columns (e.g., match result/score, SSN state/year/status, and any linked names/DOBs/cities) while keeping only the masked SSN.
• Appends to Google Sheets a new row including submission timestamp, notes, and all mapped result fields.

Use cases

• Capture SSN/name verification requests through an n8n form and maintain an audit trail in Google Sheets.
• Run repeatable checks for operational teams that need match_score, match_result, and ssn_type logged per submission.
• Centralize results for QA/review workflows where you must store masked SSNs and preserve API error information.

Technical details

• n8n nodes: set, sticky note, form trigger, http request, google sheets
• Searchbug credentials: provide CO_CODE and PASS in the HTTP request body parameters
• Google Sheets: configure the target spreadsheet document ID and the sheet/tab name; create headers matching the appended fields (e.g., submitted_at, fname, lname, ssn_masked, ssn_type, status, api_error, match_score, match_result, plus additional mapped result columns).