Quick overview
Quick overview This workflow collects name and location details from an n8n form, searches the Searchbug People Search API for matching people, flattens the response into clean fields (addresses, phones, emails, relatives, and more), and appends each match as a new row in Google Sheets. How it works Receives a submission from an n8n Form with first name, last name, optional middle name and city, and a required US state. Builds the search parameters from the form values and calls the Searchbug People Search API via an HTTP request. Normalizes the API response by turning single-or-multiple result fields into arrays and extracting key profile attributes. Outputs one structured item per matching person (or a single “No results found” row) and appends the results to a Google Sheets tab. Setup Add your Searchbug credentials by filling in the CO_CODE and PASS query parameters in the HTTP Request configuration. Connect a Google Sheets OAuth credential. Replace the target Google Sheets document ID and sheet/tab name to point to your own spreadsheet. Create the sheet header row to match the columns being appended (for example: reportID, fullName, firstName, middleName, lastName, DOB, currentAge, deceased, SSN, primaryAddress, city, state, zip, primaryPhone, allPhones, allEmails, relatives, driversLicenseNumbers, bankruptcies, liens, judgements, reportToken). An n8n automation workflow template by Searchbug.
Searchbug
web
free
Others in the same category, ranked by how often they are opened.
