Trace people and address history with Searchbug and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 16 nodes and runs when someone submits an n8n form (“People Trace Search”). 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 (“People Trace Search”).
- Single or Bulk? (If): checks a condition and branches into true / false
- Normalize Input (Edit Fields (Set)): sets 8 fields: First Name, Middle Name, Last Name…
- Extract CSV (Extract from File): extracts data from a file
- Detect Search Type (Edit Fields (Set)): sets 2 fields: input_row_id, search_type
- Build API Params (Edit Fields (Set)): sets 9 fields: skip, req_REF, req_SSN…
- Dedupe Subjects (Code): runs custom JavaScript code
- Has Search Fields? (If): checks a condition and branches into true / false
- Skipped Row (Edit Fields (Set)): sets 2 fields: api_status, error_message
- People Trace API (HTTP Request): calls data.searchbug.com (POST)
- Save Trace Detail (Google Sheets): append
…plus 5 more steps. See the full node list below.
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 (7)
- 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 - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow collects person details via an n8n Form, chooses the best Searchbug People Trace (apitrace) lookup method, and writes normalized trace results (or validation errors) to Google Sheets. How it works 1. Receives form submissions with…