Search criminal records with Searchbug and log results to Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 13 nodes and runs when someone submits an n8n form (“Criminal Records Search”). Along the way it connects Google Sheets. It also calls data.searchbug.com over HTTP.
How it runs
Trigger: When someone submits an n8n form (“Criminal Records Search”).
- Single or Bulk? (If): checks a condition and branches into true / false
- Normalize Input (Edit Fields (Set)): sets 7 fields: First Name, Last Name, Middle Name…
- Extract CSV (Extract from File): extracts data from a file
- Set Search Input (Edit Fields (Set)): sets 7 fields: firstName, lastName, middleName…
- Validate Input (If): checks a condition and branches into true / false
- Searchbug Criminal Records API (HTTP Request): calls data.searchbug.com (POST)
- Set Invalid Row (Edit Fields (Set)): sets 36 fields: record_id, full_name, first_name…
- Flatten Results (Code): runs custom JavaScript code
- Save Detail (Google Sheets): append
- Classify Severity (Edit Fields (Set)): sets 1 field: severity
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: data.searchbug.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- n8n Form Trigger
n8n-nodes-base.formTrigger - If
n8n-nodes-base.if - Extract from File
n8n-nodes-base.extractFromFile - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow collects a person’s details through an n8n form, searches the Searchbug Criminal Records API (apicrm), flattens the response into one row per offense, and appends the results to a Google Sheets tab. How it works 1. Receives a…