Searchbug NAP+E Lookup in n8n: Form to Google Sheets

Instantly run Searchbug NAP+E lookups from an n8n form and log matches to Google Sheets

This n8n workflow lets you submit search details via an n8n form, query the Searchbug NAP+E endpoint (api_nape), and automatically append any returned person/business matches to Google Sheets—or return a clear “No records found” message when nothing matches.

What this workflow does

• Receives a submission from an n8n form, where you select a search type and enter any known person or business details.
• Maps form inputs into the Searchbug NAP+E API parameters, including using the correct subtype for phone-only or email-only lookups.
• Sends a POST request to the Searchbug API and checks the response status and whether any records were returned.
• Normalizes the API response so each match becomes a separate item, while keeping shared metadata (source and found flags).
• Transforms returned fields into a consistent schema (e.g., name, business, address, phone, email, plus status/error fields).
• Appends each matched record to a new row in your configured Google Sheets worksheet. If the API returns no results, it responds with a “No records found” outcome.

Use cases

• Verify and enrich inbound leads by running Searchbug NAP+E queries directly from an n8n intake form.
• Support data-quality workflows: capture phone/email from a form, look up matching records, and store results for review in Google Sheets.
• Build a lightweight SaaS operator/admin process to track search outcomes and errors across multiple submissions.

Technical details

• Nodes / logic: if, set, code, sticky note, form trigger, http request.
• Searchbug credentials: provide CO_CODE and PASS in the HTTP request body.
• Google Sheets: connect OAuth, set the target spreadsheet (Document ID) and worksheet name.
• Required sheet headers: STATUS, SRC, PHFND, ADFND, EMFND, FNAME, LNAME, BNAME, PHONE, ADDRESS, CITY, STATE, ZIP, EMAIL, ERROR.

Perfect for n8n users and automation engineers who need Searchbug NAP+E lookup automation with reliable Google Sheets logging.