Searchbug Contact Info API in n8n: Save Results to Google Sheets

Searchbug Contact Info API in n8n: Auto-save contact matches to Google Sheets

Turn an n8n form submission into verified contact lookup results. This workflow sends your search criteria to the Searchbug Contact Info API, then automatically appends any matching people or business records into Google Sheets—or returns a clear “no records found” message when nothing matches.

What this workflow does

• Receives search criteria from an n8n form trigger (e.g., name, company, address, phone, or email).
• Maps form fields to Searchbug API parameters and sends a POST request to the Searchbug Contact Info API (api_contact) requesting JSON output.
• Validates the API response by checking the response status and whether any records were returned.
• Flattens returned records into consistent columns (including fields like phone, address, and email).
• Appends results to Google Sheets by writing each matched record as a new row in the specified sheet/tab.
• Handles empty results by returning a “no records found” message when the API response is empty.

Use cases

• Lead enrichment: collect basic contact details from a form, enrich them via Searchbug, and store matches in Google Sheets.
• Sales ops workflows: batch-confirm phone/email/address matches and maintain an export-ready spreadsheet.
• Data collection tools: capture user inputs in n8n and immediately archive validated contact records for review.

Technical details

• Nodes/logic: form trigger, HTTP request, if, set, split out, and split/flatten handling (via node flow), plus sticky note for setup clarity.
• Searchbug API authentication: set CO_CODE and PASS in the HTTP request body.
• Google Sheets setup: connect an OAuth credential, provide the spreadsheet Document ID, and target the correct sheet/tab.
• Required header columns: FNAME, MNAME, LNAME, BNAME, PHONE, STREET, CITY, COUNTY, STATE, ZIP, EMAIL, DOB, AGE.

This n8n automation workflow is built specifically to save Searchbug contact matches into Google Sheets with reliable “no matches” handling.