Log property search results from Searchbug into Google Sheets

Description

Quick overview
This workflow collects property search criteria via an n8n form, queries the Searchbug Property Search API (api_prop) for matching records, and appends detailed property fields (owner, parcel, values, mailing address, and land data) to a Google Sheets spreadsheet.

How it works
Receives a submission from an n8n Form where a user selects a search type and enters a search value and location.
Maps the selected search type to Searchbug’s SRCH code (A for address, P for parcel ID, O for owner name) and prepares the request inputs.
Sends a POST request to the Searchbug Property Search API endpoint and retrieves the property record as JSON.
Appends the returned property details to a specified Google Sheets tab as a new row.

Setup
Add your Searchbug CO_CODE and PASS values to the HTTP request body parameters used for the Searchbug API call.
Connect your Google Sheets credential and select your target spreadsheet (Document ID) and worksheet/tab name.
Create a header row in the target Google Sheets tab that matches the columns being written (the property fields mapped in the Google Sheets append step).