Look up contact details with Searchbug NAP+E 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 8 nodes and runs when someone submits an n8n form (“Searchbug Contact Lookup”). 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 (“Searchbug Contact Lookup”).
- Set Search Input (Edit Fields (Set)): sets 12 fields: SUBTYPE, FNAME, LNAME…
- NAP+E API (HTTP Request): calls data.searchbug.com (POST)
- Check Status (If): checks a condition and branches into true / false
- Normalize Record (Code): runs custom JavaScript code
- No Records Found (Edit Fields (Set)): sets 2 fields: message, api_status
- Map Fields (Edit Fields (Set)): sets 15 fields: STATUS, SRC, PHFND…
- Save to Google Sheets (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 - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow collects search inputs from an n8n form, queries the Searchbug NAP+E (apinape) endpoint for name, address, phone, and email matches, then writes any returned records to Google Sheets and returns a no-results message when nothing…