{"product_id":"n8n-background-checks-searchbug-api-to-google-sheets","title":"n8n Background Checks: Searchbug API to Google Sheets","description":"\u003ch3\u003eInstant background lookup → Google Sheets row (powered by Searchbug \u0026amp; n8n Forms)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures a person’s details from an n8n Form, performs a two-step background check using the \u003cstrong\u003eSearchbug API\u003c\/strong\u003e (People Search + Background Check), parses key fields, and automatically \u003cstrong\u003eappends the results to a Google Sheets worksheet\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects inputs\u003c\/strong\u003e from an \u003cstrong\u003en8n Form\u003c\/strong\u003e: first name, last name, state, plus optional middle name and city.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns Searchbug People Search\u003c\/strong\u003e (\u003cem\u003eapi_ppl\u003c\/em\u003e) to find matching records and retrieve a \u003cem\u003ereportToken\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf \u003cstrong\u003eno person is found\u003c\/strong\u003e, returns a \u003cstrong\u003e“No people found”\u003c\/strong\u003e message as the form response.\u003c\/li\u003e\n  \u003cli\u003eIf a match is found, \u003cstrong\u003ecalls Searchbug Background Check\u003c\/strong\u003e (\u003cem\u003eapi_back\u003c\/em\u003e) using the \u003cem\u003ereportToken\u003c\/em\u003e to retrieve the full report.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses and flattens report fields\u003c\/strong\u003e such as: name, DOB, SSN, addresses, phones, emails, relatives, business associations, lien totals, and more.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends a new row\u003c\/strong\u003e to the selected \u003cstrong\u003eGoogle Sheets tab\u003c\/strong\u003e with parsed values.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eOperators need a streamlined \u003cstrong\u003ebackground-check request workflow\u003c\/strong\u003e that turns form submissions into structured Google Sheets records.\u003c\/li\u003e\n  \u003cli\u003eSaaS teams building applicant screening intake can log key Searchbug report fields immediately for review.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers want a clear example of chaining \u003cstrong\u003eSearchbug API calls\u003c\/strong\u003e and writing normalized data to Sheets.\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: \u003cem\u003eForm Trigger\u003c\/em\u003e, \u003cem\u003eHTTP Request\u003c\/em\u003e (Searchbug), \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003esticky note\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearchbug integrations\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cem\u003eapi_ppl\u003c\/em\u003e (People Search) to obtain \u003cem\u003ereportToken\u003c\/em\u003e using CO_CODE and PASS.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cem\u003eapi_back\u003c\/em\u003e (Background Check) to fetch the report using CO_CODE, PASS, and the \u003cem\u003ereportToken\u003c\/em\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: OAuth connection + target spreadsheet ID + worksheet name; append action requires headers matching the written columns (e.g., REPORT_TOKEN, FULL_NAME, DOB, SSN, ADDRESS, CITY, STATE, ZIP, PHONES, EMAILS, RELATIVE_COUNT, RELATIVE_NAMES, BUSINESS_NAME, SHARED_SSN_NAME, LIEN_COUNT, TOTAL_LIEN_AMOUNT, SEARCH_DATE, RAW_RESPONSE).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45824201687219,"sku":"N8N-18172","price":4.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Ji5RuTNszvKV2zZrhvpHo_95f9vU9Z.png?v=1786612170","url":"https:\/\/buyflowscripts.com\/products\/n8n-background-checks-searchbug-api-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}