{"product_id":"searchbug-people-trace-to-google-sheets-via-n8n-form","title":"Searchbug People Trace to Google Sheets via n8n Form","description":"\u003ch3\u003eSearchbug People Trace to Google Sheets—instantly from an n8n Form\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow collects person details through an \u003cstrong\u003en8n Form\u003c\/strong\u003e, runs the best-match \u003cstrong\u003eSearchbug People Trace\u003c\/strong\u003e lookup (via the \u003cstrong\u003eapi_trace\u003c\/strong\u003e endpoint), normalizes the results, and appends one row per record to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—including validation errors and “skipped” notices when required fields are missing.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives form submissions\u003c\/strong\u003e from an n8n Form with optional SSN, name, and address fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects the strongest search strategy\u003c\/strong\u003e available based on which inputs are present: SSN, address + city + state, or name combinations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates required fields\u003c\/strong\u003e. If the submission can’t support a required lookup path, the workflow marks the request as \u003cstrong\u003eskipped\u003c\/strong\u003e and writes an \u003cstrong\u003eerror message\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls the Searchbug People Trace API\u003c\/strong\u003e using a POST request to \u003cstrong\u003eapi_trace\u003c\/strong\u003e, continuing even if the API returns an error.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and formats output\u003c\/strong\u003e: produces \u003cstrong\u003eone output row per returned record\u003c\/strong\u003e, formats values like \u003cstrong\u003edates\u003c\/strong\u003e and \u003cstrong\u003ephone numbers\u003c\/strong\u003e, and \u003cstrong\u003emasks SSN to the last 4 digits\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends results to Google Sheets\u003c\/strong\u003e under your chosen tab, capturing success, no results, error, or skipped outcomes (including fields such as input_row_id, api_status, full_name, address, phone, and error_message).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCapture lead or case inputs in an n8n Form and enrich them with Searchbug People Trace results stored in a Google Sheet.\u003c\/li\u003e\n  \u003cli\u003eRun automated validation: if a user submits insufficient data, record a clear “skipped” error row for auditability.\u003c\/li\u003e\n  \u003cli\u003eOperational reporting: track api_status and trace outcomes over time by appending normalized records to a single tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/logic:\u003c\/strong\u003e if, set, code, sticky note, form trigger, http request\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExternal integration:\u003c\/strong\u003e Searchbug People Trace API (\u003cstrong\u003eapi_trace\u003c\/strong\u003e)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e configurable spreadsheet ID and sheet\/tab name for appending rows\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCredential parameters:\u003c\/strong\u003e add \u003cstrong\u003eCO_CODE\u003c\/strong\u003e and \u003cstrong\u003ePASS\u003c\/strong\u003e in the HTTP request body\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45899951538355,"sku":"N8N-18712","price":58.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/PYYBwbtBMviM0m0A4QE1q_Y1nZoApQ.png?v=1787735257","url":"https:\/\/buyflowscripts.com\/products\/searchbug-people-trace-to-google-sheets-via-n8n-form","provider":"N8N Commerce","version":"1.0","type":"link"}