{"product_id":"searchbug-criminal-records-api-to-google-sheets-n8n-workflow","title":"Searchbug Criminal Records API to Google Sheets (n8n Workflow)","description":"\u003ch3\u003eInstantly send criminal records searches to Google Sheets from an n8n form\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow collects a person’s details via an n8n Form, runs a \u003cstrong\u003eSearchbug Criminal Records API\u003c\/strong\u003e lookup, flattens the results into offense-level rows, and \u003cstrong\u003eappends everything to Google Sheets\u003c\/strong\u003e in the \u003cem\u003eCriminal Records\u003c\/em\u003e tab.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives submission inputs\u003c\/strong\u003e from an n8n Form: first name, last name, and state (with optional middle name, city, date of birth, and SSN).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFormats parameters for Searchbug\u003c\/strong\u003e to match the API requirements (using the submitted fields as input).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a POST request\u003c\/strong\u003e to the \u003cstrong\u003eSearchbug Criminal Records API\u003c\/strong\u003e (\u003ccode\u003eapi_crm\u003c\/code\u003e) and retrieves the response as JSON.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFlattens the API response\u003c\/strong\u003e so each offense\/crime details record becomes \u003cstrong\u003eone row\u003c\/strong\u003e in your sheet. If no results are found, it emits a single \u003cstrong\u003eNORESULTS\u003c\/strong\u003e row.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends rows to Google Sheets\u003c\/strong\u003e—writing each flattened record to the Google Sheets spreadsheet under the \u003cstrong\u003e“Criminal Records”\u003c\/strong\u003e sheet\/tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRun structured criminal record checks as part of \u003cstrong\u003escreening workflows\u003c\/strong\u003e and store results for review in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eProvide a self-serve form experience for operators, then automatically log outcomes per offense for reporting.\u003c\/li\u003e\n  \u003cli\u003eCentralize Searchbug Criminal Records API results for teams that need searchable, spreadsheet-based tracking.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ tech stack:\u003c\/strong\u003e set, code, sticky note, form trigger, HTTP request, Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAPI integration:\u003c\/strong\u003e HTTP request to \u003cstrong\u003eSearchbug Criminal Records API (api_crm)\u003c\/strong\u003e using \u003cstrong\u003eCO_CODE\u003c\/strong\u003e and \u003cstrong\u003ePASS\u003c\/strong\u003e in the request body.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets output:\u003c\/strong\u003e append into a specified spreadsheet ID and the \u003cstrong\u003eCriminal Records\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHeader mapping:\u003c\/strong\u003e create sheet headers that match the mapped fields (e.g., \u003ccode\u003erecord_id\u003c\/code\u003e, \u003ccode\u003efull_name\u003c\/code\u003e, \u003ccode\u003ecase_number\u003c\/code\u003e, \u003ccode\u003eoffense_code\u003c\/code\u003e, \u003ccode\u003edisposition\u003c\/code\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eAfter setup, activate the workflow and share the generated form URL with the people who should run Searchbug Criminal Records lookups.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45824201588915,"sku":"N8N-18174","price":47.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/O6XgkdrWA7JMX-2OPDsWM_HRz5IxAh.png?v=1786612114","url":"https:\/\/buyflowscripts.com\/products\/searchbug-criminal-records-api-to-google-sheets-n8n-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}