{"product_id":"searchbug-people-search-api-google-sheets-via-n8n-form","title":"Searchbug People Search API → Google Sheets via n8n Form","description":"\u003ch3\u003eTurn an n8n Form submission into Google Sheets results with the Searchbug People Search API\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation workflow captures a person’s name and location from an \u003cstrong\u003en8n Form\u003c\/strong\u003e, searches the \u003cstrong\u003eSearchbug People Search API\u003c\/strong\u003e for matching people, normalizes the results into clean fields, and \u003cstrong\u003eappends one row per match\u003c\/strong\u003e into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives form data\u003c\/strong\u003e from an n8n Form: first name, last name, optional middle name, optional city, and a required US state.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds search parameters\u003c\/strong\u003e from the submitted values and sends an \u003cstrong\u003eHTTP request\u003c\/strong\u003e to the \u003cstrong\u003eSearchbug People Search API\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes the API response\u003c\/strong\u003e by converting single-or-multiple fields into arrays and extracting key profile attributes (including address, phone, email, relatives, and more).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOutputs structured items\u003c\/strong\u003e: either one item per matching person, or a single \u003cstrong\u003e“No results found”\u003c\/strong\u003e row.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends results to Google Sheets\u003c\/strong\u003e, adding each match as a new row in your selected tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLead verification\u003c\/strong\u003e: collect candidate details via n8n Form and store Searchbug-matched identity data in Google Sheets for review.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnriched intake workflows\u003c\/strong\u003e for SaaS operations: capture request data, run People Search, and log normalized fields for downstream processes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompliance-oriented record keeping\u003c\/strong\u003e: centralize results such as addresses, phones, emails, relatives, and related identifiers into a spreadsheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/stack\u003c\/strong\u003e: set, code, sticky note, form trigger, http request, google sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAPI authentication\u003c\/strong\u003e: provide Searchbug credentials via \u003cstrong\u003eCO_CODE\u003c\/strong\u003e and \u003cstrong\u003ePASS\u003c\/strong\u003e query parameters in the HTTP Request configuration.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration\u003c\/strong\u003e: use Google Sheets OAuth, then update the spreadsheet document ID and tab name.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired sheet headers\u003c\/strong\u003e: configure columns to match the appended fields (for example: \u003cem\u003ereportID, fullName, firstName, middleName, lastName, DOB, currentAge, deceased, SSN, primaryAddress, city, state, zip, primaryPhone, allPhones, allEmails, relatives, driversLicenseNumbers, bankruptcies, liens, judgements, reportToken\u003c\/em\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45785612157107,"sku":"N8N-17923","price":45.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/kCDzUS0s5QCB-w2GVzR0z_KY4pFW0u.png?v=1786179908","url":"https:\/\/buyflowscripts.com\/products\/searchbug-people-search-api-google-sheets-via-n8n-form","provider":"N8N Commerce","version":"1.0","type":"link"}