Match SSN and name from a web form with Searchbug and Google Sheets
Ready for 3.0What this workflow does
This workflow has 10 nodes and runs when someone submits an n8n form (“SSN + Name Verification”). Along the way it connects Google Sheets. It also calls data.searchbug.com over HTTP.
How it runs
Trigger: When someone submits an n8n form (“SSN + Name Verification”).
- Single or Bulk? (If): checks a condition and branches into true / false
- Normalize Input (Edit Fields (Set)): sets 4 fields: First Name, Last Name, SSN…
- Extract CSV (Extract from File): extracts data from a file
- Prepare Request Data (Edit Fields (Set)): sets 6 fields: fname, lname, notes…
- Validate Input (If): checks a condition and branches into true / false
- Searchbug SSN Match API (HTTP Request): calls data.searchbug.com (POST)
- Set Invalid Result (Edit Fields (Set)): sets 21 fields: submitted_at, fname, lname…
- Normalize Result (Edit Fields (Set)): sets 21 fields: submitted_at, fname, lname…
- Append to Google Sheet (Google Sheets): append
Services it uses
HTTP calls to: data.searchbug.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- n8n Form Trigger
n8n-nodes-base.formTrigger - If
n8n-nodes-base.if - Extract from File
n8n-nodes-base.extractFromFile - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow collects a first name, last name, and SSN via an n8n form, checks the combination using the Searchbug SSN Name Match API, and appends a normalized, masked-result record to Google Sheets. How it works 1. Receives a submission from…